Business Analyst – Data Focused

Caserta, now part of McKinsey & Company, is a solution provider, with the talent and vision to innovate beyond the expected. You will be joining a diverse team of leading-edge technologists where we pride ourselves on challenging the status quo, seeing the value and impact of our work and enjoy the complexity of the data transformation we deliver. With joining McKinsey & Company, we have a significant opportunity to help clients overcome the challenges in building competitive, industry-leading enterprise data environments. As part of our team, you will provide the ultimate in customized solutions, involving cutting edge technology, servicing a diverse set of clients who value your input and guidance to modernize their data ecosystem while directly enhancing the lives of others.

Business Data Analysts are a vital bridge between our client stakeholders and our data engineers. They specialize in understanding how users interact with and exploit data to drive business outcomes. They have a particular knack for understanding and explaining the intersection of tacit business knowledge and the technical context of data. They are able to elicit requirements from stakeholders, synthesize user stories and devise test cases. They understand data models, data lifecycle and semantic layers.

Your responsibilities will include:

  • Conduct interviews with stakeholders, elicit and understand user stories
  • Utilize appropriate tools to perform data profiling over structured and unstructured sources
  • Collect, map, and track business requirements and develop functional specifications
  • Assist in the design and completeness of data models
  • Define, collect, and analyze business and technical metadata
  • Design test cases

You will be an outstanding fit for this role if you consider yourself:

  • Excited by the opportunity to immerse yourself in new business verticals, organizations and business challenges
  • Able to see the bigger picture, love to connect the dots, are good at spotting patterns and inconsistencies
  • Someone who lives and breathes data and business process
  • Focused on the quality of your work and don’t believe in cutting corners
  • Naturally curious with strong aptitude for learning new technologies and analytics techniques
  • Highly self-motivated and able to work independently as well as in a team environment

Do you have:

  • Minimum of 5 years’ experience working on data projects as a Business Analyst with a track record of execution
  • Strong analytical skills
  • Experience with SQL and/or intermediate Python
  • Experience with data analysis, Kimball dimensional modeling, and data warehousing concepts
  • Excellent written and verbal communication skills, able to communicate complex ideas simply
  • Experience with data analytics in varying data environments (data lake, HDFS etc.)
  • The desire to occasionally travel
  • Bachelor’s degree in Computer Science, data engineering or a closely related field (preferred)

As part of our team you would:

  • You would work with a community of likeminded people who are passionate about their work and enjoy solving the most challenging data problems in the industry while making an impact
  • Would be part of a collaborative company culture that encourages diversity
  • As part of McKinsey & Company, Inc you will receive an exceptional compensation plan, annual bonus, extensive benefit plan including Medical, Vision, Dental, life insurance, paid time off and a generous retirement program

If your desired work location is outside of the New York City Metropolitan area, please apply and let’s further discuss your candidacy.

Employment with McKinsey & Company, Inc. in the United States and Canada is conditioned on proof of full vaccination against the COVID-19 virus (with a WHO-approved or Health Canada-approved COVID-19 vaccine, as applicable) or approval of an exemption due to a qualifying medical condition or sincerely held religious belief prior to start date.

FOR U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by applicable law.

FOR NON-U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity employer. For additional details regarding our global EEO policy and diversity initiatives, please visit our McKinsey Careers and Diversity & Inclusion sites: