This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/11910039 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, pro edure 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, eco