Data Engineer - Source AI

Who You'll Work With

Driving lasting impact and building long-term capabilities with our clients is not easy work. You are the kind of person who thrives in a high performance/high reward culture - doing hard things, picking yourself up when you stumble, and having the resilience to try another way forward.

In return for your drive, determination, and curiosity, we'll provide the resources, mentorship, and opportunities you need to become a stronger leader faster than you ever thought possible. Your colleagues—at all levels—will invest deeply in your development, just as much as they invest in delivering exceptional results for clients. Every day, you'll receive apprenticeship, coaching, and exposure that will accelerate your growth in ways you won’t find anywhere else.

When you join us, you will have:

• Continuous learning: Our learning and apprenticeship culture, backed by structured programs, is all about helping you grow while creating an environment where feedback is clear, actionable, and focused on your development. The real magic happens when you take the input from others to heart and embrace the fast-paced learning experience, owning your journey.
• A voice that matters: From day one, we value your ideas and contributions. You’ll make a tangible impact by offering innovative ideas and practical solutions. We not only encourage diverse perspectives, but they are critical in driving us toward the best possible outcomes.
• Global community: With colleagues across 65+ countries and over 100 different nationalities, our firm’s diversity fuels creativity and helps us come up with the best solutions for our clients. Plus, you’ll have the opportunity to learn from exceptional colleagues with diverse backgrounds and experiences.
• World-class benefits: On top of a competitive salary (based on your location, experience, and skills), we provide a comprehensive benefits package to enable holistic well-being for you and your family.
  
  

Your Impact

You will be part of the Source AI team and will have the opportunity to develop a deep understanding of the domain/function.

Source AI is a Gen AI fueled strategic category management platform within the Operations practice. It combines internal and external data with McKinsey’s functional and technological industrial expertise to empower category managers to make informed real-time decisions and unlock new opportunities. It is one of the fastest growing solutions in McKinsey, offering one of a kind exposure to define the future of procurement powered by AI.

The Source AI team works with clients globally to deliver value for procurement functions supported by McKinsey’s extensive expert network. The team you would join is based out of Gurgaon. You will work closely with consultants and senior leaders serving clients in North America, Europe, Asia and the Middle East.

As a Data Engineer in Source AI you will have deep expertise in Snowflake and modern data architecture, hands on experience building high-performance data pipelines, ensuring data quality, managing migrations, and handling multiple Snowflake environments in a secure and efficient manner. This is a key role to scale our data ecosystem across domains and geographies.

You will collaborate with cross-functional teams to enhance the platform, ensuring seamless client deployment and continuous upgradation of functionalities, as per client demands. You will lead the analyses on key spending categories to identify opportunities through solutions and work with the practice leaders and experts in different regions to continuously build a solution with new functionalities and knowledge. You will connect with external market solutions and establish partnerships that can deliver value to both parties. As you grow in the role, you will mentor analysts on topics related to procurement analyses and delivery of solutions for clients.

Your Qualifications and Skills

• 4+ years of experience in data engineering, with 3+ years focused on Snowflake
• Strong proficiency in SQL (ANSI, Snowflake dialect) and Python for scripting and transformations
• Expertise in managing Snowflake features like Warehouses, Snowpipe, Streams, Tasks, and Secure Views
• Proven ability to design and maintain end-to-end data pipelines using Snowflake and Amazon S3
• Skilled in optimizing Snowflake performance through clustering, materialized views, and query profiling
• Experience with CI/CD pipelines for Snowflake using tools like GitHub Actions
• Certified SnowPro Core and/or SnowPro Advanced: Data Engineer
• Knowledge of data governance frameworks, including PII handling, GDPR, and HIPAA
• Proficiency in working with semi-structured data formats (JSON, Avro, Parquet) in Snowflake
• Experience integrating Snowflake with BI tools and downstream applications securely
• Demonstrated success in leading data migration from legacy systems to Snowflake
• Strong understanding of data quality frameworks, including validation and anomaly detection