ABL - Azure Data Factory Engineer

Description

Job Summary: We are seeking a Senior Data Engineer with experience in designing, building, and optimizing cloud-based data platforms on Microsoft Azure, as well as technical leadership to drive the evolution of the data team. Key Highlights: 1. Design, construction, and optimization of cloud-based data platforms 2. Technical leadership and evolution of the data team 3. Collaborative work, analysis, design, and development of solutions **Recruiter:** Marisol Zavala **Location:** Mexico City **Industry:** Insurance **Work Modality: Hybrid in Mexico City** **Your Responsibilities:** * Senior Data Engineer with solid experience in designing, building, and optimizing cloud-based data platforms on Microsoft Azure, with a primary focus on Azure Data Factory (ADF) as the main integration and orchestration tool. * Capable of working with modern data architectures, large-scale processing, and enabling advanced analytics for decision-making. Additionally, possesses technical leadership skills and the ability to drive the evolution of the data team. **Required Knowledge and Experience:** * Technical specialization in Azure: Azure Synapse, Azure Data Factory (primary), ADLS Gen2 (Data Lake), Azure SQL Database, Cosmos DB, Data Fabric (desirable) * Integration and pipelines (ADF): * Design and development of complex pipelines (ETL/ELT) Integrations: On\-premise \- Cloud \- Cloud * Handling multiple formats: Databases, CSV, APIs * ADF expertise: Data flows, Logging, Alerts, Git integration * Data architecture: Dimensional modeling, analytical model design * Modern architectures: Data Lakehouse, Data Warehouse, Medallion Architecture (Bronze, Silver, Gold), Lambda Architecture (Near real\-time \+ batch) * Data processing: Advanced SQL (T\-SQL, optimization, analytical queries) * Python (focused on data transformation) * Data security and governance: Enterprise security: Azure Active Directory, Managed Identities, Key Vault * Access control: RBAC, ACLs in Data Lake, **Skills:** Working under pressure, high-quality output, results-oriented **Your Career at Capgemini** * Working in a team environment, our consultants focus on analysis, design, and development of technology-based solutions for Capgemini clients. * You will collaborate with functional, technical, and business specialists to help develop implementation and integration of innovative solutions and systems, including methodologies, techniques, and tools. * You will contribute responsibly and promptly to client satisfaction by delivering services and products that generate added value. * Capgemini offers competitive compensation and benefits exceeding statutory requirements. * Our global headquarters are in Paris, France, and we operate in over 50 countries. We have more than 340,000 professionals in Mexico, located in Mexico City, Aguascalientes, and Monterrey. * Capgemini has developed proprietary global methodologies: Collaborative Business Experience and Rightshore. **You’ll Love Working at Capgemini Because:** * We offer a unique recruitment and onboarding experience and support you in building the foundation of your professional career and skills. * We provide a collaborative work environment grounded in our seven core values: Honesty, Boldness, Trust, Freedom, Team Spirit, Humility, and Fun. * We foster an environment that enables you to plan and develop your career. *“At Capgemini Mexico, our goal is to attract top talent and cultivate a diverse and inclusive workplace; therefore, we do not discriminate based on race, gender, sexual orientation, gender identity or expression, or any other personal characteristic. All applications are welcome and will be considered for selection based solely on the candidate’s merit, qualifications, and experience relevant to the position. For validation purposes, we will securely use your data—including but not limited to video images or screenshots—during the selection, hiring, and/or onboarding processes. For your security, please review our privacy notice at:* *https://www.capgemini.com/mx\-es/aviso\-de\-privacidad\-para\-candidatos\-a\-ocupar\-una\-vacante/*