Data Analyst - Business Insurance

Overview
The Data Analyst will ensure the execution of our analytics platform and measure the impact of our efforts. He or she reviews detailed information, analyzes data in terms of specific business goals, and displays findings in simple, meaningful, and actionable formats consistent with our brand. The 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.
Responsibilities
ANALYTICS

• Analyzes and compiles various reports, including but not limited to: Loss Projections, Reserve/Collateral Analysis, Loss Analysis, Experience Modification Projections and Analysis
• Prepares loss experience reports for forecasting, trending and results analysis
• Performs statistical, cost and financial analysis of data reported in various formats
• Creates customized dashboards when requested by production team
• Assists with the administration of Alternative Risk Programs

EXECUTION OF CLIENT SERVICE

• Works with Producer(s), service team, and other internal departments to successfully execute Assurance's service strategy
• 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 coverage terms, program options, and other issues to clients as needed
• Effectively manages time to ensure workload is prioritized, client needs are addressed, and Assurance'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, 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

Qualifications
REQUIRED:

• Upon hire, Producers License for Property/Casualty
• Advanced skill in Microsoft Excel
• 1+ year of insurance experience

PREFERRED:

• BS/BA in insurance & risk management, business administration, accounting, finance, economics or mathematics
• Proficient in Microsoft Office Suite
• Knowledge of insurance analytics concepts and tools

About Assurance
Assurance, a Marsh & McLennan Agency LLC, company, is a full-service brokerage providing Business Insurance, employee benefits, private client insurance, and retirement services to businesses and individuals across the country. Assurance operates as Marsh & McLennan Agency's Midwest regional headquarters. Consistently recognized as a top workplace, Assurance attracts and retains its insurance talent by rewarding expertise and investing in career development. Assurance employees enjoy an award-winning culture that fosters a highly productive and results-driven working environment.
Services: Business Insurance, Employee Benefits, Financial Services, Private Insurance, Surety
Awards: Assurance is continually named a "Best Place to Work" by leading publications and organizations such as Fortune magazine, the National Association for Business Resources, The Chicago Tribune, Crain's Chicago Business and Business Insurance magazine (check out all of our accolades).
Culture: Our employees enjoy an environment that fosters success and creativity and provides countless opportunities for growth. We make sure our employees are happy and motivated by offering enviable benefits, rewards programs, celebrations, perks and a few surprises around every corner. Together, it all adds up to a company that develops and retains passionate individuals who deliver superior performance and measurable results to our clients.
Fun Fact: 31% of Assurance experts agree the best Saturday Night Live skit of all time is "More Cowbell".
Assurance has won over a hundred workplace awards largely due to our intentional and caring approach that begins with meeting our people where they are, celebrating their differences and creating an inclusive environment.
Assurance is a proud equal opportunity employer. We celebrate diversity and we are committed to equal employment opportunities regardless of age, race, ethnicity, color, religion, creed, sex, sexual orientation, gender identity, gender expression, national origin, marital status or civil partnership/union status, veteran status, citizenship, pregnancy, genetic information, physical or mental disability, or any other status or characteristic protected by federal, state or local law.
Harassment or discrimination based upon any of the above is inconsistent with our values and will not be tolerated; this includes harassment or discrimination for being associated with or knowing someone that identifies with any of the above.
Marsh & McLennan Agency (MMA) provides colleagues the freedom to make a career and difference. We encourage you to explore your curiosity and creativity. We gain new insight from diverse thinking, and take risks on new ideas. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. We are always seeking those with ethics, talent, and ambition who are interested in joining our client-focused teams. More than just insurance brokers, we believe that a business culture that supports a healthy, safe work environment does so by offering the right benefits, programs, policies and opportunities to keep employees engaged and productive including: health and welfare, tuition assistance, 401K, employee assistance program, volunteer opportunities, and other programs.