Healthcare Data and Reporting Manager

Manager - Healthcare - Data & Reporting Analyst

Company:

Mercer

Description:

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

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

Manager - Metrics, Analytics & Reporting

No of Positions: 2

We are seeking a hands-on mid-level Data & Reporting Analyst in the GSD India team, who owns data intake, validation, formatting and standard reporting for Carrier Relations Team initiatives, including MarketInSight, Carrier Survey, Supplemental Compensation Transparency/Disclosure and other major projects in the Carrier Relations work stream.

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

What can you expect?

As a hands-on mid-level analyst, you would be responsible for owning data intake, validation, formatting and standard reporting for Carrier Relations Team initiatives, including MarketInSight, Carrier Survey, Supplemental Compensation Transparency/Disclosure and other major projects as they arise. You would be working with carrier relations team to resolve issues, develop and maintain Standard Operating Procedures (SOP) and deliver high-quality datasets that senior analysts use to surface insights.

We will count on you for:

• Manage intake of carrier files: receive, validate, transform and load into MarketInSight workflows.

• Support Carrier Survey: help clean, reconcile, and initial analysis on responses.

• Administer Supplemental Compensation Opt-out, disclosure, and exception processes

• Act as the initiative coordinator for projects assigned by Carrier Relations to GSD – prioritizing tasks, keep stakeholders informed with status reports, and organize meetings. 

• Provide analytic support for supplemental compensation tasks (prep, reconciliation, summary tables).

• Perform data quality assurance: automated and manual checks, field-level validation, reconciliation to prior periods.

• Format data and deliver reports to set presentation standards and templates.

• Maintain and update SOPs, document process changes and runbooks.

• Work with carrier relations and US-based colleagues to triage problems and propose fixes.

• Organize data for recurring reporting so senior staff can focus on insights, not cleaning.

• Apply basic data modeling and storage best practices under guidance to protect reporting integrity.

What you need to have: 

Required (must-have)

• Graduate with minimum 8 years of work experience

• 3–5 years analytics/data role experience (insurance/benefits preferred).

• Advanced MS Excel skills and experience handling large datasets in Excel: advanced formulas, pivot tables, Power Query, VBA/macros. Must be comfortable doing validation and reporting primarily in Excel (not dependent on other tools).

• Strong data QA, reconciliation and attention to detail.

• Clear written and spoken English; can communicate issues and SOPs to US stakeholders.

• Problem-solver mindset; can propose practical solutions and follow through.

• Self-initiator who can proactively identify any concerns and make suggestions for resolution in a timely manner.

Nice-to-have

• Basic SQL (ability to run simple queries).

• Exposure to Power BI/Tableau/Qlik or Python/pandas.

• Prior experience working with carrier data or surveys.

• Familiarity with project management applications, Smartsheet, and Vizio

What makes you stand out?

• Adaptable communicator, facilitator, influencer and problem solver

• High attention to detail

• Good relationship skills, Proven ability to work on own initiative as well as in a team 

• Ability to multi-task and prioritize time effectively

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.

Mercer 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 about Mercer, visit mercer.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.

Experience Level

Senior Level