Senior Data Conversion Engineer

CCMSI; Danville (IL); Remote; USD 105,000 - 130,000; Full time

Benefits offered by this job

PTO 4 weeks

10 paid holidays

Medical, Dental, Vision

Life and Disability Insurance

401(k) with ESOP

Career growth

Job summary

CCMSI is seeking a Senior Data Conversion Engineer to lead complex data migration and transformation across claims, policy, billing, medical, and financial systems. You will own end-to-end conversions, build automation, and collaborate with operations, IT, and analytics to ensure accurate, auditable data.

The role requires strong SQL, ETL/ELT design skills, and experience handling large datasets. Remote work with periodic travel to CCMSI branch locations is required.

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years leading data conversion/migration projects.
• Strong SQL & relational databases experience.
• Experience designing ETL/ELT processes.
• Data mapping, transformation, reconciliation & validation experience.
• Ability to work with large, complex datasets.
• Automation solution development to streamline conversions.
• Excellent communication & stakeholder management.

Responsibilities

• Lead end-to-end data conversion projects from discovery to production.
• Develop conversion strategies, mapping docs, and transformation specs.
• Design and execute migration plans for multiple data domains.
• Collaborate with stakeholders to define requirements and acceptance criteria.
• Manage multiple conversions while maintaining timelines and quality.

Skills

SQL proficiency

ETL/ELT processes

Data mapping & validation

Automation solutions

Stakeholder management

Project management

Travel readiness

Education

Bachelor's degree in CS/IS/Data Analytics/Engineering

Tools

ETL tools

Job description

Location: Remote

Salary Range: $105,000 - $130,000 annually

Build Your Career With Purpose at CCMSI

At CCMSI, we partner with global clients to solve their most complex risk management challenges, delivering measurable results through advanced technology, collaborative problem-solving, and an unwavering commitment to their success. We don’t just process claims—we support people. As the largest privately-owned Third Party Administrator (TPA), CCMSI delivers customized claim solutions that help our clients protect their employees, assets, and reputations. We are a certified Great Place to Work®, and our employee-owners are empowered to grow, collaborate, and make meaningful contributions every day.

Overview

Senior Data Conversion Engineer

Location: Remote

Salary Range: $105,000 - $130,000 annually

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.

Responsibilities

Data Conversion

• 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.

Data Transformation & Engineering

• 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.

Data Validation & Quality Assurance

• 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.

Qualifications

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Why You’ll Love Working Here

• 4 weeks (Paid time off that accrues throughout the year in accordance with company policy) + 10 paid holidays in your first year
• Comprehensive benefits: Medical, Dental, Vision, Life, and Disability Insurance
• Retirement plans: 401(k) and Employee Stock Ownership Plan (ESOP)
• Career growth: Internal training and advancement opportunities
• Culture: A supportive, team‑based work environment

Compensation & Compliance

The posted salary reflects CCMSI’s good‑faith estimate in accordance with applicable pay transparency laws. Actual compensation will be based on qualifications, experience, geographic location, and internal equity. This role may also qualify for bonuses or additional forms of pay.

CCMSI offers comprehensive benefits including medical, dental, vision, life, and disability insurance. Paid time off accrues throughout the year in accordance with company policy, with paid holidays and eligibility for retirement programs in accordance with plan documents.

CCMSI posts internal career opportunities in compliance with applicable state and local promotion transparency laws.

Visa Sponsorship:

CCMSI does not provide visa sponsorship for this position.

ADA Accommodations:

CCMSI is committed to providing reasonable accommodations throughout the application and hiring process.

Equal Opportunity Employer:

CCMSI complies with all applicable employment laws, including pay transparency and fair chance hiring regulations.

Background checks, if required for the role, are conducted only after a conditional offer and in accordance with applicable fair chance hiring laws.

Our Core Values

At CCMSI, We Believe In Doing What’s Right—for Our Clients, Our Coworkers, And Ourselves. We Look For Team Members Who

• Lead with transparency We build trust by being open and listening intently in every interaction.
• Perform with integrity We choose the right path, even when it is hard.
• Chase excellence We set the bar high and measure our success. What gets measured gets done.
• Own the outcome Every employee is an owner, treating every claim, every decision, and every result as our own.
• Win together Our greatest victories come when our clients succeed.

We don’t just work together—we grow together. If that sounds like your kind of workplace, we’d love to meet you.

#CCMSICareers #EmployeeOwned #GreatPlaceToWorkCertified #ESOP #SeniorDataConversionEngineer #DataEngineering #DataMigration #SQLJobs #ETL #DataTransformation #InsuranceTechnology #ClaimsManagement #TPA #InsurTech #NowHiring #IND123