Migration Specialist - EHR Implementation
Location: Dublin or Kilkenny (Hybrid)
Job type: Fixed Term
Overview of role:
The Migration Specialist will play a critical role in the extraction, transformation, validation, and loading of data from legacy systems into the Meditech Expanse Electronic Health Record (EHR) platform. The role focuses on ensuring data quality, integrity, and completeness across all migration cycles, supporting safe clinical operations and regulatory compliance during and after go-live. The successful candidate will demonstrate strong analytical skills, attention to detail, and the ability to work with structured datasets. They will have experience in developing and working with data scripts (e.g. SQL, Python) to support transformation, and validation activities. In addition, they will possess strong communication skills and the ability to collaborate effectively with both technical and non-technical stakeholders to support data migration delivery across diverse systems and environments. The role offers the opportunity to play a key part in delivering transformative EHR capabi
Primary Duties and Responsibilities:
Data Migration Delivery
-
Support end-to-end data migration activities including data profiling, mapping, cleansing, transformation, and loading
-
Execute data extraction from legacy clinical and administrative systems
-
Develop and maintain data transformation logic in line with Meditech Expanse data structures
-
Load data into target systems and validate successful migration outcomes
- Document data structures, extract logic, and source-to-target dependencies, test results and defect resolution
Data Analysis & Mapping
-
Analyse source system data structures and assess data quality issues
-
Create detailed data mapping documents between legacy systems and Meditech Expanse
-
Collaborate with clinical and operational stakeholders to define data migration scope and prioritisation
-
Ensure alignment with agreed data migration strategy and data sets (e.g., demographics, encounters, results, medications)
Data Quality & Governance
-
Ensure compliance with data governance, data protection (GDPR), and healthcare regulatory requirements
-
Maintain audit trails and documentation for migration activities
-
Support adherence to data governance, security policies, and Data Protection requirements.
-
Data Transformation & Migration Support
-
Assist in developing, executing and maintaining transformation scripts (e.g. SQL, Python) to convert source data into required target formats.
Apply mapping rules and support handling of dictionary and mnemonic dependencies.
-
Testing & Validation
-
Run validation scripts to support reconciliation and data quality checks between source and target datasets, ensuring data accuracy and integrity.
-
Support testing activities including System Integration Testing (SIT), User Acceptance Testing (UAT), and dress rehearsals.
Identify, log, track, and support resolution of data defects and issues.
-
Stakeholder Collaboration
-
Support workshops and information-gathering sessions across business, clinical and technical stakeholders.
-
Communicate data findings, issues, and updates clearly to both technical and non-technical audiences.
-
Participate in team meetings, workshops, and programme review sessions.
Go-Live & Hypercare Support
-
Support cutover planning and execution for final data migration cycles
-
Participate in go-live activities and post-implementation support
-
Troubleshoot data-related issues during hypercare
Qualifications & Experience:
Essential
-
Diploma or degree in a relevant field (e.g. Computer Science, Information Systems, Data Analytics, Mathematics) or equivalent practical experience.
-
Strong SQL and data manipulation skills using ETL processes, tools, or scripting
-
Understanding of data handling concepts, including data quality, validation, and reconciliation.
-
Experience performing data mapping, transformation, and reconciliation
Experience working with multiple data sources (databases, flat files, legacy systems)
-
Desirable
-
Proven experience in data migration within large-scale IT or EHR implementation programmes
- Knowledge of healthcare data domains (patient demographics, clinical data, orders, results)
-
Understanding of data governance and regulatory frameworks
-
Strong organisational skills with the ability to manage multiple tasks and meet deadlines.
-
Good communication skills, with the ability to clearly present findings to both technical and non-technical stakeholders.
-
Proficiency in Microsoft Office suite (Excel, Word, PowerPoint, Visio, MS Project)
This job description is intended to be an outline of the areas of responsibility. As UPMC and the post holder develop, this job description may be subject to review in light of the changing needs of the business.
Equal Opportunity Statement and Benefits
UPMC is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
At UPMC we provide a total rewards program that is not only market competitive, but fair and provides growth opportunities for all our colleagues.
Benefits – Fully paid maternity and paternity leave for new parents. Competitive Pension Plan, company funded Death in Service Benefit x 3 times. Critical Illness cover for all employees up to the age of 66.
Performance and Recognition – Rewards for performance that supports the goals and mission of UPMC through our annual ACES programme.
Work-Life Balance – Enhanced annual leave up to a maximum of 27 days. Flexible working opportunities to support you to work around external family commitments.
Development and Career Opportunities – Opportunities for each employee to reach their career goals through continued learning and/or advancement.
About UPMC
UPMC is a renowned multinational academic medical centre committed to delivering people-focused care that’s close to home. Headquartered in Pittsburgh and affiliated with the University of Pittsburgh Schools of the Health Sciences, UPMC shapes the future of health through clinical and technological innovation, research and education. UPMC expands its expertise globally, bringing world-class care across continents through its UPMC International division — an owned and operated network of hospitals and ambulatory care centres in Italy, Ireland and Croatia. UPMC International brings new access to the signature specialty services of UPMC Hillman Cancer Centre, UPMC Sports Medicine and others to more people in more places around the world.
In Ireland UPMC has provided high-quality healthcare in the South East since 2006. UPMC’s operations in Ireland now include UPMC Whitfield Hospital in Waterford, UPMC Sports Surgery Clinic in Dublin, UPMC Kildare Hospital in Clane, and UPMC Aut Even Hospital in Kilkenny. Outpatient care is available at the UPMC Carlow Outreach Centre, UPMC Hillman Cancer Centre radiotherapy locations in Waterford and Cork, UPMC The 4th Practice in Mallow, and across UPMC Sports Medicine Clinics in Dublin, Waterford, Limerick, Tipperary, Cork, and Mayo. UPMC has also established a nationwide Concussion Network. UPMC's Global Technology Operation Centre is based in Kilkenny.
