ADF Engineer

About Capgemini Group

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 300,000 team members in nearly 50 countries. With its strong 50-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms.

We are seeking a skilled and motivated Azure Data Engineer with strong expertise in Microsoft BI technologies. The ideal candidate will have hands-on experience in Azure Data Factory (ADF), SQL Server, Azure Data Lake, and Azure Synapse Analytics. This role demands a blend of software engineering, data architecture, and ETL development skills to design and implement scalable data solutions in a cloud-first environment. 

REQUIREMENTS

• 5+YOE working in BigData roles, ETL development process
• Hands-on in Azure, Azure Data Factory (ADF) pipeline development. Building/maintaining pipelines, mapping data flows, parameterization, triggers, integration runtimes (self-hosted & Azure), and CI/CD for ADF.
• Advanced SQL/T‑SQL and ETL skills. Complex joins, window functions, CTEs, MERGE patterns, incremental loads, SCD handling, and performance tuning (indexes, stats, query plans).
• Experience designing lake zones (raw/bronze, curated/silver, semantic/gold), Synapse SQL pools (serverless/dedicated), PolyBase/Copy, partitioning strategies, and cost/performance tradeoffs.
  Power BI development, Dataset design, DAX for measures, row-level security (RLS), performance analyzer usage,
• Advanced English level

RESPONSIBILITIES

• Design, develop, and maintain data pipelines using Azure Data Factory (ADF). 
• Write efficient SQL/T-SQL queries for data extraction, transformation, and loading (ETL). 
• Develop and optimize data models in Azure SQL Server and Azure Synapse Analytics. 
• Implement data partitioning strategies and performance tuning for large-scale data warehouses. 
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions. 
• Work within Agile teams, participating in sprint planning, daily stand-ups, and retrospectives. 
• Build and maintain dashboards and reports using Power BI. 
• Ensure data quality, integrity, and security across all data platforms. 
• Automate data workflows and monitor pipeline performance and reliability. 
• Document technical solutions and maintain version control using tools like Git. 

What you will love about working with us:

• At Capgemini we’re always looking ahead.
• We reimagine possibilities, and we innovate with technology to bring ideas to life.
• We encourage flexibility in how, when, and where people get their work done, allowing a better work-life balance, and greater empowerment.
• They partner with their managers to find an arrangement that works best for their role and their circumstances.
• We offer game-changing programs to accelerate the growth of our people and the development of their expertise. 

What you need to know about what we offer:

• Excellent compensation and benefits
• Career path, trainings and real growth opportunities
• Engaging and challenging projects.
• Excellent work environment and culture.
• Open and Effective management.
• Highly professional and collaborative teams.

At Capgemini Mexico, we aim to attract the best talent and are committed to creating a diverse and inclusive work environment, so there is no discrimination based on race, sex, sexual orientation, gender identity or expression, or any other characteristic of a person. All applications welcome and will be considered based on merit against the job and/or experience for the position.