Remote Data Engineer — ETL Pipelines, Airflow & SQL

Agileengine; Xico; Presencial; MXN 1.436.000 - 2.027.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Growth without limits

Competitive compensation

100% remote

Descripción de la vacante

AgileEngine is seeking a Data Engineer to own ETL pipelines powering analytics for colleges and universities. You will design and maintain data workflows using SQL, Python, and Apache Airflow, moving data from source systems into a cloud data warehouse.

You will adapt shared pipelines for individual clients while maintaining clean code. Responsibilities include building ETL pipelines, extending data models, monitoring production data, and collaborating with client teams to deliver solutions.

Formación

• 3-4 years of experience in data engineering or a closely related software engineering role.
• Strong SQL, including complex joins, window functions, and dimensional/star-schema modeling.
• Strong Python programming skills.
• Hands-on Apache Airflow experience (DAGs, operators, scheduling, troubleshooting).
• Working knowledge of ETL patterns and cloud data warehouse design (Amazon Redshift or similar: Snowflake, BigQuery, Synapse).
• Git and GitLab for day-to-day version control.
• Docker / Docker Compose.
• Understanding of data management concepts.
• Ability to translate client and business requirements into SQL, configuration, and DAG changes.
• Upper-intermediate English level.

Responsabilidades

• Design, build, and maintain ETL pipelines and data workflows across multiple environments (development, staging, and production).
• Implement and extend data models and datasets to support analytical and reporting needs.
• Adapt and customize shared data pipelines for individual clients while maintaining a clean, reusable codebase.
• Monitor and support production data pipelines, investigate failures, and deliver fixes in a timely manner.
• Write and maintain database DDL, data validation queries, and deployment scripts.
• Contribute to platform modernization initiatives, including infrastructure upgrades and adoption of new data technologies.
• Collaborate with client teams, analysts, and stakeholders to gather requirements and deliver solutions.

Conocimientos

SQL

Python

English

Herramientas

Apache Airflow

Git/GitLab

Docker

Redshift

Descripción del empleo

AgileEngine is seeking a Data Engineer to own ETL pipelines powering analytics for colleges and universities. You will design and maintain data workflows using SQL, Python, and Apache Airflow, moving data from source systems into a cloud data warehouse.

You will adapt shared pipelines for individual clients while maintaining clean code. Responsibilities include building ETL pipelines, extending data models, monitoring production data, and collaborating with client teams to deliver solutions.