Data Engineer - ETL Pipelines, Airflow & Cloud DW (Remote)

AgileEngine, LLC.; Región Centro; Presencial; MXN 600.000 - 1.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Growth without limits

Competitive compensation

Flexibility: work 100% remotely with a

Meaningful, modern projects

Collaborative culture

Well-being & support

Descripción de la vacante

AgileEngine, LLC. is seeking a Data Engineer to own and optimize 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, ensure code quality, monitor production jobs, and collaborate with client teams and analysts to deliver scalable data 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.
• Hands-on Apache Airflow experience (DAGs, operators, scheduling, and troubleshooting failed jobs).
• Working knowledge of ETL patterns and cloud data warehouse design (Amazon Redshift or similar: Snowflake, BigQuery, Synapse).
• Git and GitLab (or GitHub/Bitbucket) 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.

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

Airflow

ETL

Cloud DW design

Redshift

Git

Docker

Herramientas

Tableau

PowerBI

Descripción del empleo

AgileEngine, LLC. is seeking a Data Engineer to own and optimize 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, ensure code quality, monitor production jobs, and collaborate with client teams and analysts to deliver scalable data solutions.