Senior Data Engineer: Build Scalable ELT/ETL Pipelines

Pediatric Associates; Monterrey; On-site; MXN 900,000 - 1,300,000; Full time

Job summary

Pediatric Associates in Monterrey is seeking a Data Engineer to build, maintain, and optimize ELT/ETL pipelines, data models, and transformation logic for analytics and operations.

You will work with analysts, data scientists, product managers, and stakeholders to translate requirements into robust cloud‑based solutions using SQL, Python, and modern data warehousing tools; emphasis on quality, governance, and scalable performance.

Qualifications

• 5–10 years of experience in data engineering or related fields.

Responsibilities

• Develop, maintain, and optimize scalable ELT/ETL pipelines using modern data engineering tools and frameworks.
• Implement and refine data models, schemas, and data structures to support analytics, reporting, and operational workloads.
• Participate in solution design discussions, contributing to data strategies and technical decisions.
• Create and maintain high‑quality SQL queries, transformation logic, and reusable data processing components.
• Ensure data quality by implementing validation rules, profiling checks, monitoring, and reconciliation processes.
• Collaborate with cross‑functional teams to gather requirements, troubleshoot issues, and deliver reliable data solutions.
• Monitor pipeline performance, address failures, and continuously improve reliability, cost, and scalability.
• Support data governance and security policies across cloud and on‑premise systems.
• Produce clear documentation and communicate technical concepts in a user‑friendly manner.
• Contribute to team best practices, standards, and process improvements.

Skills

SQL proficiency

Python programming

Analytical thinking

Communication

Data modeling

Tools

Azure Data Factory

Apache Spark

AWS Glue

Databricks

Snowflake

Azure Synapse

Databricks Asset Bundles (DABs)

Power BI

Job description

Pediatric Associates in Monterrey is seeking a Data Engineer to build, maintain, and optimize ELT/ETL pipelines, data models, and transformation logic for analytics and operations.

You will work with analysts, data scientists, product managers, and stakeholders to translate requirements into robust cloud‑based solutions using SQL, Python, and modern data warehousing tools; emphasis on quality, governance, and scalable performance.