Data Engineer

Capgemini; Aguascalientes; In loco; MXN 600.000 - 900.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

SQL optimization

ETL pipelines

Data modeling

Python

Apache Airflow

Snowflake

Hive

Databricks

Strumenti

Apache Airflow

Snowflake

Databricks

Hive

Descrizione del lavoro

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

• 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.