Data Migration Engineer

<h3>Accountabilities:</h3><ul>
<li>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.</li>
<li>Collaborate with customers, IT teams, clinical and administrative stakeholders, compliance officers, and third-party vendors to gather requirements and coordinate migration activities.</li>
<li>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.</li>
<li>Build and maintain RIS master lists and reference tables, including referring physicians, insurance providers, procedure and billing codes, organizational structures, practices, sites, and rooms.</li>
<li>Use ETL tools, SQL queries, and database management techniques to process data and resolve inconsistencies across different formats and systems.</li>
<li>Work with MS SQL Server databases, including database schemas, triggers, functions, stored procedures, SQL Agent jobs, and ad hoc queries.</li>
<li>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.</li>
<li>Perform comprehensive data validation and post-migration verification to confirm data completeness, accuracy, consistency, and integrity.</li>
<li>Troubleshoot migration issues, investigate system compatibility challenges, and implement corrective actions to maintain high data quality standards.</li>
<li>Provide post-migration and go-live support, prepare detailed migration documentation and reports, and communicate progress and outcomes to stakeholders.</li>
<li>Train staff on accessing, managing, and using migrated data within the new RIS platform.</li>
<li>Support ancillary migrations in Linux environments and enhance internal migration tools using appropriate programming languages and scripting techniques.</li>
<li>Follow applicable healthcare privacy, confidentiality, security, safety, and compliance requirements throughout all migration activities.</li>
<h2>Requirements:</h2>
<ul>
<li>Bachelor's degree in Information Technology, Computer Science, Healthcare Informatics, or a related field, or equivalent professional experience.</li>
<li>At least 3 years of proven data migration experience within a healthcare environment.</li>
<li>Hands-on experience manipulating or migrating data across healthcare systems such as RIS, PACS, HIS, and EMR platforms.</li>
<li>Strong understanding of ETL processes, relational database structures, SQL, and relevant healthcare data standards.</li>
<li>Proficiency in MS SQL Server and Transact-SQL, including triggers, functions, stored procedures, database schema design, SQL Agent jobs, and ad hoc querying.</li>
<li>Experience working with diverse data formats, including delimited text files, spreadsheets, SQL databases, Word documents, image files, and PDFs.</li>
<li>Programming experience in C# for Windows desktop applications, Python, or a comparable language to develop or improve data migration tools.</li>
<li>Familiarity with Linux operating systems and scripting tools or languages such as Python, Perl, Vim, and Bash.</li>
<li>Experience with Mirth Connect, particularly HL7, is required.</li>
<li>Strong analytical, troubleshooting, and problem-solving skills, with the ability to inspect large medical record datasets and identify data quality issues.</li>
<li>Excellent technical communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at different organizational levels.</li>
<li>Exceptional attention to detail and a strong commitment to data accuracy, patient privacy, security, and confidentiality.</li>
<li>Ability to adapt to changing project requirements, manage competing priorities, work independently, and demonstrate initiative and sound time management.</li>
<li>Willingness to work occasional off-hours to perform migrations during periods of lower system activity.</li>
<li>Professionalism, integrity, reliability, and a commitment to following applicable healthcare regulations, workplace safety requirements, and organizational policies.</li>
<h2>Benefits:</h2>
<ul>
<li>Fully remote work arrangement.</li>
<li>Full-time employment opportunity.</li>
<li>Opportunity to contribute to healthcare technology modernization and the secure migration of critical medical data.</li>
<li>Professional exposure to healthcare information systems, database technologies, ETL processes, and data migration projects.</li>
<li>Salary, healthcare coverage, paid leave, equipment provisions, and other specific benefits are not detailed in the source job description.</li>
</ul>
</ul>
</ul>