Senior Data Conversion Engineer

Ccmsi • Danville, IL

1d • Remote

About The Position

CCMSI is seeking a highly skilled Senior Data Conversion Engineer to for complex data migration and transformation initiatives supporting claims administration, policy administration, financial systems, medical bill review platforms, and client onboarding projects. This role specializes in converting data from legacy systems, third-party TPAs, carriers, and self-insured entities, into CCMSI's core platforms and analytics environment. The ideal candidate possesses deep expertise in data mapping, data transformation, validation, reconciliation, and automation, along with a strong understanding of insurance and claims operations. The Senior Data Conversion Engineer serves as both a technical lead and hands-on builder, partnering directly with implementation teams, claims operations, client services, IT, analytics, and external clients to ensure accurate, auditable, and timely data conversions. Accuracy is critical, as converted data supports claims handling, client reporting, regulatory compliance, financial reporting, actuarial analyses, and operational decision-making. This role requires periodic travel to CCMSI branch locations for project planning, implementation support, stakeholder collaboration, and training activities. Travel is expected approximately four or more times annually.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or related field; equivalent experience considered.
• 5+ years of experience leading and executing data conversion, migration, or transformation projects.
• Strong proficiency in SQL and relational databases.
• Experience designing and implementing ETL/ELT processes.
• Experience with data mapping, transformation logic, reconciliation, and validation methodologies.
• Proven ability to work with large and complex datasets.
• Experience developing automation solutions to streamline conversion efforts.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Experience managing multiple projects and competing priorities
• Ability to travel domestically to CCMSI branch locations at least four times annually.
• Must be authorized to work in the United States without current or future visa sponsorship.

Nice To Haves

• Experience working with claims administration or insurance systems.
• Direct experience with Third-Party Administrator (TPA) platforms.
• Experience converting data from legacy insurance or claims systems.
• Knowledge of workers' compensation, liability, property, and casualty insurance data.
• Familiarity with cloud-based data platforms and data warehouses.
• Experience supporting client onboarding and implementation projects.
• Exposure to data governance and master data management practices.
• Knowledge of data integration tools and APIs.

Responsibilities

• Able to independently work end-to-end data conversion projects from discovery through production implementation.
• Analyze source systems and develop detailed conversion strategies, mapping documents, and transformation specifications.
• Design and execute data migration plans for claims, policy, billing, medical, financial, and client-specific datasets.
• Collaborate with internal business stakeholders and external clients to define conversion requirements and acceptance criteria.
• Manage multiple concurrent conversion initiatives while maintaining project timelines and quality standards.
• Design, build, and maintain automated data transformation processes using SQL, ETL/ELT tools, scripting, and cloud-based technologies.
• Develop reusable conversion frameworks and automation solutions that improve speed, consistency, and accuracy.
• Create and optimize complex SQL queries, stored procedures, validation routines, and reconciliation processes.
• Support data movement between legacy platforms, third-party systems, CCMSI core applications, and enterprise reporting environments.
• Build and maintain data pipelines supporting claims, policy, billing, medical bill review, and financial reporting data.
• Develop comprehensive validation and reconciliation processes to ensure completeness and accuracy of converted data.
• Perform detailed record-level analysis to identify, troubleshoot, and resolve data anomalies.
• Establish automated quality controls, exception reporting, and audit processes.
• Verify converted data aligns with business rules, operational workflows, and reporting requirements.
• Validate financial transactions, reserves, payments, recoveries, and claim history data to ensure accurate conversion outcomes.

Benefits

• Medical, Dental, Vision, Life, and Disability Insurance
• 401(k) and Employee Stock Ownership Plan (ESOP)
• 4 weeks (Paid time off that accrues throughout the year in accordance with company policy) + 10 paid holidays in your first year
• Internal training and advancement opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Senior