Claims - Data Analyst I - III

The Cincinnati Insurance Companies is an insurance organization focused on serving independent agents and helping protect families and businesses. The Claims Data Analyst I-III analyzes claims data, creates reports and dashboards, identifies trends, and presents insights to stakeholders. The role also translates business needs into requirements, collaborates with IT, improves reporting processes, and may lead projects or mentor analysts depending on experience.

What you'll do:

• Participate in or lead meetings with customers to understand data and reporting needs
• Build strong relationships with Claims leadership and stakeholders
• Create routine and ad hoc reports based on requests throughout the organization
• Develop and validate reports, dashboards, and large-scale trending analyses
• Extract and validate information from multiple data sources
• Perform statistical analyses for projects and summarize results
• Identify trends in data and provide actionable insights
• Partner with IT to investigate data discrepancies, resolve data issues, document requirements, and test system enhancements
• Understand how claims data is transformed from a source system to multiple downstream systems, including how the data is used in legacy systems, agency/insured portals, and in corporate data warehouses
• Help define and improve reporting processes
• Independently review and interpret data requests and follow through with timely reporting
• Ensure accuracy and consistency of claims data across data sources

What they're looking for:

• The ability to proactively identify, build, and maintain relationships with stakeholders
• Strong problem-solving skills
• Keen attention to detail
• Clear written and verbal communication skills
• Ability to present complex information in an understandable and compelling manner
• Fluency with advanced Microsoft® Excel functionality including pivot tables, Power Query, combination charts, vlookups, and complex calculations
• Experience with data analysis, reporting, and creating queries to extract data
• Ability to manage multiple projects and meet deadlines independently
• Quick to learn new technical concepts and adapt to change
• Focus on improving processes and finding efficiencies
• Experience with or willingness to learn Excel macros, VBA, or other common coding languages (i.e. SAS, SQL, or DAX, etc.)
• Qualified candidates have earned a bachelor's degree in business, mathematics, statistics or information technology-related fields or related experience

Benefits:

• Eligible associates may also receive an annual cash bonus and stock incentives based on company and individual performance.
• Cincinnati provides you with the tools and training to be successful and to become a trusted, respected insurance professional – all while enjoying a meaningful career.