Data Conversion Lead

About the role

We can only consider US Citizens or Green Card holders for this position at this time. 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.

Responsibilities

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