Business Analyst

Core Specialty Insurance Holdings, Inc.; Cincinnati (OH); On-site; USD 75,000 - 95,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 partner with Program Directors and stakeholders, translating requirements into actionable insights and ensuring data integrity across the Delegated Authority and Underwriting Controls division.

You will lead data-driven program assessments, develop reports in Power BI, and support continuous improvement initiatives to enhance program profitability and operational excellence.

Qualifications

• Bachelor’s degree in a technical or business discipline.
• 3+ years of experience in business analysis.
• Experience gathering and documenting business requirements and translating them into data-driven solutions.
• Strong skills in Power BI, Excel, and SQL/KQL.
• Ability to manage multiple priorities and meet deadlines.

Responsibilities

• Validate and reconcile data from multiple sources for accuracy.
• Design, develop, and maintain reports for stakeholders.
• Translate business requirements into data-driven solutions.
• Collaborate with Program Directors to improve data collection processes.
• Maintain data integrity across the Delegated Authority and Underwriting Controls division.
• Serve as liaison between business and technical teams.

Skills

Business Analyst experience

Data analysis

SQL/KQL proficiency

Power BI

Visio usage

Detail-oriented

Education

Bachelor's degree in Business Analytics / Information Systems / Finance

Tools

Power BI

MS Excel

MS Access

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.

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
• a wellness program