Data Migration Engineer

Accountabilities:

• Develop and execute end-to-end data migration strategies for Radiology Information Systems (RIS), ensuring secure and accurate transfers from legacy platforms to modern solutions.
• Collaborate with customers, IT teams, clinical and administrative stakeholders, compliance officers, and third-party vendors to gather requirements and coordinate migration activities.
• Extract, assess, map, clean, transform, and prepare clinical, operational, and administrative data from legacy systems, including patient demographics, radiology reports, scanned documents, and future appointments.
• Build and maintain RIS master lists and reference tables, including referring physicians, insurance providers, procedure and billing codes, organizational structures, practices, sites, and rooms.
• Use ETL tools, SQL queries, and database management techniques to process data and resolve inconsistencies across different formats and systems.
• Work with MS SQL Server databases, including database schemas, triggers, functions, stored procedures, SQL Agent jobs, and ad hoc queries.
• Manipulate and convert data across formats such as CSV, Excel, SQL databases, Word documents, images, and PDFs, including parsing, renaming, moving, and cleaning files as required.
• Perform comprehensive data validation and post-migration verification to confirm data completeness, accuracy, consistency, and integrity.
• Troubleshoot migration issues, investigate system compatibility challenges, and implement corrective actions to maintain high data quality standards.
• Provide post-migration and go-live support, prepare detailed migration documentation and reports, and communicate progress and outcomes to stakeholders.
• Train staff on accessing, managing, and using migrated data within the new RIS platform.
• Support ancillary migrations in Linux environments and enhance internal migration tools using appropriate programming languages and scripting techniques.
• Follow applicable healthcare privacy, confidentiality, security, safety, and compliance requirements throughout all migration activities.

Requirements:

• Bachelor's degree in Information Technology, Computer Science, Healthcare Informatics, or a related field, or equivalent professional experience.
• At least 3 years of proven data migration experience within a healthcare environment.
• Hands-on experience manipulating or migrating data across healthcare systems such as RIS, PACS, HIS, and EMR platforms.
• Strong understanding of ETL processes, relational database structures, SQL, and relevant healthcare data standards.
• Proficiency in MS SQL Server and Transact-SQL, including triggers, functions, stored procedures, database schema design, SQL Agent jobs, and ad hoc querying.
• Experience working with diverse data formats, including delimited text files, spreadsheets, SQL databases, Word documents, image files, and PDFs.
• Programming experience in C# for Windows desktop applications, Python, or a comparable language to develop or improve data migration tools.
• Familiarity with Linux operating systems and scripting tools or languages such as Python, Perl, Vim, and Bash.
• Experience with Mirth Connect, particularly HL7, is required.
• Strong analytical, troubleshooting, and problem-solving skills, with the ability to inspect large medical record datasets and identify data quality issues.
• Excellent technical communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at different organizational levels.
• Exceptional attention to detail and a strong commitment to data accuracy, patient privacy, security, and confidentiality.
• Ability to adapt to changing project requirements, manage competing priorities, work independently, and demonstrate initiative and sound time management.
• Willingness to work occasional off-hours to perform migrations during periods of lower system activity.
• Professionalism, integrity, reliability, and a commitment to following applicable healthcare regulations, workplace safety requirements, and organizational policies.

Benefits:

• Fully remote work arrangement.
• Full-time employment opportunity.
• Opportunity to contribute to healthcare technology modernization and the secure migration of critical medical data.
• Professional exposure to healthcare information systems, database technologies, ETL processes, and data migration projects.
• Salary, healthcare coverage, paid leave, equipment provisions, and other specific benefits are not detailed in the source job description.