Delegated Authority Operations Analyst

Core Specialty Insurance Holdings, Inc.

Cincinnati (OH)

Hybrid

USD 65,000 - 90,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, dental, vision, and life ins.

Short and long-term disability

401(k) company-match (6%)

Employee Assistance Plan

Health Savings Account (HSA)

Flexible Spending Account (FSA)

Health Reimbursement Account (HRA)

Wellness program

Job summary

Core Specialty Insurance Holdings, Inc. is seeking an Operations Analyst to automate manual workflows, improve data quality, and support the Delegated Authority Data Modernization initiative.

The role spans program onboarding, bordereaux processing, and QA validation to reduce manual effort and ensure consistency. You will write code and combine data querying with business process analysis, collaborating with IT and cross-functional teams to translate requirements into reliable automated

Qualifications

Bachelor’s degree or equivalent practical experience in a related field.
2+ years in a Data/Operations Analyst role with automation output.
Experience in specialty insurance or Delegated Authority is a strong plus.
Ability to manage multiple priorities and meet deadlines.
Exposure to continuous improvement or SOX-compliant environments is a plus.
Excellent analytical and critical thinking skills with data-driven insights.

Responsibilities

Identify, document, and streamline recurring manual workflows using tools like Visio, Power Automate, and Excel.
Support onboarding tasks including data mapping, validation rule setup, and reference table maintenance.
Build and maintain file delivery automations for document routing and processing.
Create data dictionaries with field definitions, values, mappings, and validation rules.
Coordinate with IT on permission tickets and maintain IT relationships.
Document and maintain critical business practices across Delegated Authority units.
Support bordereaux ingestion, including validation, triage, and issue tracking.
Monitor QA results and maintain pass/fail logs; track remediation actions.

Skills

Analytical thinking

Data analysis

Process improvement

Attention to detail

Communication

Multi-tasking

Education

Bachelor’s degree in Information Systems, Computer Science, Operations, Finance, Business Analytics, or related field

Tools

Power Automate

Microsoft 365

Visio

Jira/Azure DevOps

Power BI

T-SQL

Spark SQL

Job description

The Operations Analyst is a key contributor to the Delegated Authority & Underwriting Controls team, reporting to the AVP Operations. This role is focused on automating manual workflows, improving data quality operations, and supporting the Delegated Authority Data Modernization initiative. The Operations Analyst works across program onboarding, bordereaux processing, and QA validation to reduce manual effort and improve operational consistency. A critical component of this position is coordinating with key Delegated Authority stakeholders to document and standardize essential business processes.

The ideal candidate is technically proficient, writes code to solve operational problems, and can move between data querying, scripting, and business process analysis. This position is well suited for someone who is energized by replacing repetitive manual tasks with reliable, automated solutions.

Key Accountabilities/Deliverables:

Identify, document, and streamline recurring manual workflows, leveraging available tools such as Visio, Power Automate and Excel to reduce manual effort and improve operational consistency.
Support program onboarding tasks including data mapping, field-level validation rule setup, and canonical reference table maintenance.
Build and maintain file delivery automation workflows to streamline document routing and processing across the Delegated Authority department.
Create and maintain data dictionaries across business partners, documenting field definitions, accepted values, source-to-target mappings, and validation rules to support onboarding consistency and audit readiness.
Coordinate with IT to submit and track permission related tickets, ensuring timely access provisioning while building and maintain a strong relationship with IT teams.
Partner with team members across Delegated Authority business units to document and maintain critical business practices, ensuring processes are clearly captured and accessible for operational continuity.
Support bordereaux ingestion operations including file validation, exception triage, and issue tracking across program data sources.
Monitor QA check results and maintain pass/fail/warn logs in Operations Lakehouse; escape data quality issues and track remediation actions to closure.
Collaborate with the Data Engineering team to translate business requirements into technical specifications and support pipeline development and testing.
Document operational procedures and data definitions in support of SOX control compliance and audit readiness.
Perform ad hoc analysis and produce operational reports and dashboards.
Support continuous improvement by identifying process gaps and proposing automation or tooling solutions based on operational data.
Perform additional duties as required to support evolving business needs

Technical Knowledge and Understanding:

Power Automate (required): flow design for file routing, notifications, and approval workflows.
Microsoft 365 (required): Excel (advanced), Teams; SharePoint/OneDrive familiarity is a plus.
Visio (required): process mapping and workflow documentation.
Jira/Azure DevOps: create, track, and manage tickets to support IT requests.
Power BI (desirable): report and dashboard development, DAX measures, data model design; familiarity sufficient to consume and support existing reports is acceptable.
T-SQL and Spark SQL (desirable): basic to intermediate querying against data platforms to support validation and QA tasks.

Experience:

Bachelor’s degree in Information Systems, Computer Science, Operations, Finance, Business Analytics, or a related field, or equivalent practical experience.
2+ years of experience in a Data Analyst, Operations Analyst, or similar role with demonstrated automation output.
Specialty insurance or Delegated Authority / program business experience is a strong plus.
Strong ability to manage multiple priorities simultaneously, ensuring deadlines and service expectations are consistently met.
Exposure to continuous improvement, process optimization, or SOX-compliant operational environments is a plus.
Excellent analytical and critical thinking skills with the ability to derive insights from complex datasets.
Strong attention to detail and ability to deliver accurate results within specified deadlines.
Effective communicator with the ability to convey information clearly and professionally across all levels of the organization, including with external business partners.

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.