Oliver Wyman

Job Description Oliver Wyman's Data and Analytics team is looking to hire a Business Analyst for our Hyderabad or Gurugram office. OW DNA Overview The Oliver Wyman DNA is a distinguished center of excellence for business analytics and data analytics within Oliver Wyman. This group leverages data and information to provide business insights to Oliver Wyman consulting teams driving positive outcomes and tangible impact for Oliver Wyman's clients. The group combines cutting edge data science expertise with core consulting expertise to augment engagement teams with analytical firepower to deliver outstanding results. Role Summary: The Business Analyst will support the analytics team by building high-quality SQL queries, Excel models, and data-driven insights. This role focuses on strong analytical thinking, problem-solving, and the ability to translate business questions into structured analysis. The candidate will work closely with Senior Analysts and Lead Analysts to support execution of commercial and operational analytics projects Experience & Skills Requirements: - 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 - Exposure to commercial or operations analytics in manufacturing is an added advantage Key Responsibilities - 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 Oliver Wyman, a business of Marsh McLennan (NYSE: MMC), is a management consulting firm combining deep industry knowledge with specialized expertise to help clients optimize their business, improve operations and accelerate performance. Marsh McLennan is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit oliverwyman.com, or follow on LinkedIn and X. Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one anchor day per week on which their full team will be together in person. R_332336