Data Warehouse Engineer

New Combin S.R.L.; México; Remote; MXN 450,000 - 700,000; Full time

Job summary

NewCombin, a data-driven tech consultancy, seeks a data engineer to design, build, and maintain Python-based data assets orchestrated with Dagster, and to develop dbt models for clean, tested data transformations in Snowflake.

You will build reliable data pipelines, integrate third‑party APIs, enforce RBAC, and organize code in GitHub. Collaboration with teams across LATAM and beyond is essential to deliver scalable data solutions.

Qualifications

• 2–3 years of professional experience in data engineering or data warehousing.
• Intermediate to advanced Python skills, including object-oriented programming and dataclasses.
• Hands-on experience with Snowflake or equivalent cloud data warehouse, including RBAC.
• Intermediate to advanced SQL skills, including CTEs, window functions, and recursive queries.
• Experience building integrations with third‑party APIs and vendor systems.
• Familiarity with AWS IAM and S3.
• Familiarity with GitHub workflows: branching, PRs, secrets/actions.
• Familiarity with HTML, CSS, and Excel for data work.
• LATAM-based or located in LATAM region.
• Experience with dbt for data transformation and modeling.
• Experience with Dagster, Airflow, or similar orchestration tools.

Responsibilities

• Design, build, and maintain Python-based data assets orchestrated with Dagster across ingestion, transformation, and loading.
• Develop and maintain dbt models to support clean, tested, and documented data transformations.
• Build and maintain integrations with third-party APIs and vendor systems.
• Organize and version code in GitHub with proper branching, protection, and PR reviews; monitor and alert pipelines.
• Design data models and schemas in Snowflake with RBAC-based access control.
• Organize and automate tasks on AWS.
• Collaborate with technical and non-technical stakeholders to translate data needs into pipelines, models, and reports.
• Contribute to long-term evolution of the data platform toward data science and ML initiatives.

Skills

Python programming

SQL skills

Team collaboration

Tools

Snowflake

Dagster

Airflow

GitHub

AWS

Job description

Our name, NewCombin, refers to the “new combination” between professionals with extensive experience and experience with those young people with a strong disruptive imprint.

It is no coincidence: Marcelo, Nicolás and Ian, the founding partners, are a father, a son and a friend united by the ambition to empower organizations through technology.

Since 2017 we have sought to merge these characteristics into our professional profiles to provide unique and quality solutions to our clients, so that we can mutually nurture each other and learn together along the way.

If you are interested in taking a challenge that:

• Allows you to work with multiple industries and learn from each of them
• Boosts your English by working with teams located around the world
• Allows you to see the direct impact of your work on the users of the solution you created…

This position is for you!

In this role, you’ll get to:

• Design, build, and maintain Python-based data assets orchestrated with Dagster, covering ingestion, transformation, and loading across internal and external data sources
• Develop and maintain dbt models to support clean, tested, and documented data transformations within the warehouse
• Build and maintain integrations with third-party APIs and vendor systems to construct reliable data pipelines
• Implement best practices to standardize and improve the integrity and reliability of extraction, transformation, loading, and storage processes, including: Organizing and versioning code in GitHub, with appropriate branching, protection, and PR review practices; Logging and monitoring, Alerting for failed or degraded pipelines
• Design and maintain data models and schemas within Snowflake, applying sound RBAC and access-control practices
• Organize and automate tasks and infrastructure on AWS
• Partner with both technical and non-technical stakeholders across departments to understand data needs and translate them into pipelines, models, and reports
• Participate in the evaluation and integration of new tools and products that support the firm’s business processes
• Contribute to the long‑term evolution of the data platform as the team takes on higher‑level initiatives such as data science and machine learning

We are looking for you if you

• Have 2–3 years of professional experience, ideally in data engineering or data warehousing.
• Have intermediate to advanced Python skills, including object‑oriented programming, dataclasses, and exception handling. Experience with asynchronous programming is a plus.
• Have hands‑on experience with Snowflake or an equivalent cloud data warehouse, including data modeling, data loading, and role‑based access control (RBAC).
• Have intermediate to advanced SQL skills, ideally including CTEs, window functions, and recursive queries.
• Have experience building integrations with third‑party APIs and vendor systems to develop reliable data pipelines.
• Are familiar with AWS, particularly IAM and S3.
• Are familiar with GitHub, including branching, branch protection, merging, pull requests, and secrets/actions.
• Are familiar with HTML, CSS, and Excel, including sorting and filtering.
• Are based in LATAM.
• Experiencewith dbt for data transformation and modeling.
• Experience with Dagster, Airflow, or a comparable orchestration tool.