Junior Enterprise Data Conversion Analyst

Keystone Agency Partners (KAP); United States; Remote; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health Insurance

401(k) with Safe Harbor Match

Paid Time Off

Paid Holidays

Dental Insurance

Vision Insurance

Job summary

Keystone seeks a Junior Enterprise Data Conversion Analyst to support data conversion, migration, validation, reconciliation, and stabilization across Employee Benefits and P&C brokerage data.

This role partners with conversion leads, business partners, technology teams, and vendors during acquisitions, agency integrations, and platform migrations to ensure converted data is accurate, complete, and aligned with reporting and compliance needs.

Qualifications

• Bachelor's degree or equivalent.
• 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 clients, policies, carriers, producers, commissions, billing, certificates, enrollment, eligibility, census, activities, attachments, documents, and financial transactions.
• Working knowledge of Employee Benefits workflows and commercial/personal P&C workflows, including renewals, enrollments, eligibility, census, servicing, endorsements, and carrier submissions.
• Strong understanding of data mapping, profiling, cleansing, reconciliation, testing, validation, exception management, and governance.
• Ability to review source-system data, identify inconsistencies, translate requirements into conversion tasks, and develop validation procedures.
• Experience with data validation, UAT, mock conversions, defect tracking, cutover readiness, and post-conversion stabilization.
• Hands-on experience with insurance brokerage platforms and related technologies (Applied Epic, AMS360, Vertafore, Salesforce).
• Advanced proficiency in Excel; Smartsheet experience.
• Exposure to Power BI, SQL, Alteryx, Access or similar tools.
• Strong analytical, organizational, documentation, communication, and problem-solving skills.
• Proven ability to collaborate with leaders, operations, IT, vendors, and end users.
• Experience in multi-location or acquisitive brokerage environments; travel up to 15%.

Responsibilities

• Support data conversion initiatives related to system implementations, acquisitions, agency integrations, platform migrations, and transformation programs.
• Review and validate EB and P&C data including clients, accounts, policies, coverages, carriers, producers, commissions, billing, claims, enrollment, eligibility, census, and documents.
• Perform mapping, cleansing, enrichment, normalization, profiling, validation, and reconciliation for migration readiness.
• Identify missing or mismapped records and document remediation requirements.
• Support data quality reviews, defect tracking, and validation throughout the conversion lifecycle.
• Collaborate with business users, agency stakeholders, operations, IT, and vendors to gather requirements and resolve data issues.
• Assist with mock conversions, test migrations, UAT, production cutovers, post-load validation, and stabilization.
• Analyze data from agency management systems, CRM, billing systems, and carrier interfaces.
• Maintain project documentation including plans, data readiness trackers, and status updates.
• Summarize findings, risks, and remediation actions for leadership.
• Identify risks and data gaps that could affect reporting or compliance.
• Follow conversion governance and documentation standards.

Skills

Data analysis

Attention to detail

Communication

Education

Bachelor's degree or equivalent

Tools

Applied Epic

AMS360

Vertafore

Salesforce

Document management systems

Job description

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 .

Junior Enterprise Data Conversion Analyst

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.

Benefits

• Competitive Salary
• Health Insurance Plans (PPO, HSA, Copay Options)
• Dental Insurance
• 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.