Data Conversion Lead
About The Position
Lead and manage end-to-end data conversion of healthcare payer data between platforms (e.g., legacy system to HealthRules Payer / GuidingCare). Serve as subject matter expert for payer data domains — Claims, Enrollment, Provider, and Authorizations — including data structures, relationships, and business rules. Analyze healthcare payer data patterns, perform data profiling, and define transformation and mapping rules required to migrate data from source to target platform. Design and execute a phased conversion plan covering mock runs, parallel runs, and full-volume loads, setting realistic timelines and client expectations. Lead workflow and gap analysis sessions; identify data discrepancies and define resolution strategies. Write, maintain, and unit-test data conversion code (Python, SQL) based on documented transformation logic of limited to moderate complexity. Design ETL processes including data extracts, load logic, stored procedures, workflows, and data mappings. Enforce naming standards and maintain data dictionaries and documentation for all conversion data models. Handle post-installation testing; identify and correct any conversion defects prior to go-live. Plan and conduct client and user review sessions on conversion results; implement corrections based on feedback. Maintain consistent communication with the client on conversion progress, risks, and issue resolution. Develop comprehensive documentation for all data conversions — transformation rules, mapping specs, profiling findings, and validation reports. Collaborate with project managers, business teams, and cross-functional stakeholders across onshore and offshore teams. Mentor and guide junior team members on conversion processes, best practices, and technical standards. Develop and contribute to reusable conversion assets, accelerators, and knowledge repositories.
Requirements
- 4 + years of working experience with Healthcare Payer data domains: Claims, Enrollment or Provider.
- Bachelor's degree or higher in a Business or Technical field.
- 12+ years of working experience in technology integrations, with 7+ years in technical leadership roles.
- Hands-on experience leading data conversion or data migration projects — including mock, parallel, and full-volume execution phases.
- Working experience with ETL design and implementation experience across extract, transform, and load phases.
- Experience with SQL for data extraction, validation, transformation, and profiling (SQL Server or equivalent).
- Experience working in an onshore/offshore delivery model.
- Working experience with Python to extract data and automation of conversion routines.
- Bulk data loading experience.
- Excellent communication skills to present conversion status, risks, and results clearly to clients and senior management.
- Working experience in a team environment (onshore/offshore technical resources).
Nice To Haves
- Experience architecting software or data solutions and applying architecture governance principles.
- Experience with HealthRules Payer (HRP) or similar platforms.
- Medicare and/or Medicaid program experience, including CMS data structures and compliance requirements.
- Experience with EDI transaction processing — 837P, 837I (claims), and 834 (enrollment).
- Experience with ETL tools such as Informatica, Talend, or equivalent platforms.
- Experience with BI or reporting tools such as MicroStrategy, Power BI, or equivalent.
- Cloud platform exposure — AWS, Azure, or GCP; Architect or Big Data certification.
- Knowledge of data visualization tools and dashboard design.
- Familiarity with backup, archival, and data recovery specifications.
Responsibilities
- Lead and manage end-to-end data conversion of healthcare payer data between platforms.
- Serve as subject matter expert for payer data domains — Claims, Enrollment, Provider, and Authorizations.
- Analyze healthcare payer data patterns, perform data profiling, and define transformation and mapping rules.
- Design and execute a phased conversion plan covering mock runs, parallel runs, and full-volume loads.
- Lead workflow and gap analysis sessions; identify data discrepancies and define resolution strategies.
- Write, maintain, and unit-test data conversion code (Python, SQL).
- Design ETL processes including data extracts, load logic, stored procedures, workflows, and data mappings.
- Enforce naming standards and maintain data dictionaries and documentation for all conversion data models.
- Handle post-installation testing; identify and correct any conversion defects prior to go-live.
- Plan and conduct client and user review sessions on conversion results; implement corrections based on feedback.
- Maintain consistent communication with the client on conversion progress, risks, and issue resolution.
- Develop comprehensive documentation for all data conversions.
- Collaborate with project managers, business teams, and cross-functional stakeholders across onshore and offshore teams.
- Mentor and guide junior team members on conversion processes, best practices, and technical standards.
- Develop and contribute to reusable conversion assets, accelerators, and knowledge repositories.
Benefits
- Health insurance
- Dental insurance
- Vision insurance
- Life insurance
- 401k
- Paid holidays
- Paid volunteer time
- Professional development
- Learning and development program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
