Senior Data Analyst/Underwriter - Employee Health and Benefits

Description :

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.

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 creates and refines analytical tools that benefit our clients and takes responsibility and ownership for the accurate and timely production of team reports.

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

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

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

Recognized for workplace culture by the likes of Magazine, 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, K 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, per year in matching charitable donations

Up to $ per year in wellness rewards

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

Who Are is Who 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.