Mercer is a global and prominent consulting leader in talent, health, retirement, and merger/acquisition services and solutions. Its business creates more secure and rewarding futures for their clients and employees through designing affordable health plans, assuring income for retirement or aligning workers for work needs. Mercer is one of the four portfolios of Marsh & McLennan Companies.
Currently, we are looking for a Sr. Data Analyst, the primary responsibility is to generate medical utilization reports for MMB broking and consulting clients with main objective of identifying cost drivers so that these can be addressed by health and wellness programs, cost containment measures and disease management programs to ultimately lower down insurance cost.
Generation of medical utilization and demographic reports
Coordinate with insurance providers in the provision of accurate and on-time data
Clean-up and validate data and address and resolve issues
Generate reports and come up with analysis highlighting trends and cost drivers in terms of top availers, top claim types, top illnesses and top hospitals, at the least
Coordinate with Client Relationship managers in the proper interpretation of findings and how best to convey results to clients
Improve and automate report generation processes
Comply with data security policies as required by both internal policies and by the Data Privacy Act of the Philippines
Support consulting projects by analysing utilization reports and correlate this data with other data points such as death claims, onsite clinic, pre-employment tests, at the least
Conduct research on identified markets and industries to support business objectives
Conduct studies on insured benefits in the market to provide benchmarks
Generate reports to support business operations such as, but not limited to, sales pipeline reports, revenue reviews, renewal accounts reviews
Knowledge and Skills:
Bachelor's degree in Math, Actuarial Science or Statistics
Advanced skills in Excel. Macro programming is preferred but not required.
Excellent interpersonal skills, strong oral and written communication skills
Advanced skills in the use MS PowerPoint and other visualization tools for report presentations
Knowledge in statistical software such as R
With strong attention to details
Ability to work in an environment with rapidly changing demands
Leadership skills and ability to influence for better results
Proficient in data management
Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.
Marsh & Mclennan Companies, Inc.