McKinsey & Company Looking for Data Analyst – Periscope, Marketing & Sales at [...]

McKinsey & Company; Gurugram District; On-site; INR 4,50,000 - 6,75,000; Full time

Job summary

Join an innovative team at a leading consulting firm where you'll leverage your expertise in data engineering. In this dynamic role, you will design and optimize processes, ensuring data integrity and quality through advanced ETL practices. Collaborate with cross-functional teams to deliver high-quality solutions that drive efficiency and support client objectives. This is an exciting opportunity to work with cutting-edge technology and contribute to impactful projects in a fast-paced environment. If you're passionate about data and eager to make a difference, this role is perfect for you.

Qualifications

• 3+ years of experience in analytics with expertise in Python and SQL.
• Strong problem-solving skills and ability to lead projects.

Responsibilities

• Design and drive work plans for process optimization and automation.
• Run data engineering pipelines and perform data quality checks.

Skills

Python

SQL

ETL tools

Data modeling

Cloud technologies (Azure, AWS)

Problem-solving

Communication

Education

Bachelor’s degree in engineering or computer science

Master’s degree

Tools

Python/PySpark/SparkSQL

ETL/data pipelines

Job description

Qualifications

• Bachelor’s degree in engineering or computer science; master’s degree is a plus
• 3+ years of professional work experience with an analytics firm
• Expertise in handling a large amount of data through Python
• Ability to conduct data assessment, perform data quality checks and transform data using SQL and ETL tools
• Experience in deploying ETL/data pipelines and workflows in cloud technologies and architecture such as Azure and Amazon web services
• Proficiency in data modeling principles (database structure, entity relationships, UID) and software development principles (modularization, testing, refactoring)
• Track record of strong problem-solving, requirement gathering and leading by example
• Ability to thrive in a flexible and collaborative environment
• Track record of completing projects successfully on time, within budget and as per scope
• Expert communicator (verbal and written) with the ability to facilitate discussions and conduct training

What You’ll Do

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.

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.

Who You’ll Work With

You’ll work with our Periscope team in our Gurgaon office in India. This is part of an exciting, highly visible fast-growing group within our Marketing & Sales Solutions and the broader firm.

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

Periscope is the technology backbone of McKinsey’s Sales & Marketing 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.

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.