Senior Manager - Data Analytics And Insight

Marsh McLennan; Gurugram District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Hybrid work model

Flexible work arrangements

Job summary

Mercer, part of Marsh McLennan, seeks a Pricing and Market Intelligence Analyst based in Noida. This hybrid role requires in-office presence at least three days per week.

The role involves managing the WinPath Pricing Model, budgeting support, and building state/competitor profiles while developing dashboards to inform strategic decisions. The ideal candidate will have 7+ years of experience in pricing analysis or healthcare analytics, strong Excel skills, and proficiency with Tableau/Power BI

Qualifications

• Bachelor’s degree in Finance, Economics, Healthcare Administration, Business, or related field.
• 7+ years of overall experience; 3+ years in pricing analysis, market intelligence, or healthcare analytics preferred.
• Strong proficiency in pricing models and financial analysis.
• Experience with FOIA data analysis and integration.
• Advanced Excel skills with pivot tables and data visualization.
• Familiarity with Tableau/Power BI and dashboarding tools.

Responsibilities

• Manage and update the WinPath Pricing Model with inputs from FOIA analysis.
• Support budgeting, Statements of Work (SOW), and staffing hour buildup.
• Develop and maintain state and competitor profiles for market positioning.
• Summarize Medicaid and financial themes from MCO investor calls.
• Integrate internal themes with NIH trends and MACPAC trend estimates.
• Maintain main and breakout data files with accuracy and peer review.
• Design, develop, and maintain the Sales Dashboard with profitability metrics and HR data.
• Collaborate with internal teams such as GSD.
• Conduct quarterly lobbyist activity research per state.
• Allocate approximately 1.5 hours per state for lobbyist tracking.

Skills

Pricing analytics

FOIA data analysis

Advanced Excel

Data visualization

Education

Bachelor’s degree in Finance, Economics, Healthcare Administration, Business, or related field

Tools

Tableau

Power BI

Job description

Job Description:

Company:

Mercer

Description:

Mercer is seeking candidates for the following position based in the Noida office

This is a hybrid role that has a requirement of working at least three days a week in the office.

What can you expect?

We are seeking a detail-oriented and analytical Pricing and Market Intelligence Analyst to support our WinPath Pricing Model and related business intelligence activities. This role involves managing pricing models, supporting budgeting and staffing plans, maintaining state and competitor profiles, summarizing Medicaid and financial themes, and enhancing sales dashboards. The ideal candidate will also track lobbyist activities across states and provide actionable insights to support strategic decision-making

We will count on you to

• Manage and update the WinPath Pricing Model, incorporating inputs from FOIA analysis.
• Support budgeting processes, Statements of Work (SOW), and staffing hour buildup.
• Develop and maintain comprehensive state and competitor profiles to inform market positioning.
• Summarize Medicaid and financial themes from Managed Care Organization (MCO) investor calls (e.g., UNH, ELV, CVS, MOH).
• Integrate internal themes with national data sources such as NIH medical trends and MACPAC trend estimates.
• Maintain main and breakout data files, ensuring accuracy and peer review.
• Design, develop, and maintain the Sales Dashboard, including profitability metrics (with subscriptions), contract end dates, forecasts, actuals, drift, and HR-related data.
• Collaborate with internal teams such as GSD as needed.
• Conduct quarterly research on lobbyist activities for each state, including:
  • Listing state lobbyist websites.
  • Identifying competitors with lobbyists.
  • Tracking lobbyist payments and duration of lobbying efforts.
• Allocate approximately 1.5 hours per state for lobbyist tracking and updates.

What you need to have:

Technical Skills:

• Strong proficiency in pricing models and financial analysis.
• Experience with FOIA data analysis and integration.
• Advanced Excel skills, including complex formulas, pivot tables, and data visualization.
• Familiarity with data management and dashboard tools (e.g., Tableau, Power BI, or similar).
• Ability to work with large datasets and maintain data accuracy.
• Knowledge of Medicaid, Managed Care Organizations, and healthcare financial themes.
• Experience with competitor and market profiling.
• Basic understanding of lobbying processes and regulatory environments is a plus.

Analytical Skills:

• Strong analytical and problem-solving abilities.
• Ability to synthesize complex financial and market data into clear, actionable insights.
• Detail-oriented with a focus on data accuracy and quality control.

Communication Skills:

• Excellent written and verbal communication skills.
• Ability to collaborate effectively with cross-functional teams.
• Comfortable presenting findings and recommendations to stakeholders.

Other Qualifications:

• Bachelor’s degree in Finance, Economics, Healthcare Administration, Business, or a related field.
• 7+ yrs of overall experience. 3+ years of experience in pricing analysis, market intelligence, or healthcare analytics preferred.
• Ability to manage multiple tasks and deadlines in a fast-paced environment.
• Self-motivated with a proactive approach to problem-solving.

What makes you stand out?

• Adaptable communicator, facilitator, influencer and problem solver
• Good relationship skills, Proven ability to work on own initiative as well as in a team
• Ability to multi-task and prioritize time effectivelyBe highly analytical
• Able to work to tight deadlines and extended hours based on client requirement
• Have a successful track record interacting with business leaders
• Financial services industry experience preferred
• Provides and oversees financial information for the regional functions including firm wide initiatives
• Ability to lead and drive change within a transforming and matrixed organization
• Streamlines and standardizes financial activities and procedures to improve efficiency

Why join our team?

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being. Flexible work arrangements
• Discounted insurances
• Incentive Compensation Plan
• Leadingtraining and development program
• Professional environment where your career path really matters and is supported in our global organization
• Great team environment with energetic and supportive colleagues

Marsh (NYSE: MRSH) is 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 marsh.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.