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, all while upholding our unwavering commitment to ethics and integrity. 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 join the Source AI team and build deep expertise in the product, domain, and client use cases.

You will bring strong Snowflake and modern data architecture expertise to build scalable, high-performance data pipelines, ensure data quality, manage migrations, and support secure multi-environment deployments. You will work directly on live client engagements alongside consultants and product leaders to scale the data ecosystem across domains and geographies.

You will collaborate across teams to enhance the platform, support client deployments, and build new capabilities based on client needs. Over time, you will also contribute to procurement-focused analyses, strengthen external partnerships, and mentor junior colleagues.

You will be expected to use modern AI-assisted development tools (e.g., Cursor, Claude, GitHub Copilot) in your daily workflow to prototype faster, ship more efficiently, and raise the bar on engineering output.

Source AI is a GenAI-powered strategic category management platform within McKinsey’s Operations practice. It combines internal and external data with McKinsey’s functional and technology expertise to help category managers make better real-time decisions and unlock new opportunities.

The team is based in Gurugram and works closely with consultants and senior leaders serving clients across North America, Europe, Asia, and the Middle East.

There is the opportunity to join at either the Data Engineer I or II level based on your experience.

Your Qualifications and Skills

SnowPro Core and/or SnowPro Advanced: Data Engineer certification preferred
3+ years of experience in data engineering, with strong Snowflake expertise and a builder mindset
Hands-on experience with AI-assisted development tools (e.g., Cursor, Claude Code, GitHub Copilot) to build MVPs, prototype data pipelines, and accelerate analysis
Comfort using LLMs and AI agents in day-to-day engineering for code generation, debugging, documentation, and data exploration
Strong proficiency in SQL (including Snowflake SQL) and Python for transformations, scripting, and automation
Expertise in building and managing end-to-end Snowflake pipelines using features such as Warehouses, Snowpipe, Streams, Tasks, and Secure Views, with Amazon S3 integration
Skilled in Snowflake performance optimization, including clustering, materialized views, and query profiling
Experience with CI/CD for Snowflake using tools such as GitHub Actions
Knowledge of data governance, secure data integration, and compliance requirements such as PII handling, GDPR, and HIPAA
Proficiency in working with semi-structured data formats such as JSON, Avro, and Parquet in Snowflake
Demonstrated success migrating data from legacy systems to Snowflake
Strong understanding of data quality frameworks, including validation, monitoring, and anomaly detection