Claims - Data Analyst I-III

Join The Cincinnati Insurance Companies as a Claims Data Analyst I-III in Fairfield, Ohio. This onsite role centers on turning claims data into clear insights, building routine and ad hoc reports, spotting trends, and delivering actionable results. You’ll have opportunities to lead initiatives and mentor teammates within a collaborative, service-focused culture.

What we offer you goes beyond a paycheck. Expect strong relationships with claims leadership and independent agents, a commitment to lifelong learning, and the tools and training you need to grow into a trusted, respected insurance professional. This is more than a job—it's a meaningful career path with room to advance.

Enhance Your Talents

Providing outstanding service and cultivating solid relationships with independent agents are core to our approach. Whether you come from another carrier or are new to insurance, we emphasize continuous learning. You will receive comprehensive training and the resources to succeed and advance within the organization.

Enjoy Benefits and Amenities

We recognize the importance of well-being and job satisfaction. Our benefits and amenities are designed to support associates who contribute to solutions that impact lives, while fostering a positive, productive work environment.

Embrace a Diverse Team

As a relationship-based organization, we value a diverse workforce. We provide equal employment opportunities to all qualified individuals without regard to race, creed, color, sex including sexual orientation, religion, national origin, age, disability, or any other basis prohibited by law, in line with federal employment notices.

Responsibilities

• 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 across 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 source systems to downstream systems, including use in legacy systems, agency and insured portals, and corporate data warehouses
• help define and improve reporting processes
• independently review and interpret data requests and deliver timely reporting
• ensure accuracy and consistency of claims data across data sources
• serve as a subject matter expert for Claims data on corporate-level projects
• explore and implement new reporting tools and solutions
• proactively identify ways to improve and automate processes with efficiency in mind
• participate in peer reviews and mentor other analysts, based on experience

Requirements

• 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 a clear, compelling way
• fluency with advanced Microsoft Excel functionality including pivot tables, Power Query, combination charts, VLOOKUP, and complex calculations
• experience with data analysis, reporting, and creating queries to extract data
• knowledge of Power BI or other data visualization software preferred
• 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 such as SAS, SQL, or DAX

Technologies

• Microsoft Excel, Power Query, Pivot Tables, VLOOKUP, Power BI, PowerPivot, DAX
• SAP Business Warehouse, Cognos, SAS, R, SPSS, SQL

Education and Experience

Qualified candidates have earned a bachelor’s degree in business, mathematics, statistics or information technology-related fields, or related experience.

Location and Compensation

Location: Fairfield, Ohio (onsite). Salary: USD 55,000 to 90,000 per year.