Who You&aposll 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&aposll provide the resources, mentorship, and opportunities you need to become a stronger leader faster than you ever thought possible. Your colleaguesat all levelswill invest deeply in your development, just as much as they invest in delivering exceptional results for clients. Every day, you&aposll receive apprenticeship, coaching, and exposure that will accelerate your growth in ways you wont 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. Youll 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 firms diversity fuels creativity and helps us come up with the best solutions for our clients. Plus, youll 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

As a Principal Data & Analytics Architect within our RGMx (Revenue Growth Management) team, you will design, build, and scale robust, SQL-centric analytical data pipelines and platforms to support critical commercial decision-making across the consumer packaged goods (CPG) sector.

You will: Architect end-to-end data and analytics workflows using Databricks, SQL, and Python to enable scalable, performant solutions. Lead the development and maintenance of production-grade analytical pipelines, combining both batch and real-time processing where appropriate. Design standardized, reusable ETL/ELT frameworks and contribute to our data product strategy to serve client-specific and reusable solution components. Translate complex commercial use cases (e.g., pricing elasticity, promotion effectiveness, assortment optimization) into scalable analytics solutions and reusable data products. Collaborate with data scientists, analytics translators, software engineers, and product managers to deliver decision intelligence capabilities embedded within RGMx products. Shape and enforce data quality, lineage, documentation, and governance standards as part of our enterprise data architecture. Take end-to-end ownership of data products, including interface definition, documentation, discoverability, and quality SLAs. Stay abreast of the evolving AI/ML and agentic software tooling landscape, identifying opportunities to embed intelligence and automation into pipelines and workflows.

You will be based in our Bengaluru or Gurugram office as part of our Growth, Marketing & Sales solutions team.

You will be aligned primarily with Periscopes technology team. Periscope By McKinsey enables better commercial decisions by uncovering actionable insights. The Periscope platform combines world leading intellectual property, prescriptive analytics, and cloud based tools to provide more than 25 solutions focused on insights and marketing, with expert support and training. It is a unique combination that drives revenue growth both now and in the future. Customer experience, performance, pricing, category, and sales optimization are powered by the Periscope platform.

Periscope has a presence in 26 locations across 16 countries with a team of 1000+ business and IT professionals and a network of 300+ experts.

To learn more about how Periscopes solutions and experts are helping businesses continually drive better performance, visit https://www.mckinsey.com/capabilities/growth-marketing-and-sales/solutions/periscope/overview

Your Qualifications and Skills

• 11+ years of experience in data engineering, data architecture, or analytics solution design, ideally in fast-paced or client-driven environments
• Expert-level proficiency in SQL (including advanced query tuning, partitioning, and orchestration)
• Strong hands-on experience with Python, including libraries like Pandas, NumPy, PySpark, and familiarity with data-centric AI development
• Significant experience with Databricks, particularly in pipeline development, Delta Lake, notebook orchestration, and collaborative analytics
• Solid foundation in data modeling, data warehousing, and integration patterns (e.g., CDC, streaming, API-based ingestion)
• Proven experience with version control (e.g., Git) and CI/CD practices for data workflows
• Deep experience with Databricks, including Delta Lake, Unity Catalog, job orchestration, cluster configuration, and collaborative development workflows.
• Familiarity with data product principles, including discoverability, ownership, and quality SLAs
• Experience with data visualization tools (e.g., Power BI) and embedded analytics capabilities
• Understanding of agentic workflows, AI-assisted development, and emerging MLOps patterns
• Awareness of ML operationalization and feature engineering pipelines is a plus
• Excellent communication and stakeholder engagement skillsable to bridge the gap between business needs and technical execution