Oliver Wyman - Senior Business Analyst SQL And Excel - Hyderabad

Oliver Wyman; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Oliver Wyman’s Hyderabad office is seeking a Senior Business Analyst to independently manage analytical workstreams and translate requirements into structured analyses and actionable insights.

The role requires strong business acumen, advanced SQL and Excel capabilities, and the ability to interpret financial statements to drive improvements in manufacturing environments. You will lead medium to large analytics modules and guide junior analysts in delivering high-quality results.

Qualifications

• Independent analytical workstream management with stakeholder collaboration.
• Translate requirements into structured analyses and insights.
• Strong business acumen with ability to link findings to commercial impact.
• 4+ years of SQL and Excel experience with advanced queries and modeling.
• Manufacturing analytics experience preferred.

Responsibilities

• Lead analytical workstreams using advanced SQL and Excel methods.
• Analyze and interpret financial statements to uncover opportunities or performance gaps.
• Break down ambiguous business questions into structured analytical tasks and deliverables.
• Estimate effort based on inputs, expected value, and data complexity.
• Prepare executive-ready summaries that articulate insights clearly and persuasively.
• Ensure data governance, consistency, and adherence to analytical best practices.
• Facilitate requirement-gathering sessions with clients and translate needs into analytical plans.
• Build sophisticated operational, commercial, or financial models to support strategic decisions.
• Mentor Analysts in query-writing, modelling, and business understanding.
• Identify risks early, propose mitigation steps, and maintain clear communication on progress.

Skills

Analytical thinking

Business acumen

Financial statements

Communication

Mentoring

KPI modeling

Stakeholder interaction

Manufacturing analytics

Fast-paced environment

Travel readiness

Tools

SQL

Excel

Job description

Job Description

Oliver Wyman's Data and Analytics team is looking to hire a Senior Business Analyst for our Hyderabad office.

OW DNA Overview

The Oliver Wyman DNA is a distinguished centre 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 Senior Business Analyst will independently manage analytical workstreams, working closely with business stakeholders to translate requirements into structured analyses and actionable insights. This role requires strong business acumen, advanced SQL and Excel capabilities, and the ability to interpret financial statements. The Senior Analyst will lead medium to large analytical modules, guide junior analysts, and ensure clarity and quality across deliverables. They will play a key role in connecting data to commercial and operational performance, especially within manufacturing environments.

Experience & Skills Requirements

• Strong analytical thinking with the ability to independently structure and solve business problems
• Strong business acumen and the ability to connect analytical findings to commercial or operational impact
• Ability to interpret financial statements and analyze trends in revenue, costs, margins, assets, and cash flows
• Excellent communication skills to work directly with stakeholders and clarify requirements
• 4+ years of proven experience with SQL and Excel (non-negotiable), including advanced queries and modeling
• Experience in KPI modeling, pricing analysis, operational efficiency, or supply chain analytics
• Ability to guide junior analysts by reviewing their queries, models, and thought process
• Understanding of data structures, relational tables, joins, and query optimization techniques
• Prior experience in manufacturing analytics is strongly preferred
• Ability to work in a fast-paced environment with multiple tasks
• Strong written and verbal communication skills with demonstrated ability to interact effectively with all levels of stakeholders (both internal and external)
• Willingness to travel as required to meet client needs

Key Requirements

• Lead analytical workstreams using advanced SQL and Excel methods
• Analyze and interpret financial statements to uncover improvement opportunities or performance gaps
• Break down ambiguous business questions into structured analytical tasks and clear deliverables.
• Estimate effort based on inputs, expected value, and data complexity
• Prepare executive-ready summaries that articulate insights clearly and persuasively
• Ensure data governance, consistency, and adherence to analytical best practices
• Facilitate requirement-gathering sessions with clients and translate needs into analytical plans
• Build sophisticated operational, commercial, or financial models to support strategic decisions
• Mentor Analysts in query-writing, modelling, and business understanding
• Identify risks early, propose mitigation steps, and maintain clear communication on progress

Oliver Wyman is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visitoliverwyman.com, or follow us onLinkedInandX.

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