As a key member of our Actuarial & Client Informatics team, the Informatics Consultant/Specialist is responsible for collecting, organizing, summarizing, analyzing, and reporting data from carriers and vendors in an accurate and timely manner. This role supports the Underwriting & Pharmacy practice by providing quantitative reports and effectively communicating findings. The ideal candidate will possess a blend of business acumen and technical skills, enabling them to leverage various tools to enhance data analysis and reporting processes.

Key Responsibilities:

Develop and customize reports for internal stakeholders using tools such as Power BI, SQL Server, Excel, and PowerPoint, incorporating current and prospective client data.Conduct data analysis utilizing knowledge of employee benefits and data handling to support business improvement and strategy projects, providing insights on population, cost, utilization trends, and cost drivers.Complete report and data requests within established timeframes to ensure timely delivery and support informed decision-making processes.Organize and structure data according to reporting requirements, ensuring key insights are identified and communicated effectively to internal stakeholders.Implement methodologies within the department, collaborating with colleagues in Actuarial & Client Informatics and IT to maintain and enhance the reporting infrastructure, including data housing, data modeling, report performance, and report design and delivery tools.Demonstrate flexibility in approach and follow-up to achieve resolution of outstanding issues.

Knowledge, Skills, and Abilities:

Growth mindset that provokes continual development of the process and analytics performed.Creative problem-solving skills with the ability to work collaboratively in a team environment.Strong proficiency in data analysis tools (e.g., SQL, VBA, Excel, Python) and visualization software (e.g., Power BI).Ability to multi-task and thrive in a fast-paced environment.Knowledge of employer-sponsored Medical, Prescription Drug, Dental, Vision and Stop Loss coverageStrong interpersonal skills to effectively interact with internal team members.

Education and Experience:

Bachelor’s Degree in Risk Management & Insurance, Actuarial Science, Mathematics, Business Analytics, or a related field is preferred; equivalent experience will be considered.Internship or work experience in the Benefits Brokerage, Consulting, or Insurance industry is preferred.

We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. Marsh & McLennan Agency offers competitive salaries and comprehensive benefits and programs including health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: http://marshmma.com/careers. 

 #MMAE