Senior Data Engineer — Modern Data Platform & Automation

Capgemini; Aguascalientes; On-site; MXN 600,000 - 900,000; Full time

Job summary

Capgemini Mexico is seeking a Senior Data Engineer to lead a data modernization initiative for a leading financial services client. You will transform legacy data environments into scalable data platforms using Snowflake, Hive, Databricks, and Airflow.

The role requires deep expertise in ETL, SQL optimization, and data governance, with the ability to collaborate with data architects, analysts, and engineers to deliver high-impact solutions.

Qualifications

• 5+ years of experience in Data Engineering.
• Advanced SQL and data transformation skills.
• Experience designing ETL and data processing solutions.
• Ability to analyze complex pipelines and troubleshoot quickly.

Responsibilities

• Design, develop, and optimize scalable ETL and data processing pipelines.
• Lead migration of legacy SQL Server environments to cloud-based platforms.
• Develop and optimize SQL queries for transformation, reporting, and performance.
• Build, schedule, and maintain data workflows with Apache Airflow.
• Develop data processing solutions using Python.
• Create and optimize data models, including partitioning and tuning.

Skills

SQL optimization

ETL pipelines

Data modeling

Python

Apache Airflow

Snowflake

Hive

Databricks

Tools

Apache Airflow

Snowflake

Databricks

Hive

Job description

Capgemini Mexico is seeking a Senior Data Engineer to lead a data modernization initiative for a leading financial services client. You will transform legacy data environments into scalable data platforms using Snowflake, Hive, Databricks, and Airflow.

The role requires deep expertise in ETL, SQL optimization, and data governance, with the ability to collaborate with data architects, analysts, and engineers to deliver high-impact solutions.