Data WareHouse Engineer

AI overview

Engage in designing and maintaining scalable data warehouse solutions while optimizing workflows, enhancing automation, and ensuring data quality across analytics teams.

The key to our success is simple; we deliver the highest quality, on time, with passion and commitment, and live every day by a set of great values. We've built a company that fosters long-term careers in an environment of continuous learning, with cutting-edge benefits, tools, and resources. In addition, certifications that endorse our company as a great place to work.

 

Responsibilities

  • Design, build, and maintain scalable, high-performance data warehouse solutions using modern cloud and on-premise technologies.
  • Develop, schedule, and monitor robust ETL/ELT pipelines using tools such as Airflow (orchestration) and dbt (data transformation).
  • Optimize data models, queries, and storage strategies to improve performance, scalability, and system reliability.
  • Implement and enforce data quality, validation, and governance standards to ensure accuracy, consistency, and compliance.
  • Collaborate with data analysts, engineers, and business stakeholders to translate analytical requirements into efficient data solutions.
  • Continuously enhance and automate data workflows by leveraging Airflow, dbt, and other modern frameworks to drive efficiency and continuous improvement.

Requirements

  • 3+ years of experience designing, developing, and maintaining data warehouses and ETL/ELT workflows in production environments.
  • Proficiency in SQL and strong experience with data modeling, schema design, and performance optimization.
  • Proven hands-on experience with modern data engineering tools (e.g., Airflow, dbt) and AWS cloud-based data platforms (e.g., Snowflake, Redshift).
  • Hands-on experience (on business projects) with programming languages such as Python, C/C++, or Java.
  • Strong analytical and problem-solving skills, with the ability to work collaboratively across cross-functional teams in a fast-paced, data-driven environment.
Nice to Have
  • Experience using Excel, Google Sheets, and Slack.
  • AWS Cloud Practitioner or Engineer certificates.
  • High-speed Wi-Fi connection.
  • Ability to work US timezone shifts (e.g., EST, CST, MST, or PST).

 

 

 

#LI-REMOTE

 

 


About us

AssureSoft is a multinational software development and information technology company providing strategic consulting, technology services, and outsourcing business processes. We work to innovate and create quality software with motivated, passionate, and qualified teams that develop in an environment of professional, stable growth and continuous learning.

Inclusive Opportunities for Every Talent. At AssureSoft, we believe that true innovation is born from diversity—of ideas, experiences, and perspectives. That’s why our hiring practices are inclusive and reflect a firm commitment to equity and equal opportunity.
Here, every person—regardless of origin, gender, orientation, or beliefs—finds a space to grow, contribute, and be valued not only for their talent, but also for who they are.

What sets us apart

  • Great Place To Work certification.
  • A company with more than 15 years of experience.
  • Work with world-class clients and long-term projects.
  • English scholarships for an external institute.
  • English classes with company teachers.
  • State-of-the-art tools and resources.
  • Certifications for your professional growth.
  • Recreation and leisure activities.
  • Compliance with the regulations and labor rights of your region.

Retention of your personal information: AssureSoft will retain your personal information for as long as necessary to fulfill the purposes for which it was collected or as necessary to comply with our legal obligations, resolve disputes, and maintain appropriate business records. Once the purpose has been fulfilled, your personal information will be retained and blocked due to the possibility of legal and governmental requirements, and until the status of limitations has run out.

Important Notice Regarding Personal Information:  If you do not want your personal and professional information to be retained in our database, please send your request for data removal to [email protected].

Perks & Benefits Extracted with AI

  • Education Stipend: English classes with company teachers.
Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Engineer Q&A's
Report this job
Apply for this job