Technical Architect

Technical Architect

Princeton, NJ (Onsite)

Contract

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).