Data Engineer - Periscope

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 data delivery team and will have the opportunity to develop a deep understanding of the domain/function.

You will design and drive the work plan for the optimization/automation and standardization of the processes incorporating best practices to achieve efficiency gains.

You will run data engineering pipelines, link raw client data with data model, conduct data assessment, perform data quality checks, and transform data using ETL tools.

You will perform data transformations, modeling, and validation activities, as well as configure applications to the client context. You will also develop scripts to validate, transform, and load raw data using programming languages such as Python/PySpark/SparkSQL. You’ll also be required to analyze and visualize data using Power BI to provide insights to support business decisions.

In this role, you will determine database structural requirements by analyzing client operations, applications, and programming.

Given the pace of this role, you will develop cross-site relationships to enhance idea generation, and manage stakeholders. Lastly, you will collaborate with the team to support ongoing business processes by delivering high-quality end products on-time and perform quality checks wherever required.

You’ll work with our Periscope team in our Gurgaon and Bangalore, India office. Periscope is the technology backbone of McKinsey’s Growth, Marketing & Sales Practice. Founded in 2007, it combines world-leading Intellectual Property, prescriptive analytics, and cloud-based tools, with expert support and training. This unique combination drives revenue growth – now, and in the future. The platform offers a suite of Growth, Marketing & Sales solutions that accelerate and sustain commercial transformation for businesses.

The Growth, Marketing & Sales Practice strives to help clients in both consumer and business-to-business environments on a wide variety of marketing and sales topics. Our clients benefit from our experience in core areas of sales and marketing topics such as sales and channel management, branding, customer insights, marketing ROI, digital marketing, CLM, and pricing. Our Practice offers an exceptional opportunity to work at the intersection of sales, marketing, and consulting. Focusing on issues like redefining sales and marketing operations and commercial transformation, our people help clients build capabilities and transform how companies go to market-moving them to customer-centric organizations.

Periscope leverages its world-leading IP (largely from McKinsey but also other partners) and best-in-class technology to enable transparency into Big Data, create actionable insights, and new ways of working that drive lasting performance improvement, and typically sustain a 2-7% increase in return on sales (ROS). With a truly global reach, the portfolio of solutions is comprised of: Marketing Solutions, Customer Experience Solutions, Category Solutions, B2C Pricing Solutions, B2B Pricing Solutions, and Sales Solutions. These are complemented by ongoing client service and custom capability building programs.

Periscope has a presence in 27 locations across 16 countries with a team of 800+ IT and business 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 www.mckinsey.com/periscope

Your Qualifications and Skills

• Bachelor’s degree/master's degree with high rankings, with 3+ years of professional work experience
• Ability to design and drive the work plan for the optimization/automation and standardization of the processes incorporating best practices to achieve efficiency gains.
• Expertise to run data engineering pipelines, link raw client data with data model, conduct data assessment, perform data quality checks, and transform data using ETL tools.
• Perform data transformations, modeling, and validation activities, as well as configure applications to the client context. Develop scripts to validate, transform, and load raw data using programming languages such as Python/PySpark/SparkSQL. Analyze and visualize data using Power BI to provide insights to support business decisions.
• Determine database structural requirements by analyzing client operations, applications, and programming..
• Collaborate with the team to support ongoing business processes by delivering high-quality end products on-time and perform quality checks wherever required.