Delegated Authority Operations Analyst

Kalepa Insurance Services, LLC; Cincinnati (OH); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

Medical, dental, and vision insurances

Life insurance

401(k) plan with company match

Employee Assistance Plan

Flexible Spending Account

Health Savings Account

Wellness program

Job summary

Kalepa Insurance Services, LLC in Cincinnati, OH is seeking a Delegated Authority Operations Analyst to enhance operational consistency through automation and support data initiatives.

Ideal candidates will have a strong technical background, experience in data analysis, and be proficient in tools like Power Automate and Visio. Competitive salary and comprehensive benefits package provided.

Qualifications

• 2+ years of experience in a Data Analyst, Operations Analyst, or similar role.
• Strong ability to manage multiple priorities simultaneously.
• Excellent analytical and critical thinking skills.

Responsibilities

• Automate manual workflows and improve data quality operations.
• Document and standardize essential business processes.
• Collaborate with IT to ensure access provisioning.

Skills

Power Automate

Microsoft 365

Visio

Jira/Azure DevOps

Power BI

T-SQL

Spark SQL

Education

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

Job description

## Delegated Authority Operations AnalystApplylocations: Cincinnati, OHtime type: Full timeposted on: Posted Todayjob requisition id: JR101445-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; escalate 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. We offer 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