Marsh & McLennan IJP- Lead Analyst - Health - Marketplace 365 Consulting in Haryāna, India

For the position of: Lead Analyst (C1)

No. of Positions: 01

Department: Marketplace 365 Consulting

Location: Gurgaon-ASF

Mercer is pleased to announce an opening for the position of Lead Analyst. Applications are invited from eligible internal applicants

Please view the information below for the open position

Duties & Responsibilities:

The candidate in this role will be responsible for Data Analysis - Assist the consulting team in gathering, organizing, entering and analyzing data using Excel spreadsheets to be used for various client projects Marketing efforts – gather benchmarking, utilization or rate data from the vendors via a Request for Proposal (RFP); interpret the meaning of the data and summarize the responses from the RFP in Excel or PowerPoint format for presentation to the client Cost projections and vendor renewal workups – gather data from the client and vendors to populate Excel spreadsheets used for developing cost projections and evaluation of vendor renewal workups; results are used as part of client meetings Plan design & Analysis – Gather data from the client and current vendors needed for analyzing the impact of a client’s in-force or new plan designs; typically involves organizing and summarizing plan design details and costs in Excel for further analysis by the team; responsibilities also include checking data for reasonableness and follow-up with vendors regarding missing or inaccurate data Ability to creatively find workarounds and good problem solving capability Client Communications and reviews Process reporting and Training Ensuring compliance of all internal and client policies Updation of process documents Driving Process improvements SLA monitoring and discussion Learn and understand business specific domain.

Note: Applicants should be flexible working in shifts

Skills Required: Knowledge & Skills:

Proficient in MS Excel, MS Access and working knowledge on other MS Office Products Proficiently Logical, Data Analytical & possesses Data Mining skills VBA Macro skills (preferred) Can work independently, possess problem solving skills and detail oriented Thorough understanding of peer review process / QC Knowledge of Health & Benefit domain (preferred) Qualifications Education: Graduate from a reputable institute in any stream Eligibility: Minimum 2 years work experience Minimum 12 months experience as a Senior Analyst/ Process Developer/ Sr. Associate Analyst/ Lead Analyst Should have at least “Meets Expectations” or equivalent rating in last appraisal Should not be under any Performance Improvement Plan, or had any official Disciplinary action within the last 3 months Should not have applied for any other IJP within Mercer within the last 3 months Disclaimer: Please note that the relocation assistance shall not be provided for the said position Candidates who wish to apply for inter-location positions are required to check with the Transport Help Desk (THD) to confirm if their place of residence is within the served transport service zone Mention your employee id and official email address in the resume