A

Senior Data Migration Specialist - Healthcare EHR Project

ai talent • Australia
Visa Sponsorship
Apply
AI Summary

Lead complex data migration from legacy systems to new EHR platform. Define ETL strategy, ensure data quality, and maintain compliance. Collaborate with stakeholders and optimize processes.

Key Highlights
Define and execute ETL strategy for high-volume, sensitive data migration
Ensure data quality and compliance with healthcare regulations
Collaborate with technical architects, clinical stakeholders, and compliance officers
Key Responsibilities
Design, develop, and execute complex ETL scripts and programmes using tools like SQL Server Integration Services (SSIS), Informatica, or Python
Define and document detailed data mapping and transformation rules
Lead data cleansing and validation efforts before, during, and after migration loads
Collaborate closely with technical architects, clinical stakeholders, and compliance officers to define the scope and schedule of migration phases
Optimise SQL queries, ETL processes, and database performance
Develop and maintain automated reconciliation reports and audit trails
Proactively troubleshoot and resolve complex data discrepancies and technical issues
Technical Skills Required
SQL ETL Tools (SSIS, Informatica, Python) Data Migration
Benefits & Perks
482 visa sponsorship

Job Description


We're partnering with a vital leader in the Healthcare sector, dedicated to modernising their systems by migrating critical patient and operational data onto a new Electronic Health Record (EHR) platform. For the right candidate with the necessary skills and experience, we are pleased to offer 482 visa sponsorship.

This client requires a Data Migration Specialist to lead the technical aspects of moving high-volume, sensitive data from legacy systems. You will be instrumental in defining the extraction, transformation, and loading (ETL) strategy, ensuring data quality, mapping complex schemas, and maintaining strict compliance with healthcare regulations. This role demands meticulous attention to detail and expertise in managing data integrity throughout the migration lifecycle.


What You'll Do
  • Design, develop, and execute complex ETL scripts and programmes using tools like SQL Server Integration Services (SSIS), Informatica, or Python to extract data from various source systems and transform it to meet the target system's schema.
  • Define and document detailed data mapping and transformation rules, ensuring consistency and integrity for sensitive information (e.g., patient records, clinical codes, billing data).
  • Lead data cleansing and validation efforts before, during, and after migration loads, ensuring a high level of data quality and compliance.
  • Collaborate closely with technical architects, clinical stakeholders, and compliance officers to define the scope and schedule of migration phases.
  • Optimise SQL queries, ETL processes, and database performance to handle large volumes of historical data within tight migration windows.
  • Develop and maintain automated reconciliation reports and audit trails to verify the successful and accurate transfer of all required data for regulatory practises.
  • Proactively troubleshoot and resolve complex data discrepancies and technical issues that arise during trial and production loads.


What You'll Bring
  • 5+ years of professional experience in a dedicated Data Migration, ETL Development, or Data Warehousing role.
  • Expert-level proficiency in SQL for complex querying, stored procedures, and performance tuning.
  • Proven, hands-on experience with a major ETL toolset (e.g., SSIS, Informatica, Talend, or specialised migration tools).
  • Strong understanding of database architecture, schema design, and data modelling principles.
  • Meticulous attention to detail with proven ability to manage data quality and optimise data sets.
  • Familiarity with data governance, security, and compliance requirements (e.g., healthcare data standards) is highly desirable.
  • Excellent analytical and communication skills, with the ability to clearly document complex mapping and migration processes.



Similar Jobs

Explore other opportunities that match your interests

Senior Backend Developer

Programming
•
1d ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

cloud raptor

Australia
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

coreflow

Australia
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

coreflow

Australia

Subscribe our newsletter

New Things Will Always Update Regularly