Senior Data Engineer

You will be a core member of Periscope’s product engineering team with responsibilities that range from developing and deploying our core enterprise products to ensuring that McKinsey’s craft stays on the leading edge of technology.

In this role you will develop and maintain Python/PySpark libraries for data ingestion, incorporating Slowly Changing Dimensions (SCD) logic for efficient ETL workflows. You will create and enhance Python/PySpark libraries for data quality validation, ensuring accuracy, consistency, and completeness in large-scale datasets. You will design and optimize scalable data pipelines leveraging Spark, Databricks, and cloud data services (Azure/AWS).

You will be leading and executing data engineering projects from inception to completion, ensuring timely delivery and high quality while you continuously monitor, troubleshoot, and improve data pipelines and workflows to ensure optimal performance and cost-effectiveness.

You will collaborate with cross-functional teams to stay ahead of emerging trends in Gen AI, big data, and cloud-based automation.

You will be based in our Bangalore or Gurugram office as a member of Periscope’s technology team.

Periscope is the asset-based arm of McKinsey’s Marketing & Sales practice and is at the leading edge of the new ways we serve clients. This integrated model of serving clients, i.e. combining our generalist consulting approaches with the solutions, is a proof of the firm’s commitment to continued innovation in the spirit of bringing the best of the firm to our clients.

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 600+ business and IT professionals and a network of 300+ experts. To learn more about how Periscope’s solutions and experts are helping businesses continually drive better performance, visit here.

• 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.

• 6+ years of experience in big data engineering and cloud technologies (Azure/AWS)
• Proficiency in PySpark, Spark SQL, and Python for data processing and automation
• Strong background in building and maintaining Python/PySpark libraries for data ingestion (SCD logic) and data quality validation
• Proficiency in distributed computing, Databricks workflows, and Spark optimizations
• Experience in API development, SOA architectures and REST services
• Experience with streaming data processing (Kafka, Kinesis, Spark Streaming)
• Implement Gen AI engineering and automation using Databricks capabilities like DB Apps, Genie to enhance data workflows and decision-making. Exposure to LLM fine-tuning, vector databases, and AI-driven analytics
• Familiarity with CI/CD pipelines, containerization (Docker/Kubernetes), and DevOps best practices
• Experience with cloud data services such as Azure Data Factory, ADLS, S3 etc
• Excellent problem-solving skills with a focus on cost and performance optimization
• Actively coached, mentored and grown team members in their careers