Meditech Data Migration Architect
Spectraforce
Waynesburg, Pennsylvania
Remote
a month ago
Job Description
Job title-: Meditech Data Migration Architect
Location: Remote
Duration-: 7 months
Overview:
We are seeking a highly experienced Technical SME/ Architect to lead the design and development of a robust, scalable solution for extracting legacy MEDITECH data and loading it into SQL Server. This role will also define the roadmap for building a homegrown archival application to support multiple healthcare platforms, leveraging InterSystems IRIS for Health as a core technology. The ideal candidate will have experience with MEDITECH hospital application systems, both end-user workflow and backend configuration/ support, familiar with medical terminology and clinical workflows.
Key Responsibilities:
Short-Term Objectives:
• Design and build tools to automate downloads of legacy MEDITECH data and load into SQL Server.
• Establish table/ field relationships and compare data across environments.
• Validate data loads (record counts, totals, etc.) to ensure accuracy and completeness.
• Handle unstructured data (external attachments, images, PDFs, etc.) linked to patient encounters.
Challenges to Address:
• Lack of clear schema and table definitions from previous archival efforts.
• Missing key relationships and constraints in current SQL Server tables.
• Manual data mapping and reporting due to poor data structure.
• Dependency on third-party vendors for legacy data knowledge.
Required Qualifications:
• Extensive experience and understanding of MEDITECH hospital application systems from both an end-user and backend configuration/support perspective.
• Strong experience in building and customizing MEDITECH modules, including:
o Administrative: ADM, ABS, MIS, DR, MRI, SCA, EPS
o Clinical: OE/POM/OM, PCI/PCS/NUR, PCM, EDM, LAB, PHA, RAD, ORM/MSMSURG
• Deep understanding of MEDITECH Data Model and MUMPS architecture.
• Experience with hierarchical databases (HDBMS) and relational databases (RDBMS).
• Proficiency in InterSystems IRIS, including Caché and IRIS versions.
• Expertise in handling global arrays and hierarchical key-value structures.
• Familiarity with MUMPS file types: Global Storage, Global Array, SQLite/ Embedded, Source/ Config, Backup/ Journal, InterSystems Cache/ IRIS.
• Strong SQL Server skills for data loading, validation, and schema design.
• Experience with healthcare data identification, schema/ field-level data mapping, transformation, and compliance.
Job Duties:
• Ensure ≥ 99% accuracy in extracting legacy data from MEDITECH MUMPS systems.
• Validate data loads with ≥ 99% match in record counts and financial totals across environments.
• Deliver a functional prototype of the archival application.
• Development of the automation tool to support data unload/ load workflows.
• Schema mapping of unknown MEDITECH tables and structures.
• Reduce manual data mapping effort through automation and tool development.
• Integrate the archival solution with various healthcare platforms, ensuring cross-system compatibility.
• Produce technical documentation covering workflows, schema mappings, and validation processes.
Data Investigation & Mapping Responsibilities:
• Identify and verify missing data elements in MEDITECH tables and columns.
• Determine root causes for missing data and provide retrieval options.
• Assist in locating and identifying data elements that are not actually missing.
• Provide guidance on understanding data structure relationships.
• Support SQL logic development to retrieve complex data elements accurately.
Project Governance & Engagement:
• Remotely attend all scheduled project status calls.
• Participate in working sessions to identify and remediate data discrepancies.
• Collaborate with cross-functional teams to ensure project alignment and success.
Preferred Skills:
• Familiarity with HL7, FHIR, and other healthcare interoperability standards.
• Experience with Power BI, Tableau, and jReports (nice to have).
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 95.00/hr.
Location: Remote
Duration-: 7 months
Overview:
We are seeking a highly experienced Technical SME/ Architect to lead the design and development of a robust, scalable solution for extracting legacy MEDITECH data and loading it into SQL Server. This role will also define the roadmap for building a homegrown archival application to support multiple healthcare platforms, leveraging InterSystems IRIS for Health as a core technology. The ideal candidate will have experience with MEDITECH hospital application systems, both end-user workflow and backend configuration/ support, familiar with medical terminology and clinical workflows.
Key Responsibilities:
Short-Term Objectives:
• Design and build tools to automate downloads of legacy MEDITECH data and load into SQL Server.
• Establish table/ field relationships and compare data across environments.
• Validate data loads (record counts, totals, etc.) to ensure accuracy and completeness.
• Handle unstructured data (external attachments, images, PDFs, etc.) linked to patient encounters.
Challenges to Address:
• Lack of clear schema and table definitions from previous archival efforts.
• Missing key relationships and constraints in current SQL Server tables.
• Manual data mapping and reporting due to poor data structure.
• Dependency on third-party vendors for legacy data knowledge.
Required Qualifications:
• Extensive experience and understanding of MEDITECH hospital application systems from both an end-user and backend configuration/support perspective.
• Strong experience in building and customizing MEDITECH modules, including:
o Administrative: ADM, ABS, MIS, DR, MRI, SCA, EPS
o Clinical: OE/POM/OM, PCI/PCS/NUR, PCM, EDM, LAB, PHA, RAD, ORM/MSMSURG
• Deep understanding of MEDITECH Data Model and MUMPS architecture.
• Experience with hierarchical databases (HDBMS) and relational databases (RDBMS).
• Proficiency in InterSystems IRIS, including Caché and IRIS versions.
• Expertise in handling global arrays and hierarchical key-value structures.
• Familiarity with MUMPS file types: Global Storage, Global Array, SQLite/ Embedded, Source/ Config, Backup/ Journal, InterSystems Cache/ IRIS.
• Strong SQL Server skills for data loading, validation, and schema design.
• Experience with healthcare data identification, schema/ field-level data mapping, transformation, and compliance.
Job Duties:
• Ensure ≥ 99% accuracy in extracting legacy data from MEDITECH MUMPS systems.
• Validate data loads with ≥ 99% match in record counts and financial totals across environments.
• Deliver a functional prototype of the archival application.
• Development of the automation tool to support data unload/ load workflows.
• Schema mapping of unknown MEDITECH tables and structures.
• Reduce manual data mapping effort through automation and tool development.
• Integrate the archival solution with various healthcare platforms, ensuring cross-system compatibility.
• Produce technical documentation covering workflows, schema mappings, and validation processes.
Data Investigation & Mapping Responsibilities:
• Identify and verify missing data elements in MEDITECH tables and columns.
• Determine root causes for missing data and provide retrieval options.
• Assist in locating and identifying data elements that are not actually missing.
• Provide guidance on understanding data structure relationships.
• Support SQL logic development to retrieve complex data elements accurately.
Project Governance & Engagement:
• Remotely attend all scheduled project status calls.
• Participate in working sessions to identify and remediate data discrepancies.
• Collaborate with cross-functional teams to ensure project alignment and success.
Preferred Skills:
• Familiarity with HL7, FHIR, and other healthcare interoperability standards.
• Experience with Power BI, Tableau, and jReports (nice to have).
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 95.00/hr.