Demo

Claims - Data Analyst II

The Cincinnati Insurance Companies
Fairfield, OH Full Time
POSTED ON 1/11/2025
AVAILABLE BEFORE 4/9/2025

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.

Start your journey with us

Our Claims Operations department is currently seeking a Claims Data Analyst II. The Claims Data Analyst II is responsible for understanding and analyzing claims data, partnering with internal and external customers to provide reports and analysis, and identifying and interpreting claim data trends. This individual must be able to understand customer needs and reporting tool functionality, synthesize the needs and reporting capabilities into functional specifications, deliver solutions, and when necessary, collaborate with IT to design applications to meet customer needs.

As a Claims Data Analyst II, the candidate is expected to fulfill leadership roles on projects, mentor fellow team members, establish and maintain relationships with internal and external customers, and independently manage their own workload and projects.

This is a hybrid role, empowering associates to work from home and at our Headquarters office in Fairfield, OH.

Starting salary : the pay range for this position is $70,000- $85,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 :

  • lead meetings with customers to understand report or analysis requirements
  • mentor other Claims Data Analyst associates
  • build and maintain relationships with claims leadership
  • collaborates with IT to troubleshoot reporting issues and in designing new reporting applications to ensure reporting and analysis requests can be supported
  • generate routine and ad hoc reports based on business requests
  • develop and validate graphs; reports and presents analysis results
  • perform statistical analyses for projects and reports
  • extract and validate information from a variety of data sources
  • interpret data and develop recommendations based on findings
  • independently identify, analyze and interpret trends or patterns in complex data sets
  • participates in establishing team and reporting processes
  • document analysis performed and methods used in meeting customer needs
  • independently review and interpret statutory data requests and follow through with timely reporting
  • ensure accuracy and consistency of claims data across data sources
  • participate in peer review of complex, routine and ad hoc analyses and reports
  • take ownership of gathering and documenting requirements, as well as developing and executing test plans for system enhancements and defects
  • 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
  • troubleshoot and identify the root cause of inconsistencies between a source system and downstream data
  • explore and implement new reporting solutions options by : providing proofs of concept, impact analyses, validation / testing of data, development of the final tool using SAS, Access, Cognos, or other tools, and training users
  • lead projects to increase efficiency and streamline processes within the team or department, and serve as subject matter expert for Claims / claims data on corporate-level projects

Be equipped with :

  • the ability to proactively identify, build, and maintain relationships with agents, Claims managers, IT associates, and colleagues
  • strong problem solving skills
  • superior interpersonal and written communication skills
  • keen attention to detail
  • effective speaking skills when communicating with business users about requests and requirements
  • the ability to present complex claims information in an understandable and compelling manner
  • fluency with advanced Microsoft® Excel tools including pivot tables, combination charts and vlookup
  • proficiency with Microsoft Word, Access and PowerPoint
  • the skills to create complex queries and write reports
  • experience with analyzing data and knowledge of applying statistical analysis to claims data
  • the ability to comprehend technical and logical concepts and adapt quickly to changes
  • the ability to maintain own workflow and meet deadlines while managing parallel project deliverables independently
  • determination to seek out efficiencies and innovation
  • the ability to identify and recognize non-obvious problems
  • comfortable with Excel macros, VBA, or other common coding languages (i.e. SAS, SQL, or DAX, etc.)
  • You've earned :

  • Qualified candidates have earned a bachelor's degree in business, mathematics, statistics or information technology-related fields or related experience.
  • Professional insurance designations are preferred but not necessary
  • Skills :

  • familiar with data models and tools like PowerPivot
  • knowledge of statistical analysis
  • 3 years of hands-on experience using Cognos, SAP Business Warehouse, Power BI or other reporting tools for analytics and reporting
  • knowledge of insurance industry and risk management
  • 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.

    Salary : $70,000 - $85,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Claims - Data Analyst II?

    Sign up to receive alerts about other jobs on the Claims - Data Analyst II career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $97,729 - $131,248
    Income Estimation: 
    $121,246 - $165,092
    Income Estimation: 
    $76,293 - $101,657
    Income Estimation: 
    $97,729 - $131,248
    Income Estimation: 
    $97,729 - $131,248
    Income Estimation: 
    $121,246 - $165,092
    Income Estimation: 
    $63,693 - $82,116
    Income Estimation: 
    $78,860 - $101,439
    Income Estimation: 
    $62,090 - $81,673
    Income Estimation: 
    $76,293 - $101,657

    Sign up to receive alerts about other jobs with skills like those required for the Claims - Data Analyst II.

    Click the checkbox next to the jobs that you are interested in.

    • BI Analytics/Reporting Tools Skill

      • Income Estimation: $73,762 - $101,003
      • Income Estimation: $78,852 - $103,204
    • Brand Management Skill

      • Income Estimation: $82,611 - $108,161
      • Income Estimation: $81,066 - $102,466
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at The Cincinnati Insurance Companies

    The Cincinnati Insurance Companies
    Hired Organization Address Fairfield, OH Full Time
    US-OH-Fairfield Description Make a difference with a career in insurance At The Cincinnati Insurance Companies, we put p...
    The Cincinnati Insurance Companies
    Hired Organization Address Omaha, NE Full Time
    US-NE-Omaha Description Make a difference with a career in insurance At The Cincinnati Insurance Companies, we put peopl...
    The Cincinnati Insurance Companies
    Hired Organization Address Michigan, MI Full Time
    Make a difference with a career in insurance At The Cincinnati Insurance Companies, we put people first and apply the Go...
    The Cincinnati Insurance Companies
    Hired Organization Address Fairfield, OH Full Time
    US-OH-Fairfield Description Make a difference with a career in insurance At The Cincinnati Insurance Companies, we put p...

    Not the job you're looking for? Here are some other Claims - Data Analyst II jobs in the Fairfield, OH area that may be a better fit.

    Data Analyst Level II

    Saxon Global, Cincinnati, OH

    Maintenance Engineer II

    Pioneer Data Systems, Cincinnati, OH

    AI Assistant is available now!

    Feel free to start your new journey!