Senior Data Engineering Systems Analyst - AWS & ETL

Enroute; Gran Dinastía; On-site; MXN 900,000 - 1,400,000; Full time

Job summary

Enroute is seeking a Data Engineer to design, build and maintain data models, mappings, and ETL/ELT pipelines on AWS. You will work with business stakeholders to translate requirements into robust data solutions and ensure data quality and security across distributed systems.

The ideal candidate has strong SQL, Python and cloud data experience, plus a solid understanding of SDLC and Agile methodologies. Collaboration with cross-functional teams and thorough documentation are essential.

Qualifications

• Experience with data modeling, transformation and integration.
• Hands-on AWS/cloud-based data solutions experience.
• Strong knowledge of relational databases and SQL.
• Proficiency in Python for data processing, querying and automation.
• Hands-on ETL/ELT processes and data pipelines.
• Experience with data mapping and transformation logic.
• Understanding of SDLC and Agile methodologies.
• Familiarity with secure data handling of financial data and PII.

Responsibilities

• Collaborate with business stakeholders to translate needs into technical requirements and solutions.
• Design, develop and maintain data models, data mappings and transformation logic for source-to-target integration.
• Build, test, and maintain ETL/ELT processes and data pipelines on AWS.
• Develop and optimize SQL queries for data analysis, validation and troubleshooting.
• Use Python to process, validate, query and automate data workflows.
• Analyze system architecture diagrams to identify data exchange points between microservices and distributed systems.
• Create and maintain documentation including data flows, mappings, user stories and acceptance criteria.
• Participate in Agile processes (Scrum/Kanban) and manage tasks in Jira.
• Manage and maintain code and documentation using GitHub or other VCS.

Skills

Data modeling

Data transformation

Data integration

AWS

SQL

Python

ETL/ELT

Data mapping

System architecture

SDLC

Agile (Scrum/Kanban)

Jira

GitHub

Data security & PII

Tools

GitHub

Jira

Job description

Enroute is seeking a Data Engineer to design, build and maintain data models, mappings, and ETL/ELT pipelines on AWS. You will work with business stakeholders to translate requirements into robust data solutions and ensure data quality and security across distributed systems.

The ideal candidate has strong SQL, Python and cloud data experience, plus a solid understanding of SDLC and Agile methodologies. Collaboration with cross-functional teams and thorough documentation are essential.