Senior Data Analyst/Underwriter - Employee Health & Benefits

Overview

The Senior Data Analyst/Underwriter will ensure the execution of our analytics platform and measure the impact of our efforts. They review detailed information, analyze data in terms of specific business goals, and display findings in simple, meaningful, and actionable formats consistent with our brand. The Senior Data Analyst/Underwriter creates and refines analytical tools that benefit our clients and takes responsibility and ownership for the accurate and timely production of team reports.

Responsibilities

THOUGHT LEADERSHIP

• Operates as the agency technical expert in financial Analytics, providing analytical resources to production staff and clients

• Meets or exceeds established performance metrics as designated by Supervisor

• Mentors Data Coordinator(s) and Data Analysts

• Assists with preparation of educational presentations for the production staff to continue their education and keep up to date on analytical tools available

ANALYTICS

• Performs underwriting responsibilities including but not limited to: renewal projections, premium equivalent/budget calculations, and analysis of renewals and quotes to assist with accuracy and negotiations

• Evaluates and recommends alternative pricing and plan design options

• Helps to improve financial modeling within the analytics department

• Obtains claim and utilization data from carrier and/or third-party administrator to complete monthly and quarterly claim reports, projections, and reserve analysis

• Maintains a reporting schedule and tracking system to ensure that all client reports are being completed in a timely manner

• Aids in the implementation and maintenance of our claim analytic platform to new and existing clients

• Demonstrates an understanding of utilization patterns, large claim impact analysis, trending, and other analytic tools

• Participates in client meetings to present reporting and utilization data, when needed

• Works closely with other members of the analytics team to train, develop and innovate within the department

• Takes initiative to research and learn new projects

EXECUTION OF CLIENT SERVICE

• Supports Account Managers, Producers, Account Executives, and other internal department members to flawlessly execute MMA Midwest's service strategy for each client, designed to create measurable value and efficiencies in their businesses

• Builds personalized client relationships through demonstrated understanding of the service plan and multiple channels of communication such as phone email and in-person meetings

• Works with internal departments to ensure cohesiveness and that the client's needs are handled quickly and effectively leverages insurance knowledge and communication skills to explain claim reports, utilization and other issues to clients as needed

• Effectively manages time to ensure workload is prioritized, client needs are addressed, and MMA Midwest's expectations on client service and business process are met

DATA AND PROCESS INTEGRITY

• Consistently follows client service workflows and appropriately engages internal resources such as process support team, procedure manuals and reporting tools to ensure efficiency and accuracy of execution

• Achieves desired levels of data completeness and process integrity by consistently meeting activity timelines, quality metrics, and goals

PEER RELATIONSHIPS

• Participates in ongoing scheduled meetings with Analytics team to discuss accounts, renewals, service needs, service platform, provide feedback, etc.

• Communicates effectively with team members and provides timely and complete information to allow them to establish positive client relationships and efficiently manage their processes and workload

• Develops successful and effective working relationships with Producers, Account Executives, Client Service Representatives, service team members, managers, carriers, and members of other departments

Qualifications

REQUIRED

• Upon hire, Producers License for Life/Health, as appropriate for role

• 5+ years of analyst and/or underwriting experience in an Employee Benefits role

• Advanced skill level in Microsoft Excel

PREFERRED

• BS/ BA in insurance, business administration, accounting, finance, economics, or mathematics

• Proficient in Microsoft Office Suite

About Marsh McLennan Agency Midwest Marsh McLennan Agency's Midwest Region is a full-service brokerage providing business insurance, employee benefits, private client insurance, and retirement services to businesses and individuals across the country. MMA Midwest is consistently recognized as a top workplace, attracting and retaining its insurance talent by rewarding expertise and investing in career development. Colleagues enjoy an award-winning culture that fosters a highly productive and results-driven working environment.

A Great Place to Work. A Great Place to Perk.

Recognized for workplace culture by the likes of Fortune Magazine, The Chicago Tribune and more, our colleagues enjoy an environment that fosters creativity as well as individual and organizational growth. A small sampling of the benefits our colleagues enjoy include:

• Medical, dental, vision, 401K benefits and more

• The flexibility to work at home or an office

• A paid day off to volunteer and company-organized volunteer events

• Up to $1,000 per year in matching charitable donations

• Up to $750 per year in wellness rewards

• A company-wide mentality that you can never appreciate your co-workers too much

Who You Are is Who We Are

MMA Midwest has created an award-winning culture largely due to meeting our colleagues where they are, celebrating their differences and building an inclusive environment. We challenge ourselves to create a workplace where our colleagues feel not only welcomed, but feel they belong; where we not only embrace diverse perspectives and opinions but seek them out; and where we ask not how a colleague fits our culture, but what they add to it.