Skip Navigation

Senior Data Analyst

Location: Taguig, Philippines

Company: Mercer

Job ID R_075018-en

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.

Job Duties:

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
Apply Later
  • Stay Connected

    Join our Talent Community and receive information on future opportunities.

    Sign Up

  • Saved Jobs

    You have not saved any jobs.

    See All Saved Jobs

  • Mercer Campus Careers

    Mercer offers many exciting and fruitful internship and entry-level positions.

    Learn more here

  • Leadership Recognition

    Dan Glaser, President and CEO, has been named to Institutional Investor magazine’s 2017 All-America Executive Team ranked as the #3 Overall CEO in the insurance industry, #3 with buy-side analysts and #2 with sell-side analysts.

  • Careers at Marsh & McLennan Companies