Data Warehouse Migration Engineer: Sql Server To Aws & Ssis

Opsbrasil Serviços Cloud Ltda; Ciudad de Mendoza; On-site; ARS 90,873,000 - 136,310,000; Full time

Job summary

Opsbrasil Serviços Cloud Ltda. is seeking a RIS Data Migration Engineer to lead data migration from legacy RIS systems to modern platforms. You will work with IT, clinical, and admin teams to ensure data integrity, privacy, and regulatory compliance.

Responsibilities include extracting data from RIS/PACS/HIS/EMR, mapping legacy structures, and using ETL tools to prepare data for migration. You will document processes and train staff for the new RIS system.

Qualifications

• Bachelor's degree or equivalent experience in IT or healthcare informatics.
• 3+ years of data migration experience in a healthcare environment.
• Hands-on with RIS, PACS, HIS, and EMR data migration.
• Proficient SQL and healthcare data standards.
• C# or Python for in-house migration tooling; Linux scripting.
• HL7 and Mirth knowledge; strong communication and problem-solving.

Responsibilities

• Develop and execute strategies for RIS data migration.
• Extract and map legacy data structures (demographics, reports, scans).
• Use ETL to clean, transform, and prepare data for migration.
• Collaborate with IT, clinical, and admin teams across stakeholders.
• Validate data completeness and resolve inconsistencies post-migration.
• Document methodologies, tools, and reports; train staff on new RIS.
• Provide post-migration support and assist go-live implementations.

Skills

SQL

ETL

C#

Python

HL7

Mirth

Windows desktop

Linux scripting

data migration

data privacy & security

Education

Bachelor's degree in IT/healthcare informatics, or related field

Tools

MS SQL Server

ETL tools

RIS/PACS/HIS/EMR systems

Job description

The Role

The RIS Data Migration Engineer is responsible for overseeing and executing the migration of data between Radiology Information Systems (RIS), ensuring data integrity, accuracy, and compliance with regulatory standards. The Data Migration Engineer will work closely with IT, clinical, and administrative teams to ensure seamless transitions of data from legacy systems to modern platforms, while optimizing workflows and maintaining the highest standards of patient data privacy and security.

Responsibilities

• Develop and execute comprehensive strategies for RIS data migration.
• Collaborate with stakeholders to gather and analyze migration requirements.
• Extract clinical, operational, and administrative data from legacy RIS systems.
• Assess and map legacy data structures, including patient demographic records, diagnostic radiology reports, scanned documents, and future appointments.
• Assist in assembling and loading RIS system's master lists including referring physicians, insurance providers, procedure codes, billing codes, organizational structures such as practices, sites, and rooms, and other master look-up tables.
• Use ETL tools to clean, transform, and prepare data for migration.
• Provide post-migration support for product go-live implementations.
• Partner with cross-functional teams, including customers, IT staff, compliance officers, and third-party vendors.
• Document the entire migration process, including methodologies, tools, and reports.
• Train staff on how to manage, access, and use data in the new RIS system.
• Perform comprehensive validation to ensure data completeness and resolve inconsistencies.
• Conduct post-migration verification and prepare detailed reports for stakeholders.
• Identify and resolve migration-related issues, such as data inconsistencies or system compatibility challenges.

Requirements

• Bachelor's degree in information technology, computer science, healthcare informatics, or related field; or equivalent professional experience
• 3+ years proven experience in data migration within a healthcare environment
• Hands-on experience with data manipulation and/or migration within RIS, PACS, HIS, and EMR systems.
• Proficiency in ETL processes, database structures, SQL, and healthcare data standards.
• Proficient SQL skills and experience with database management. Proprietary software product is supported by MS SQL Server. Proficiency with Transact SQL, triggers, functions, stored procedures, database schema design, SQL agent jobs, and ad hoc querying.
• Using skills above, work with various formats of data such as CSV and other delimited text files, Excel data, SQL databases, Word docs, BMP/JPG files, PDF files. Ad hoc manipulation such as converting one format to another, rename files, move files, parse files, clean data.
• Excellent technical communication and interpersonal skills, with the ability to effectively communicate with stakeholders at all levels of the organization
• Strong problem-solving and troubleshooting abilities
• Ability to adapt to constantly changing projects. This role requires a high level of self-motivation, self-management, initiative, and the ability to prioritize multiple tasks effectively. Occasional off-hours work is required to migrate during off-peak system times.
• Attention to detail with a commitment to data accuracy and security. Comfort and willingness to handle and analyze and scrutinize large medical record datasets is a critical aspect of the job to maintain high data quality standards
• Proficiency in C# for Windows desktop programming or Python, or similar programming languages to enhance in-house data migration tools.
• Familiarity with Linux OS and scripting (Python, Pearl, VIM, BASH) to assist with ancillary data migrations taking place in Linux environments.
• Mirth skills, particularly with HL7

Quality Standards

• Communicates, cooperates, and consistently functions professionally and harmoniously with all levels of supervision, co-workers, patients, visitors, and vendors.
• Demonstrates initiative, personal awareness, professionalism and integrity, and exercises confidentiality in all areas of performance.
• Follows all local, state and federal laws concerning employment to include but not limited to: I-9, Harassment, EEOC, Civil rights and ADA.
• Follows OSHA regulations, RadNet and site protocols, policies and procedures.
• Follows HIPAA, compliance, privacy, safety and confidentiality standards at all times.
• Practices universal safety precautions.
• Promotes good public relations on the phone and in person.
• Adapts and is willing to learn new tasks, methods, and systems.
• Reports to work regularly as scheduled; consistently punctual with respect to working hours, meal and rest breaks, and maintains satisfactory personal attendance in accordance with RadNet guidelines.
• Consistently adheres to the time management policies and procedures.
• Completes job responsibilities in a quality and timely manner.