Junior Enterprise Data Conversion Analyst

Mykeystone; Northern (KY); Hybrid; USD 65,000 - 100,000; Full time

Benefits offered by this job

Vision Insurance

Disability Insurance

Supplemental Insurance

401(k) with Safe Harbor Match

Paid Time Off

Paid Holidays

Job summary

Keystone is seeking a Junior Enterprise Data Conversion Analyst to support data conversion, migration, validation, reconciliation, and stabilization for multiple insurance brokerage systems. You’ll work across Employee Benefits and P&C data, assisting acquisitions, integrations, migrations, and enterprise transformation initiatives.

You will collaborate with business users, operations teams, technology partners, and vendors to ensure data accuracy, readiness for migration, and alignment with

Qualifications

• Bachelor’s degree or an equivalent combination of education and relevant professional experience.
• Minimum of 3 years of insurance brokerage operations experience supporting data conversion, data migration, systems implementation, platform consolidation, agency acquisition integration, business systems support, data analysis, or related functions.

Responsibilities

• Support data conversion initiatives related to insurance brokerage system implementations, acquisitions, agency integrations, divestitures, platform migrations, and enterprise transformation programs.
• Review, analyze, and validate Employee Benefits and Property & Casualty (P&C) brokerage data, including clients, accounts, policies, coverages, carriers, producers, commissions, billing, claims, certificates, enrollment, eligibility, census, activities, attachments, documents, and financial transactions.
• Perform data mapping, transformation, cleansing, enrichment, normalization, profiling, validation, and reconciliation activities to ensure data accuracy, completeness, and readiness for migration.
• Compare source and target system data to identify missing, duplicate, inconsistent, incomplete, or incorrectly mapped records, and document remediation requirements.
• Support data quality reviews, exception management, defect tracking, business rule validation, and issue resolution throughout the conversion lifecycle.
• Partner with business users, agency stakeholders, operations teams, technology teams, implementation partners, and vendors to gather requirements, resolve data issues, and support conversion readiness activities.
• Assist with mock conversions, test migrations, user acceptance testing (UAT), production cutovers, post-load validation, reconciliation, and post-conversion stabilization efforts.
• Analyze source data from agency management systems, CRM platforms, accounting and billing systems, document repositories, carrier interfaces, and other brokerage applications.
• Maintain project documentation and reporting, including conversion plans, data readiness trackers, mapping documents, issue logs, validation checklists, remediation trackers, test results, business sign-offs, and status updates.
• Prepare clear summaries of conversion findings, risks, open issues, validation results, and recommendations for project leadership and business stakeholders.
• Identify potential risks, data gaps, downstream impacts, and operational concerns that could affect reporting accuracy, financial integrity, compliance requirements, or client service continuity.
• Follow established conversion methodologies, governance standards, documentation practices, and escalation procedures to ensure successful project execution and audit readiness.
• Contribute to business continuity and user adoption by helping ensure converted data supports operational workflows, reporting needs, client servicing activities, and compliance requirements.
• Support continuous improvement initiatives by identifying opportunities to enhance conversion processes, data quality controls, testing approaches, and documentation standards.

Skills

Data analysis

Data validation

Project coordination

Communication

Requirements gathering

UAT testing

Risk assessment

Education

Bachelor’s degree or equivalent

Tools

Applied Epic

AMS360

Vertafore products

Salesforce

Smartsheet

Power BI

SQL

Alteryx

Access

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Remote - US, US

About Keystone

Keystone is one of the largest and fastest-growing insurance brokerages in the country — ranked #26 among U.S. retail brokers and #4 fastest-growing in the Top 50 by Business Insurance. Our platform spans 33+ states, 180+ agency partners, and more than $500 million in revenue — uniting some of the country's most respected independent agencies with the scale, tools, and resources of a national brokerage. Through operational support in finance, HR, marketing, technology, producer development, and M&A, we empower agencies to grow while preserving what makes them who they are — their client relationships and their role in the communities they serve. Guided by our trademarked commitment, "Trust, our most important policy," Keystone is building the insurance solution every family and business can count on. For more information, visit https://mykeystone.com/ .

Position Summary

The Junior Enterprise Data Conversion Analyst supports data conversion, migration, validation, reconciliation, and stabilization activities for insurance brokerage systems, with experience or working knowledge across both Employee Benefits and Property and Casualty (P&C) brokerage data and workflows. This role assists conversion leads, business partners, technology teams, and vendors during acquisitions, agency integrations, system implementations, platform migrations, and enterprise transformation initiatives. The position helps ensure converted data is accurate, complete, usable, and aligned with operational, reporting, client-service, compliance, commission, and financial needs across brokerage business segments. This role typically reports to a data conversion lead, enterprise operations leader, integration leader, transformation leader, data leader, or technology leader and works closely with business users, implementation teams, agency stakeholders, and external vendor partners.

Key Responsibilities

• Support data conversion initiatives related to insurance brokerage system implementations, acquisitions, agency integrations, divestitures, platform migrations, and enterprise transformation programs.
• Review, analyze, and validate Employee Benefits and Property & Casualty (P&C) brokerage data, including clients, accounts, policies, coverages, carriers, producers, commissions, billing, claims, certificates, enrollment, eligibility, census, activities, attachments, documents, and financial transactions.
• Perform data mapping, transformation, cleansing, enrichment, normalization, profiling, validation, and reconciliation activities to ensure data accuracy, completeness, and readiness for migration.
• Compare source and target system data to identify missing, duplicate, inconsistent, incomplete, or incorrectly mapped records, and document remediation requirements.
• Support data quality reviews, exception management, defect tracking, business rule validation, and issue resolution throughout the conversion lifecycle.
• Partner with business users, agency stakeholders, operations teams, technology teams, implementation partners, and vendors to gather requirements, resolve data issues, and support conversion readiness activities.
• Assist with mock conversions, test migrations, user acceptance testing (UAT), production cutovers, post-load validation, reconciliation, and post-conversion stabilization efforts.
• Analyze source data from agency management systems, CRM platforms, accounting and billing systems, document repositories, carrier interfaces, and other brokerage applications.
• Maintain project documentation and reporting, including conversion plans, data readiness trackers, mapping documents, issue logs, validation checklists, remediation trackers, test results, business sign-offs, and status updates.
• Prepare clear summaries of conversion findings, risks, open issues, validation results, and recommendations for project leadership and business stakeholders.
• Identify potential risks, data gaps, downstream impacts, and operational concerns that could affect reporting accuracy, financial integrity, compliance requirements, or client service continuity.
• Follow established conversion methodologies, governance standards, documentation practices, and escalation procedures to ensure successful project execution and audit readiness.
• Contribute to business continuity and user adoption by helping ensure converted data supports operational workflows, reporting needs, client servicing activities, and compliance requirements.
• Support continuous improvement initiatives by identifying opportunities to enhance conversion processes, data quality controls, testing approaches, and documentation standards.

Qualifications

• Bachelor’s degree or an equivalent combination of education and relevant professional experience.
• Minimum of 3 years of insurance brokerage operations experience supporting data conversion, data migration, systems implementation, platform consolidation, agency acquisition integration, business systems support, data analysis, or related functions.
• Experience supporting complex, cross-functional system implementation, migration, or integration initiatives.
• Knowledge of Employee Benefits and Property & Casualty (P&C) insurance brokerage operations, data structures, and workflows, including client, policy, carrier, employer group, employee/subscriber, dependent, benefit plan, producer, commission, billing, certificates, claims, enrollment, eligibility, census, activities, attachments, and document data.
• Working knowledge of Employee Benefits workflows and commercial lines and/or personal lines P&C workflows, including benefits renewals, open enrollment, eligibility management, census administration, account servicing, policy administration, endorsements, renewals, certificates, carrier submissions, claims support, producer structures, agency accounting processes, and acquisition integration activities.
• Strong understanding of data mapping, profiling, cleansing, reconciliation, testing, validation, exception management, conversion governance, and data quality management practices.
• Ability to review source-system data, identify inconsistencies, document remediation requirements, translate business requirements into conversion tasks, and develop validation and testing procedures.
• Experience supporting data validation, user acceptance testing (UAT), mock conversions, defect tracking, cutover readiness, post-conversion stabilization, and issue resolution activities.
• Hands-on experience with insurance brokerage platforms and related technologies, including Applied Epic, AMS360, Vertafore products, Salesforce, benefits administration platforms, carrier portals, document management systems, commission/accounting systems, or similar solutions.
• Advanced proficiency in Microsoft Excel, including data cleanup, filtering, lookups, pivot tables, reconciliation, exception tracking, and data analysis; experience with Smartsheet required.
• Exposure to reporting, analytics, and data management tools such as Power BI, SQL, Alteryx, Access, or similar platforms.
• Strong analytical, organizational, documentation, communication, and problem‑solving skills with the ability to clearly document business rules, data issues, validation results, remediation actions, and open items.
• Proven ability to collaborate effectively with business leaders, operations teams, IT teams, vendors, implementation partners, and end users to resolve data and system‑related issues.
• Experience working in multi‑location, regional, acquisitive, or enterprise brokerage environments is preferred.
• Ability to travel up to 15%.
• Ability to pass a criminal background check, as permitted by law.

Work Environment

This position offers remote work flexibility.

Salary Transparency Statement

In accordance with state and local pay transparency laws, we will provide the applicable salary range upon request to candidates who reside in jurisdictions where such disclosure is required.

• Vision Insurance
• Company Paid Disability Insurance
• Supplemental Insurance including Critical Illness, Accident, Legal, Pet Insurance
• 401(k) with Safe Harbor Match
• Paid Time Off
• Paid Holidays

No Solicitation Notification to Agencies

Please note that Keystone and our Partner Agencies do not accept unsolicited resumes or calls from third‑party recruiters or employment agencies. In the absence of a signed Master Service Agreement and approval from HR to submit resumes for a specific requisition, Keystone will not consider or approve payment to any third parties for hires made.