Job Details

Senior Data Analyst - Marketing & Sales Ventures

Munster, IN

Job ID:

4221171002

Job Description

McKinsey & Company (McKinsey) is a global management consulting firm that advises the world's leading businesses, governments and institutions. McKinsey has more than 100 offices in over 50 countries and serves eight out of the ten of Fortune magazine's Most Admired Companies.

You’ll join Periscope in our Muenster office. Periscope is part of the Marketing & Sales (M&S) Ventures team in the Marketing & Sales Practice. M&S Ventures was set up to house all of the Marketing and Sales Practice’s repeatable analytics, repeatable digital, and solutions. This is part of the Firm-wide effort called New Ventures to build more asset-led consulting capabilities.

Founded in 2007, the Periscope™ By McKinsey platform combines world-leading Intellectual Property, prescriptive analytics and cloud based tools with expert support and training. It’s a unique combination that drives revenue growth, both now and into the future. The platform offers a suite of Marketing & Sales solutions that accelerate and sustain commercial transformation for businesses. With a truly global reach, the portfolio of solutions comprises of: Insight Solutions, Marketing Solutions, Customer Experience Solutions, Category Solutions, Pricing Solutions, Performance Solutions and Sales Solutions.

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 with expert support and training. It is a unique combination that drives revenue growth both now and in the future. More than 25 solutions focused on insights, marketing, 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 650+ 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 http://www.periscope-solutions.com/ 

You will develop complex algorithms in SQL based on discussions with client and the service delivery team. You will also develop scripts to validate, transform and load raw data using programming languages such as Python, Perl or Shell. As part of the role, conducting data assessment, performing data quality checks and transforming data using SQL and ETL tools will be one of your top priorities.

You will also support ongoing business processes by delivering high quality products and develop a deep understanding of the domain/function (pricing, promotions and assortment). You will train and mentor junior analysts and build their proficiency across various tools and processes

McKinsey is tech and programming-language agnostic, so you’ll have the flexibility and autonomy to shape existing codebase applying the newest platforms and available engineering practices. Our team of software engineers and tech specialists are dedicated to helping you learn, grow, and be at your best.

For more information on McKinsey software engineering career paths, visit: http://mckinsey.com/TechCareers.

  • Bachelor’s or Master’s degree in Computer Science or any quantitative area
  • 3+ years of experience of building and optimizing data pipelines, architectures and data sets
  • Understanding of data warehousing & data lake concepts with coding abilities in the field of data manipulation and ETL
  • Expertise in integrating data from multiple data sources and automation of data processes
  • Very high proficiency in Python and SQL
  • Excellent time management skills
  • Sound problem-solving skills and action-oriented mindset
  • Good attitude for getting the task executed and creative implementation of technology
  • Fluent in English

Similar Jobs