Choosing Capgemini means choosing a company where you will be empowered to shape your career, supported by a collaborative global community, and able to help leading organizations unlock the value of technology while building a more sustainable and 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 transform legacy data environments into modern, scalable data platforms using technologies such as Snowflake, Hive, Databricks, and Airflow.
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 data quality, integrity, reliability, and governance across platforms.
- Collaborate with data architects, analysts, business stakeholders, and engineering teams.
- Identify bottlenecks, performance issues, and improvement opportunities within complex data ecosystems.
- Support modern data engineering best practices and scalable architecture patterns.
Your Profile
- Results-driven, self-starting professional who can deliver value quickly in high-impact environments.
- Strong analytical, problem-solving, communication, and collaboration skills.
- Comfortable working independently with minimal supervision.
- Passionate about modern data technologies and engineering best practices.
Qualifications & Preferred Skills
- 5+ years of experience in Data Engineering.
- Advanced SQL expertise, including query optimization, data transformation, and performance tuning.
- Experience designing and developing ETL and data processing solutions.
- Experience analyzing complex data pipelines and workflows.
- Strong understanding of data integration, data quality, and data lifecycle management.
- Preferred experience with Snowflake or Hive, Python, Apache Airflow, Databricks, data lakehouse architectures, data warehousing, dimensional modeling, cloud data platforms, Agile methodologies, and modern software development practices.
What You'll Love
- Participation in a large-scale data modernization and transformation program.
- Exposure to modern data technologies and enterprise-scale data platforms.
- Learning platforms, certifications, and professional development opportunities.
- Collaborative, diverse, and innovative work environment.
- Opportunities to work with skilled data and technology professionals globally.
- Well-being initiatives supporting personal and professional growth.
About Capgemini
Capgemini is a global business and technology transformation partner with more than 340,000 team members in over 50 countries. Capgemini Mexico is committed to a diverse and inclusive workplace with equal opportunities for qualified candidates.