Oliver Wyman - Business Analyst (SQL & Excel) - Hyderabad or Gurugram
at Oliver Wyman
Posted 6 days ago
No clicks
- Compensation
- Not specified
- City
- Not specified
- Country
- Not specified
Currency: Not specified
Role involves supporting the analytics team by building high-quality SQL queries and Excel models to generate data-driven insights for commercial and operational analytics. The candidate will translate business questions into structured analyses, collaborating with Senior Analysts and Lead Analysts to execute projects and prepare executive-ready presentations, dashboards, and summaries. Key tasks include data extraction, cleansing, validation, KPI consistency, and ad-hoc analyses to support decision-making, with a focus on financial statement interpretation. This role requires strong problem-solving, business understanding, and a proactive mindset to learn new tools and concepts.
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 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 $24 billion and more than 90,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 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.
