Senior Data Engineer — AWS, ETL & Data Integration

Enroute; Monterrey; On-site; MXN 800,000 - 1,100,000; Full time

Job summary

Enroute is seeking a Data Engineer in Monterrey to design, develop and optimize data models, mappings, and ETL/ELT pipelines on AWS. You will collaborate with stakeholders, transform business needs into technical specifications, and ensure data integrity across distributed systems.

The role requires strong SQL and Python skills, experience with data integration, and a solid understanding of SDLC and Agile methodologies.

Qualifications

• Experience in data engineering, modeling and integration.
• Hands-on AWS and cloud data solutions experience.
• Strong SQL and relational database knowledge.
• Python for data processing, validation and automation.

Responsibilities

• Collaborate with stakeholders to translate business needs into technical requirements and solutions.
• Design, develop, and maintain data models, mappings, and transformation logic for source-target integration.
• Build, test, and maintain ETL/ELT processes and data pipelines on AWS.
• Develop and optimize SQL queries for data analysis and validation.
• Use Python to process, validate, query, and automate data workflows.
• Review system architecture diagrams to understand data exchanges across microservices.
• Create and maintain documentation including data flows, mappings, user stories, and acceptance criteria.
• Participate in Agile processes (Scrum/Kanban) with Jira tracking of activities and deliverables.
• Manage code and documentation with GitHub or other version control.
• Ensure secure handling of sensitive financial data and PII in governance compliance.
• Support testing and UAT by defining test scenarios and validating data integrity.
• Communicate project progress and risks to cross-functional teams and leadership.

Skills

Data engineering

AWS

SQL

Python

ETL/ELT

Data mapping

System architecture

GitHub

SDLC/Agile

Jira

PII security

Tools

Jira

GitHub

Job description

Enroute is seeking a Data Engineer in Monterrey to design, develop and optimize data models, mappings, and ETL/ELT pipelines on AWS. You will collaborate with stakeholders, transform business needs into technical specifications, and ensure data integrity across distributed systems.

The role requires strong SQL and Python skills, experience with data integration, and a solid understanding of SDLC and Agile methodologies.