Oliver Wyman – Business Analyst (SQL & Excel)

Overview

Support the Oliver Wyman Data and Analytics team (OW DNA) as a Business Analyst, building SQL queries, Excel models and data-driven insights for consulting engagement teams, working closely with Senior Analysts and Lead Analysts on commercial and operational analytics projects.

What you'll do

• Write and execute SQL queries for data extraction, cleansing, and preparing datasets for analysis
• Build structured Excel models and reports that are easy to reuse and update for stakeholders
• Support analysis by reading financial statements and understanding revenue, cost, and margin drivers
• Assist Senior Analysts in creating executive-ready presentations, dashboards, and summaries
• Validate datasets to ensure consistency across KPIs and maintain high data integrity
• Participate in requirement discussions and convert them into clear analytical tasks
• Document analytical logic, transformation rules, and data definitions for reuse
• Conduct ad-hoc analysis to support operational or commercial decision-making
• Identify potential data issues early and highlight risks to senior team members

What you'll need

• Strong problem-solving skills and the ability to break down complex problems into simple analytical steps
• Curiosity to learn new tools and concepts, with self-motivation to continuously grow
• Good business understanding and the ability to link data patterns to real business situations
• Ability to read and interpret basic financial statements (P&L, Balance Sheet, Cash Flow) to support analysis
• 1+ years of hands-on SQL and Excel experience (non-negotiable), with comfort writing queries and building structured models
• A detail-oriented mindset ensuring accuracy in data cleaning, validation, and reporting
• Strong interpersonal skills and the ability to collaborate effectively within teams
• Bachelor's degree in Business, Engineering, Finance, Economics, or related fields

Nice to have

• Exposure to commercial or operations analytics in manufacturing

Details

• Location: Hyderabad office
• Hybrid work: all colleagues expected to be in their local office or working onsite with clients at least three days per week, with a weekly anchor day for office-based teams