Business Analyst

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

Benefits offered by this job

Medical, dental, vision, and life ins.

Short and long-term disability

Company-match 401(k) plan

Employee Assistance Plan

HSA/FS A/HRA and wellness program

Job summary

Core Specialty Insurance Services, Inc. is seeking a Business Analyst to join the Program Data Analytics team in a hybrid role based in Cincinnati.

You will translate business requirements into actionable insights, validate data, and support program management and continuity. Key responsibilities include data reconciliation, creating reports with Power BI, and collaborating with Program Directors to enhance data collection and assess program effectiveness.

Qualifications

• Bachelor’s degree in a technical or business discipline is required.
• 3+ years of experience in business analysis roles.
• Experience gathering and documenting business requirements and translating them into data-driven solutions.
• Hands-on experience with Power BI and other visualization tools.
• Familiarity with process mapping and documentation tools such as Visio.

Responsibilities

• Process and validate data from multiple sources, ensuring accuracy and compliance.
• Perform data reconciliations to confirm consistency across datasets and resolve discrepancies with stakeholders.
• Analyze data to uncover trends driving program profitability and decision-making.
• Design, develop, and maintain reports tailored to business requirements.
• Partner with Program Directors to improve data collection and assess program effectiveness.
• Collaborate with cross-functional teams to maintain data integrity and alignment with objectives.
• Gather business requirements and translate them into actionable data-driven solutions.
• Develop and maintain process documentation to support continuity and regulatory compliance.
• Serve as liaison between business and technical teams to drive alignment with goals.
• Support continuous improvement initiatives by acting on insights.

Skills

Analytical thinking

Attention to detail

Communication skills

Stakeholder collaboration

Education

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

Tools

Power BI

SQL

KQL

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.

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

Benefits

• 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

Core Specialty offers a diversified range of property and casualty insurance products for small to mid-sized businesses. From underwriting offices spanning the U.S., the Company focuses on niche markets, local distribution, and superior underwriting knowledge, offering traditional as well as innovative insurance solutions to meet the needs of its customers and brokers.

For further information about Core Specialty, please visit www.corespecialtyinsurance.com.

In compliance with the Transparency in Coverage rule, issued in 2020 by US Departments of Health, Human Services, Labor and Treasury our health plan’s machine-readable files (MRFs) can be accessed via www.Cigna.com.