Data Analytics Coordinator - Employee Health & Benefits

Schaumburg, Illinois
Not Specified
Jun 26, 2024
Aug 25, 2024
Job Type
Not Specified
Career Level
Not Specified

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 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.


  • 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 Senior Financial 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 Service

  • 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 Financial Analytics team and provides timely and complete information to allow them to effectively manage service execution


  • 1-3 years' of experience in financial analytics

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

  • Proficient in Microsoft Office Suite


  • BS/BA in business, finance or related field

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.