Business Analyst

Core Specialty Insurance Holdings, Inc.; Cincinnati (OH); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical, dental, vision, and life ins.

Short and long-term disability

401(k) company match

Employee Assistance Plan

Health Savings Account

Flexible Spending Account

Health Reimbursement Account

Wellness program

Job summary

Core Specialty Insurance Holdings, Inc. is seeking a Business Analyst to join the Program Data Analytics team in Cincinnati. You will translate business requirements into actionable insights, support program management, and ensure data integrity across the Delegated Authority and Underwriting Controls division.

You will lead data validation, perform in-depth analyses, and develop reports that meet stakeholder needs while driving continual improvement in data processes and regulatory compliance.

Qualifications

• Bachelor’s degree in a technical or business discipline such as Business Analytics, Information Systems, or Finance.
• 3+ years of experience in business analysis roles.
• Experience gathering and documenting business requirements and translating them into data-driven solutions.
• Power BI experience and strong data visualization skills.
• Experience with data reconciliation and maintaining data quality.

Responsibilities

• Process and validate data from multiple sources, ensuring accuracy and compliance with standards.
• Perform data reconciliations to confirm consistency and resolve discrepancies with stakeholders.
• Analyze data to uncover trends and drivers informing profitability and decisions.
• Design, develop, and maintain reports tailored to business needs.
• Collaborate with Program Directors to enhance data collection processes.

Skills

Analytical thinking

Problem solving

Stakeholder collaboration

Education

Bachelor’s degree in Business Analytics, Information Systems, or Finance

Tools

MS Excel

MS Access

Power BI

SQL

KQL

Visio

Job description

The Business Analyst is a critical member of the Program Data Analytics team, responsible for partnering with Program Directors and stakeholders to ensure effective Program management and continuity. This role is central to translating business requirements into actionable insights, resolving complex data challenges, and documenting processes that support both strategic and operational objectives.

Key responsibilities include leading the implementation of new programs, monitoring ongoing initiatives, and delivering impactful insights through advanced data analysis. The position requires validating and reconciling data, performing in-depth analysis, and maintaining the accuracy and integrity of information across the Delegated Authority and Underwriting Controls division. By connecting business priorities with data-driven solutions, the Business Analyst enables informed decision-making and drives program performance.

Key Accountabilities/Deliverables:

• Process and validate data from multiple sources, ensuring accuracy, completeness, and compliance with established standards.
• Perform comprehensive data reconciliations to confirm consistency across datasets, promptly resolving discrepancies in collaboration with key stakeholders.
• Analyze data to uncover trends, patterns, and drivers that inform program profitability and strategic decision-making.
• Design, develop, and maintain reports tailored to business requirements and stakeholder needs.
• Partner with Program Directors to enhance data collection processes and assess program effectiveness.
• Collaborate with cross-functional teams to maintain data integrity and ensure alignment with organizational objectives.
• Gather and document business requirements from stakeholders and translate them into actionable, data-driven solutions.
• Develop and maintain process documentation to support operational continuity and regulatory compliance.
• Serve as a liaison between business and technical teams, addressing data-related issues and driving alignment with strategic goals.
• Support continuous improvement initiatives by recommending enhancements based on data insights and stakeholder feedback.
• Perform additional duties as required to support evolving business needs.

Technical Knowledge and Understanding:

• Proven experience as Business Analyst (Insurance industry experience is a plus).
• Deep understanding of business processes and proven ability to translate complex requirements into effective technical solutions.
• Proficient in a range of tools and query languages, including MS Excel, MS Access, Power BI, and languages such as SQL and KQL.
• Familiarity with process mapping and documentation tools such as Visio.
• Excellent analytical and problem-solving skills with the ability to derive insights from complex datasets.
• Strong attention to detail and ability to deliver accurate results within specified deadlines.

Experience:

• Bachelor’s degree in a technical or business discipline, such as Business Analytics, Information Systems, or Finance required.
• 3 + years of experience in business analysis roles.
• Demonstrated experience in gathering and documenting business requirements and translating them into data-driven solutions.
• Strong ability to manage multiple priorities simultaneously, ensuring deadlines and service expectations are consistently met.
• Hands-on experience with Power BI and other visualization.
• Exposure to continuous improvement initiatives and process optimization projects, driving efficiency and operational excellence.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over work authorization sponsorship now or in the future for this position.

#LI-Hybrid

At Core Specialty, you will receive a competitive salary and opportunities for professional development and advancement.

• medical, dental, vision, and life insurances
• short and long-term disability
• a Company-match of 100% of a 6% contribution 401(k) plan
• an Employee Assistance Plan
• Health Savings Account
• Flexible Spending Account
• Health Reimbursement Account
• and a wellness program