Data Engineer

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

Benefits offered by this job

Learning opportunities

Global team

Well-being programs

Job summary

Capgemini is seeking a Senior Data Engineer to drive a data modernization initiative for a leading financial services client. The role centers on transforming legacy SQL Server environments to scalable cloud-based platforms, and building robust ETL pipelines with Airflow, Snowflake and Databricks.

You will design data models, optimize SQL queries, and ensure data quality and governance across multi-cloud environments.

Qualifications

• 5+ years of experience in Data Engineering.
• Advanced expertise in SQL with a focus on query optimization, data transformation, and performance tuning.
• Proven experience designing and developing ETL and data processing solutions.
• Strong ability to analyze, troubleshoot, and understand complex data pipelines and workflows.

Responsibilities

• Design, develop, and optimize scalable ETL and data processing pipelines.
• Lead the migration of legacy SQL Server environments to modern cloud-based data platforms.
• Develop, optimize, and maintain complex SQL queries for data transformation, reporting, and performance improvement.
• Build, schedule, and maintain data workflows using Apache Airflow.
• Design and develop data processing solutions using Python.
• Create and optimize data models, including schema design, partitioning strategies, and performance tuning.
• Analyze, troubleshoot, debug, and enhance existing data pipelines and integrations.
• Ensure high levels of data quality, integrity, reliability, and governance across platforms.
• Collaborate with data architects, analysts, business stakeholders, and engineering teams to deliver business-critical data solutions.

Skills

SQL

ETL pipelines

Airflow

Python

Snowflake

Hive

Databricks

Tools

Snowflake

Hive

Databricks

Job description

**Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.****Your Role**As a **Senior Data Engineer at Capgemini**, you will play a key role in a strategic data modernization initiative for a leading financial services organization. You will help transform legacy data environments into modern, scalable data platforms by leveraging technologies such as Snowflake, Hive, Databricks, and Airflow.This position requires a highly experienced and self-driven professional capable of rapidly understanding complex data ecosystems, optimizing data workflows, and delivering immediate value in a fast-paced environment with critical business impact.**Responsibilities & Scope*** Design, develop, and optimize scalable **ETL and data processing pipelines**.* Lead the migration of legacy **SQL Server environments** to modern cloud-based data platforms.* Develop, optimize, and maintain complex **SQL queries** for data transformation, reporting, and performance improvement.* Build, schedule, and maintain data workflows using **Apache Airflow**.* Design and develop data processing solutions using **Python**.* Create and optimize data models, including schema design, partitioning strategies, and performance tuning.* Analyze, troubleshoot, debug, and enhance existing data pipelines and integrations.* Ensure high levels of **data quality, integrity, reliability, and governance** across platforms.* Collaborate with data architects, analysts, business stakeholders, and engineering teams to deliver business-critical data solutions.* Identify bottlenecks, performance issues, and opportunities for improvement within complex data ecosystems.* Support the adoption of modern data engineering best practices and scalable architecture patterns.**Your Profile*** **Results-driven professional** – Capable of delivering value quickly in high-impact and fast-paced environments.* **Strong analytical thinker** – Experienced in solving complex data challenges and debugging sophisticated workflows.* **Self-starter** – Comfortable working independently with minimal supervision.* **Problem solver** – Able to investigate root causes and implement sustainable solutions.* **Collaborative team player** – Effectively partners with technical and business stakeholders.* **Continuous learner** – Passionate about modern data technologies and engineering best practices.**Qualifications & Preferred Skills****Required Skills*** 5+ years of experience in **Data Engineering**.* Advanced expertise in **SQL** with a strong focus on query optimization, data transformation, and performance tuning.* Proven experience designing and developing **ETL and data processing solutions**.* Strong ability to analyze, troubleshoot, and understand complex data pipelines and workflows.* Experience working independently and rapidly ramping up within new technical environments.* Strong understanding of data integration, data quality, and data lifecycle management.* Excellent analytical, problem-solving, and communication skills.**Preferred Skills*** Hands-on experience with **Snowflake and/or Hive** (experience with at least one is highly preferred).* Strong proficiency in **Python** for data engineering and automation tasks.* Experience building and maintaining workflows using **Apache Airflow**.* Exposure to **Databricks** and modern data lakehouse architectures.* Solid understanding of **data warehousing concepts**, dimensional modeling, and large-scale data processing.* Experience supporting cloud-based data platforms and modernization initiatives.* Familiarity with Agile methodologies and modern software development practices.**What You'll Love*** Opportunity to participate in a large-scale data modernization and transformation program.* Exposure to modern data technologies and enterprise-scale data platforms.* Access to industry-leading learning platforms, certifications, and professional development opportunities.* Collaborative, diverse, and innovative work environment.* Opportunities to work alongside highly skilled data and technology professionals globally.* Well-being initiatives and programs designed to support your personal and professional growth.**Need to Know****Career Development in Spanish & English:** Access to training, certifications, mentorship programs, and learning opportunities designed to support your bilingual professional growth.**Community Engagement:** Participate in volunteering activities, technology communities, networking events, and knowledge-sharing sessions across Capgemini.**About Capgemini**Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. It is a responsible and diverse organization with more than 340,000 team members in over 50 countries.With a strong heritage of more than 55 years, Capgemini helps clients unlock the value of technology through end-to-end services and solutions, leveraging capabilities in strategy and design, engineering, AI, generative AI, cloud, data, and digital transformation.At Capgemini Mexico, we are committed to fostering a diverse and inclusive workplace where everyone has equal opportunities. We welcome applications from all qualified candidates and evaluate them based on merit, skills, qualifications, and experience relevant to the role.