Plan Analyst

Marsh & McLennan Agency, (MMA) located in Troy, MI serves the group benefit needs of organizations headquartered in Michigan that employ between 100 and 10,000 workers. We provide innovative and individually tailored cost reduction strategies and tactics in all of the functional elements of group benefit plans.


The Plan Analyst (PA) is responsible for obtaining and analyzing group benefit program proposals for both clients and prospects. The Plan Analyst analyzes bids for group health and welfare coverage for clients, provides benchmarking research and analysis, and develops detailed client reports. The PA provides substantial financial analysis for 8-12 clients on average.

The PA works on moderate to high complexity cases, demonstrating a high level of accuracy within their work product. This position spends approximately 90% of their time in Excel.


  • Providessupport in obtaining the most competitive proposals in the marketplace, financial reporting and carrier / vendor evaluation.
  • Constructs detailed client / prospect reports, with specific direction and guidance from the Account Director.
  • Demonstrates the ability to construct files / work product so others can follow logic to determine how the numbers were developed and ascertain which assumptions were used.
  • Develops and maintains a solid understanding of Excel, Word, PowerPoint, Access and other tools and methods provided by the company to effectively complete work product.
  • Answers client's questions both orally and in writing. Communicates effectively both internally and externally on matters related to client work product, work in progress, market information and other projects as assigned.
  • Builds relationships with carriers to help expedite information processing. Illustrating knowledge of carrier plans, with a primary focus on area-rated, fully-insured and self-funded medical and ancillary benefits.
  • Understands various benchmarking sources and uses this knowledge to determine the most beneficial source for a particular client.
  • Maintains complete and accurate client files utilizing company filing standards.
  • Researches industry topics to develop an understanding of technical industry trends and changes to the health care / employee benefits delivery system. Begins to share templates and ideas within the PA department.
  • Works jointly with the Account Director(s) in the development of flow pages (summary of key points in the client study), executive summaries, letters and e-mails.
  • Gathers the most accurate data available and summarizes it in a usable, error-free format for the final presentation. The PA is expected to develop a final work product that is clear, concise and accurate in a format that is easily read and understand.
  • A PA should have or work toward developing a high level of knowledge of various group products and have a strong technical ability to illustrate the advantages / disadvantages of a specific group product to a client.
  • Participates in the Plan Analyst team meetings to share information and gather information from other Plan Analysts.

  • Qualifications
    • Bachelor's degree in finance, mathematics or other related area preferred.
    • Minimum of 3-5 years' experience in the healthcare benefits industry working for a group, insurance carrier, broker or general agency preferred.
    • Knowledge of group insurance (medical, dental, vision & life and disability products) preferred.
    • Must possess strong analytical and problem solving skills.
    • Excellent communication and writing skills.
    • Must be able to follow directions, be detailed, organized and resourceful.
    • Ability to work under extreme pressure (tight deadlines & juggling many projects)
    • Proficient in MS Word, Excel andPowerPoint.

    Marsh & McLennan Agency (MMA) firmly believes it is the character and commitment of our people that make a difference, and we are always seeking those with ethics, talent, and ambition interested in joining our client-focused teams. If you are a committed professional with a passion for delivering excellent service, we are interested in hearing from you.

    Marsh & McLennan Agency (MMA) offers competitive salaries and comprehensive benefits including: medical/Rx, dental, vision, flexible spending accounts, health savings accounts, life & ad&d, short-term and long-term disability benefits,401k, employee stock purchase program and an employee assistance program.

    Meet Some of Marsh & McLennan Companies's Employees

    Tiffany H.

    Rotation Consultant

    As part of the rotation program, Tiffany is learning strategic planning—how to grow a business not just organically but also through acquisition and possible divestitures.

    James S.

    Partnership Certificate Supervisor

    As supervisor of the North Central Team, James manages 24 direct reports in an operations environment and encourages high-quality production and professional development.

    Back to top