15 days ago
Aguascalientes, MexicoMid Level / Senior
Responsibilities
- Design and develop data pipelines using Azure Data Factory.
- Implement ETL and ELT processes for integrating data from multiple sources, applications, and enterprise systems.
- Design Azure-based data storage solutions and scalable data transformation and loading processes.
- Administer, optimize, and monitor Snowflake environments, queries, workloads, and resource consumption.
- Design dimensional data models, schemas, databases, and analytical reporting environments.
- Configure and maintain data-load orchestration processes and resolve pipeline and data-platform incidents.
- Implement data-quality, validation, security, governance, availability, and reliability controls.
- Monitor production data-integration processes and troubleshoot performance issues.
- Automate data-integration and transformation processes.
- Participate in data-platform migration, modernization, architecture, and optimization initiatives.
- Document architectures, processes, and technical components.
- Collaborate with BI, Analytics, Data Science, business, and technology teams.
Requirements
- 4 to 8 years of experience in Data Engineering.
- Experience with Azure Data Factory, Snowflake, and Microsoft Azure.
- Experience developing ETL and ELT processes, enterprise data integrations, and large-scale data pipelines.
- Advanced SQL skills, including query optimization and performance tuning.
- Experience with data warehousing, dimensional data modeling, data orchestration, and cloud data architectures.
- Experience administering Snowflake objects and designing Snowflake schemas and databases.
- Experience with Azure Data Lake Storage, Azure Synapse Analytics, Databricks, Python, PySpark, Git, Azure DevOps, and Power BI.
- Experience with monitoring and troubleshooting data processes, data quality, cloud data security, and data governance.
- Experience with migration or modernization projects involving data platforms.
- Knowledge of modern analytical solutions and integration architectures.
- Ability to work autonomously on Data Engineering projects.
- Strategic technical leadership, architectural thinking, business perspective, stakeholder influence, negotiation, communication, and complex problem-solving skills.
Benefits
- Hybrid work arrangement in Mexico City or Estado de México.
- Competitive compensation and benefits above those required by law.
- Collaborative consulting environment with functional, technical, and business specialists.
- Recruitment and onboarding support, career planning, and professional development opportunities.
- Work with a global organization operating across more than 50 countries.
About Capgemini
Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.