We are seeking a Senior Data Engineer with strong expertise in SQL Server, SSIS, Python, and modern data platforms to help modernize legacy ETL pipelines and data warehouse systems. This role focuses on analyzing SSIS packages, migrating them to modern data pipelines, and ensuring data integrity, scalability, and performance across the data platform. The ideal candidate has strong experience in data warehousing, ETL frameworks, SQL optimization, and distributed data technologies such as Hive or Trino.
Key Responsibilities
•Analyze and migrate legacy SSIS packages to modern ETL/ELT pipelines.
•Develop and maintain data pipelines using SQL and Python.
•Support data warehouse to data lake migration initiatives.
•Optimize SQL Server performance through query tuning, indexing, and partitioning.
•Design and maintain data warehouse models (fact/dimension tables, star/snowflake schemas, SCDs) and build data marts.
•Implement data validation, reconciliation, and quality checks to ensure data accuracy and reliability.
Required Qualifications
•5+ years of experience in Data Engineering or ETL development.
•Strong hands-on experience with SSIS and Microsoft SQL Server.
•Expertise in SQL performance tuning and database optimization.
•Proficiency in Python and SQL for data transformation and automation.
•Solid understanding of data warehouse architecture and dimensional modeling.
•Experience with distributed query engines such as Hive or Trino and knowledge of DB administration concepts (indexing, partitioning, backup/recovery).
Data engineers are responsible for building reliable and scalable data infrastructure that enables organizations to derive meaningful insights, make data-driven decisions, and unlock the value of their data assets.
The primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effectively to drive business outcomes.
Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.
Make it real | www.capgemini.com
