Senior Business Analyst, SQL & Excel

india, Telangana, Hyderabad

Full–time

Posted on: 4 days ago

As a Senior Business Analyst at Oliver Wyman's Data and Analytics team in Hyderabad or Gurugram office, you will be responsible for independently managing analytical workstreams. You will work closely with business stakeholders to translate requirements into structured analyses and actionable insights. Your role will require strong business acumen, advanced SQL and Excel capabilities, and the ability to interpret financial statements. You will lead medium to large analytical modules, guide junior analysts, and ensure clarity and quality across deliverables. Your key role will involve 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 Responsibilities:**
  • - 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, modeling, and business understanding
    - Identify risks early, propose mitigation steps, and maintain clear communication on progress

    Please note that Oliver Wyman, a business of Marsh McLennan (NYSE: MMC), is a management consulting firm that combines 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 aims to build the confidence to thrive through the power of perspective. Marsh McLennan is committed to embracing a diverse, inclusive, and flexible work environment, promoting diversity and inclusion. As a Senior Business Analyst at Oliver Wyman's Data and Analytics team in Hyderabad or Gurugram office, you will be responsible for independently managing analytical workstreams. You will work closely with business stakeholders to translate requirements into structured analyses and actionable insights. Your role will require strong business acumen, advanced SQL and Excel capabilities, and the ability to interpret financial statements. You will lead medium to large analytical modules, guide junior analysts, and ensure clarity and quality across deliverables. Your key role will involve 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, relat