Data Engineer (Snowflake)

Capgemini; Aguascalientes; Remote; MXN 800,000 - 1,100,000; Full time

Job summary

Capgemini Mexico is seeking a data engineer to build and optimize modern data pipelines using Snowflake, SQL, Python, and dbt. You will own end-to-end ELT/ETL workflows, troubleshoot data issues, and deliver production-ready data products for analytics, reporting, and AI initiatives.

You will collaborate with data architects, analytics teams, and platform engineers to scale data solutions, improve query performance and cost efficiency, and contribute to CI/CD practices in a fast-growing,

Qualifications

• 4+ years of total Data Engineering experience.
• 2+ years hands-on Snowflake experience in enterprise environments.
• Advanced SQL and query optimization skills.
• Python development experience building reusable data pipelines.
• Expertise with DBT and ELT/ETL processes.
• Deep understanding of data modeling and data warehousing.
• Experience with GitHub, CI/CD and data quality monitoring.
• Fluent English.

Responsibilities

• Build and optimize end-to-end data integration processes (ELT/ETL).
• Develop scalable data pipelines using Snowflake, SQL, Python and dbt.
• Improve Snowflake performance, warehouse utilization and cost efficiency.
• Collaborate with Data Architects, Analytics teams and Platform Engineers.
• Participate in production support, monitoring and CI/CD practices.

Skills

Advanced SQL

Python

Data engineering

GitHub & CI/CD

Problem solving

Tools

Snowflake

dbt

Matillion

GitHub

GitHub Actions

Job description

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.Job DescriptionYour ProfileBuild and optimize modern data pipelines using Snowflake, SQL, Python, dbt, and Matillion, ensuring reliable and scalable data solutions that support enterprise reporting, analytics, and AI initiatives.Own end-to-end data integration processes, including developing ELT/ETL workflows, troubleshooting data issues, improving data quality, and maintaining production-ready data products.Drive Snowflake platform performance and efficiency, identifying opportunities to improve query execution, warehouse utilization, scalability, and cost optimization across the data ecosystem.Work closely with cross-functional teams including Data Architects, Analytics teams, Platform Engineers, and business stakeholders to translate requirements into robust and reusable data solutions.Participate in production support and continuous improvement efforts, performing root cause analysis, automating manual processes, enhancing monitoring capabilities, and contributing to CI/CD and engineering best practices.Your Role4+ years of total Data Engineering experience with 2+ years of hands-on Snowflake experience in enterprise environments. Including data warehouse design, performance tuning, workload optimization, cost management, and building scalable enterprise data solutions.Advanced SQL and query optimization skills, with the ability to design complex data transformations, troubleshoot performance bottlenecks, and optimize large-scale datasets efficiently.Python and data engineering development experience, building reusable frameworks, automation solutions, and production-grade data pipelines.Expertise with DBT, including designing, developing, testing, and maintaining robust ELT/ETL processes following software engineering best practices.Deep understanding of data modeling, data warehousing, and production support, combined with experience using GitHub, CI/CD pipelines, root cause analysis, and data quality monitoring to deliver reliable enterprise data products.Fluent English levelWhat you'll loveWork on meaningful projects that use technology to solve real-world challenges.Be part of a company that values sustainability, inclusion, and digital equity.Contribute to building a better future for people, planet, and society.Need to knowThis position can be working from any state of MexicoCapgemini 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 over 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.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.