Back to jobs

Oliver Wyman - Lead Business Analyst (SQL & Excel) - Hyderabad or Gurugram

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

The Lead Business Analyst will own and manage end-to-end analytical delivery across multiple workstream in a project, working closely with global clients and internal stakeholders.

  • Lead multiple analytical workstreams and plan delivery timelines

  • Guide Analysts and Senior Analysts through task planning and reviews

  • Review SQL pipelines and Excel models for accuracy and best practices

  • Interpret full financial statements to find cost, margin and cash insights

  • Serve as main point of contact for senior and global clients

From the employer’s posting
The Lead Business Analyst will own and manage end-to-end analytical delivery across multiple workstream in a project, working closely with global clients and internal stakeholders. This role requires deep business understanding, exceptional analytical thinking, and expert proficiency in SQL and Excel. The Lead Analyst will interpret financial statements, solve complex commercial and operational problems, and guide a team of Analysts and Senior Analysts through structured execution. They will also ensure high-quality delivery, strong governance, and clear communication to senior stakeholders. This is a highly client-facing and leadership-oriented role suited for someone with an entrepreneurial mindset and the ability to work independently
Lead and oversee multiple analytical workstreams in a project, ensuring clear planning, timely execution, and high-quality outputs
Guide Analysts and Senior Analysts through requirement breakdown, task planning, execution reviews, and capability development
Review SQL pipelines, Excel models, and analytical frameworks to ensure accuracy, consistency, and adherence to best practices
Interpret full financial statements to uncover insights across revenue, cost, margin, and cash flow performance
Serve as the primary point of contact for global or senior-level clients or internal stakeholders
Apply at Marsh McLennan

Posting record

Report an error

Open 7 monthsWe first saw this posting 220 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Apr 16, 2026220 days ago
Recorded sightings
106
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 220

Up longer than most. Similar jobs usually come down between day 5 and day 43.

Well past Marsh McLennan’s usual: its jobs come down by about day 33.

From 16,008 similar postings that came down, and 231 of Marsh McLennan’s. Coming down is not always a hire.

Marsh McLennan is hiring

60 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Analyst hiring is picking up
  • Takes jobs down at a usual pace
  • 7% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Excel
Where the posting names them
Role Summary: The Lead Business Analyst will own and manage end-to-end analytical delivery across multiple workstream in a project, working closely with global clients and internal stakeholders. This role requires deep business understanding, exceptional analytical thinking, and expert proficiency in SQL and Excel. The Lead Analyst will interpret financial statements, solve complex commercial and operational problems, and guide a team of Analysts and Senior Analysts through structured execution. They will also ensure high-quality delivery, strong governance, and clear communication to senior stakeholders. This is a highly client-facing and leadership-oriented role suited for someone with an entrepreneurial mindset and the ability to work independently Key Responsibilities
- Allocate and prioritize tasks effectively to ensure seamless delivery across competing timelines - Review SQL pipelines, Excel models, and analytical frameworks to ensure accuracy, consistency, and adherence to best practices - Maintain structured governance, documentation, and information flow across all deliverables
Technical & Process Excellence - Ensure all SQL queries, Excel models, and data transformations follow best practices for scalability, performance, and accuracy - Identify analytical risks, dependencies, data gaps, and potential bottlenecks—designing appropriate mitigation strategies.
- Excellent communication and stakeholder management skills, with the ability to engage directly with senior and global clients - 6+ years of hands-on SQL and Excel experience (non-negotiable), including advanced query optimization, data modelling logic, and complex calculations - Strong domain experience in commercial analytics, pricing, supply chain, or operations analytics—preferably within the manufacturing sector.

Your next step

Complete your application on mmc.wd1.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Phenom

  • Phenom runs the employer’s careers site, but the application itself usually runs on another system, often Workday or Taleo. The advice for that system applies once you click Apply.

Already applied? Track this application

Job description

View original posting ↗

Oliver Wyman's Data and Analytics team is looking to hire a Lead 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 Lead Business Analyst will own and manage end-to-end analytical delivery across multiple workstream in a project, working closely with global clients and internal stakeholders. This role requires deep business understanding, exceptional analytical thinking, and expert proficiency in SQL and Excel. The Lead Analyst will interpret financial statements, solve complex commercial and operational problems, and guide a team of Analysts and Senior Analysts through structured execution. They will also ensure high-quality delivery, strong governance, and clear communication to senior stakeholders. This is a highly client-facing and leadership-oriented role suited for someone with an entrepreneurial mindset and the ability to work independently 

 

Key Responsibilities  

 

Team & Delivery Leadership 

  • Lead and oversee multiple analytical workstreams in a project, ensuring clear planning, timely execution, and high-quality outputs 

  • Guide Analysts and Senior Analysts through requirement breakdown, task planning, execution reviews, and capability development 

  • Allocate and prioritize tasks effectively to ensure seamless delivery across competing timelines 

  • Review SQL pipelines, Excel models, and analytical frameworks to ensure accuracy, consistency, and adherence to best practices 

  • Maintain structured governance, documentation, and information flow across all deliverables 

Business & Financial Problem Solving 

  • Interpret full financial statements to uncover insights across revenue, cost, margin, and cash flow performance 

  • Identify cost leakages, working capital inefficiencies, or commercial optimization opportunities using data-driven analysis 

  • Estimate effort for workstreams, define analytical approaches, and link outputs to measurable business value 

  • Build analytical frameworks, templates, and reusable assets to drive long-term efficiency and consistency 

  • Translate ambiguous business questions into clear, structured analytical pathways and problem statements 

Client & Stakeholder Management 

  • Serve as the primary point of contact for global or senior-level clients or internal stakeholders, ensuring clarity of expectations and solution alignment 

  • Facilitate discussions with diverse stakeholders to gather requirements, refine problem statements, and align on business outcomes 

  • Communicate insights in a clear, actionable, and business-oriented manner that supports leadership-level decision-making 

  • Build strong relationships through transparent communication, consistent updates, and proactive problem resolution 

Technical & Process Excellence 

  • Ensure all SQL queries, Excel models, and data transformations follow best practices for scalability, performance, and accuracy 

  • Identify analytical risks, dependencies, data gaps, and potential bottlenecks—designing appropriate mitigation strategies. 

  • Drive continuous improvements in analytical processes, reporting standards, and efficiency across all projects 

  • Support the creation of knowledge assets, documentation, and standardized KPI frameworks for use across teams 

 

Experience & Skills Requirements: 

  • Strong leadership capabilities with the ability to guide a team through structured problem-solving and high-quality project execution 

  • Deep business understanding and the ability to translate data into meaningful insights tied to financial, commercial, and operational performance. 

  • Advanced ability to read, interpret, and analyze full financial statements (P&L, Balance Sheet, Cash Flow), including revenue drivers, cost structure, margins, working capital, and cash cycles 

  • Excellent communication and stakeholder management skills, with the ability to engage directly with senior and global clients 

  • 6+ years of hands-on SQL and Excel experience (non-negotiable), including advanced query optimization, data modelling logic, and complex calculations 

  • Strong domain experience in commercial analytics, pricing, supply chain, or operations analytics—preferably within the manufacturing sector. 

  • Ability to lead teams, allocate tasks, manage workloads, and ensure timely and flawless delivery 

  • Entrepreneurial mindset with a proactive approach to identifying improvement opportunities, risks, and new solution pathways 

  • High ownership, discipline, and the ability to work independently while driving continuous improvement across analytical processes 


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, visit oliverwyman.com, or follow us on LinkedIn and X. 

Marsh is committed to providing an inclusive work environment. We aim to attract and retain the best, most qualified people and value colleagues of all backgrounds, without regard to 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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Gurugram, India

Marsh is committed to providing an inclusive work environment. We aim to attract and retain the best, most qualified people and value colleagues of all backgrounds, without regard to 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.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.