27 Aug
|
Marsh Mclennan
|
Noida
27 Aug
Marsh Mclennan
Noida
Company:
Description:
Roles and Responsibilities:
Track and coordinate all employee benefits insurance policy renewals globally
Preparation of client deliverables, including regular reporting and presentations
Perform quality checks and peer review of data, including reasons for employee headcount movement, premium changes by line of coverage, brokerage savings etc.
Data entry- and high-level analysis - assist the Account Management team in gathering, organizing, validating, entering and analyzing data using Advantages Management
Ensure timely completion of Benefits Management by local brokers to ensure the Rules of the Road are followed
Route enquiries to the correct point of contact and provide timely follow up and responses
Technical Skills - Skills & Responsibilities
Analytical Skills
Perform structured analyses on global benefits data, identify trends in renewal metrics, and prepare summaries for client reporting.
Build dashboards using Power BI/Excel; generate stewardship and savings insights; create executive summaries tailored to client needs.
Data Validation
Apply rigorous validation checks on client-provided renewal data across regions; flag discrepancies and prepare exception reports to ensure data integrity.
Conduct reconciliation and error-checking on datasets; prepare exception lists to highlight data issues before analysis.
MS Excel
Develop and maintain complex workbooks using formulas, pivot tables, Power Query, and macros to automate data consolidation and validation workflows.
Automate renewal data consolidation and benefit harmonization; streamline reporting and validation processes across multiple regions.
Numerical Skills
Execute precise calculations, rate and ratio computations, and sanity checks to ensure accuracy of renewal and benefits data.
Support accuracy in stewardship and savings reports through detailed numerical validation and reconciliation checks.
Data Analysis
Explore and analyze large datasets to generate actionable insights; suppor
📌 Senior Specialist (Noida)
🏢 Marsh Mclennan
📍 Noida