Data Analytics Coordinator - Employee Health & Benefits

Overview:

The Data Analytics Coordinator is a data driven numbers expert with the determination to make their team successful. With an analytical mindset and passion for working with numbers, they directly support the Financial Analytics team in preparing reporting to deliver to production teams. The Data Analytics Coordinator reviews detailed information, analyzes data in terms of specific business goals, and displays findings in simple, meaningful, actionable formats consistent with our brand. They consistently look for creative ways to refine tools that will benefit our clients.

Responsibilities:

ANALYTICS

Obtains claim and utilization data from carrier and/or third-party administrator in order to complete monthly and quarterly claim reports

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

Works with direction from the Data Analysts to develop and implement analytical tools

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

Prepares accurate and timely claim and utilization reports for forecasting, trending and results analysis

Creates customized benchmarking reports based on the client’s needs

Assists in creating total compensation statements

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

Helps in aggregating data elements from various sources to calculate value creation across the employee benefits team

Assists marketing in keeping our internal and external facing websites up to date

Takes initiative to research and learn new projects

EXECUTION OF CLIENT SERVICES

Supports Account Managers, Producers, Account Executives and other internal department members to flawlessly execute MMA'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 timeliness of service execution

Manages time effectively to prioritize workload, client service requests and service parameters on business processes

PEER RELATIONSHIPS

Provides feedback and shares information at team meetings

Participates in ongoing scheduled meetings with service team to discuss accounts, renewals, analytics/data needs, service platform, etc.

Develops successful working relationships with Producers, Account Executives, Account Managers, service team members, managers, carriers and members of other departments

Communicates effectively with Analytics team and provides timely and complete information to allow them to effectively manage service execution

Qualifications:

REQUIRED

Upon hire, Life/Health license, as appropriate for role

Proficient in Microsoft Office Suite

PREFERRED

BS/BA in business, finance or related field

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.

Permanent