Claims - Data Analyst I - III

The Cincinnati Insurance Companies; Fairfield (OH); On-site; USD 55,000 - 90,000; Full time

Job summary

The Cincinnati Insurance Companies in Ohio seek a Claims Data Analyst I-III to analyze claims data, build reports, and translate business needs into clear requirements. This role partners with IT to enhance deliverables and may lead projects as experience grows.

Starting pay ranges from $55,000 to $90,000 annually, with eligibility for annual cash bonuses and stock incentives based on performance. You will develop reports, dashboards, and trending analyses, extract data from multiple sources,

Qualifications

• Bachelor's degree in business, mathematics, statistics or IT-related fields, or related experience.
• Prefer knowledge of the insurance industry and risk management.
• 2+ years hands-on experience with reporting tools such as SAP BW, Power BI, Cognos or other tools for analytics and reporting.
• Familiar with data models and tools like PowerPivot; statistics knowledge is a plus.

Responsibilities

• Participate in or lead meetings with customers to understand data and reporting needs.
• Develop and validate reports, dashboards, and large-scale trending analyses.
• Extract and validate information from multiple data sources.
• Collaborate with IT to investigate data discrepancies and test system enhancements.
• Mentor other analysts and lead projects as experience grows.
• Ensure accuracy and consistency of data across sources.

Skills

Stakeholder relations

Data analysis

Reporting

Statistical analyses

Advanced Excel

Power BI

SQL

Project management

Education

Bachelor's degree in business or IT-related field

Tools

SAP Business Warehouse

Power BI

Cognos

SAS/R/SPSS

PowerPivot

Job description

Make a difference with a career in insurance

At The Cincinnati Insurance Companies, we put people first and apply the Golden Rule to our daily operations. To put this into action, we’re looking for extraordinary people to join our talented team. Our service-oriented, ethical, knowledgeable, caring associates are the heart of our vision to be the best company serving independent agents. We help protect families and businesses as they work to prevent or recover from a loss. Share your talents to help us reach for continued success as we bring value to the communities we serve and demonstrate that Actions Speak Louder in Person®.

If you’re ready to build productive relationships, collaborate within a diverse team, embrace challenges and develop your skills, then Cincinnati may be the place for you. We offer career opportunities where you can contribute and grow.

Build your future with us

Our Claims Operations department is currently seeking a Claims Data Analyst I - III. A Claims Data Analyst is responsible for understanding and analyzing claims data, creating reports, completing data requests, identifying and interpreting data trends, and presenting results to stakeholders. This analyst will work closely with internal and external customers to translate business needs into clear requirements and deliver solutions. This role involves frequent collaboration with IT to enhance deliverables. As a Claims Data Analyst, the responsibilities scale with experience and proficiency, so the candidate can be expected to fulfill leadership roles on projects, mentor fellow team members, establish and maintain relationships with internal and external customers, and independently manage workload.

Starting pay: The pay range for this position is $55,000 - $90,000 annually. Pay is based on the applicant’s education, experience, location, knowledge, skills and abilities. Eligible associates may also receive an annual cash bonus and stock incentives based on company and individual performance.

Be Ready To

• 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
• serve as a subject matter expert for Claims data on corporate-level projects
• explore and implement new reporting tools and solutions
• proactively find ways to improve and automate processes, keeping efficiency at the forefront of work efforts
• participate in peer review and mentor other analysts, depending on experience

Be Equipped With

• 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
• 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 (i.e. SAS, SQL, or DAX, etc.)

Bring Education And Experience From

• qualified candidates have earned a bachelor's degree in business, mathematics, statistics or information technology-related fields or related experience
• preferred knowledge of insurance industry and risk management
• professional insurance designations are preferred but not necessary
• knowledge of statistical analyses
• familiar with data models and tools like PowerPivot
• preferably 2+ years hands‑on experience with reporting tools like SAP Business Warehouse, Power BI, Cognos or other tools for analytics and reporting
• experience using SAS, R, SPSS or other statistical packages is desirable

Enhance your talents

Providing outstanding service and developing strong relationships with our independent agents are hallmarks of our company. Whether you have experience from another carrier or you’re new to the insurance industry, we promote a lifelong learning approach. 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.

Enjoy Benefits And Amenities

Your commitment to providing strong service, sharing best practices and creating solutions that impact lives is appreciated. To increase the well-being and satisfaction of our associates, we offer a variety of benefits and amenities. Learn more about our benefits and amenities packages.

Embrace a diverse team

As a relationship-based organization, we welcome and value a diverse workforce. We grant equal employment opportunity to all qualified persons without regard to race; creed; color; sex, including sexual orientation; religion; national origin; age; disability; or any other basis prohibited by law. Learn more about the Federal Employment Notices .

US-OH-Fairfield