Cynet systems Inc
Job Description
Pay Range: $95hr - $100hr
Key Responsibilities Short-Term Objectives:
Design and build tools to automate downloads of legacy MEDITECH data and load into SQL Server.
Establish table and field relationships and compare data across environments.
Validate data loads (record counts, totals, etc.) to ensure accuracy and completeness.
Handle unstructured data such as external attachments, images, and PDFs 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 Administrative: ADM, ABS, MIS, DR, MRI, SCA, EPS; 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 Cache and IRIS versions.
Expertise in handling global arrays and hierarchical key-value structures.
Familiarity with MUMPS file types such as Global Storage, Global Array, SQLite/Embedded, Source/Config, Backup/Journal, and InterSystems Cache/IRIS.
Strong SQL Server skills for data loading, validation, and schema design.
Experience with healthcare data identification, schema and field-level data mapping, transformation, and compliance.
Job Duties
Ensure at least 99% accuracy in extracting legacy data from MEDITECH MUMPS systems.
Validate data loads with at least 99% match in record counts and financial totals across environments.
Deliver a functional prototype of the archival application.
Develop automation tools to support data unload/load workflows.
Perform 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 to ensure cross-system compatibility.
Produce technical documentation covering workflows, schema mappings, and validation processes.
Data Investigation And 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 And 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.
#J-18808-Ljbffr
Key Responsibilities Short-Term Objectives:
Design and build tools to automate downloads of legacy MEDITECH data and load into SQL Server.
Establish table and field relationships and compare data across environments.
Validate data loads (record counts, totals, etc.) to ensure accuracy and completeness.
Handle unstructured data such as external attachments, images, and PDFs 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 Administrative: ADM, ABS, MIS, DR, MRI, SCA, EPS; 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 Cache and IRIS versions.
Expertise in handling global arrays and hierarchical key-value structures.
Familiarity with MUMPS file types such as Global Storage, Global Array, SQLite/Embedded, Source/Config, Backup/Journal, and InterSystems Cache/IRIS.
Strong SQL Server skills for data loading, validation, and schema design.
Experience with healthcare data identification, schema and field-level data mapping, transformation, and compliance.
Job Duties
Ensure at least 99% accuracy in extracting legacy data from MEDITECH MUMPS systems.
Validate data loads with at least 99% match in record counts and financial totals across environments.
Deliver a functional prototype of the archival application.
Develop automation tools to support data unload/load workflows.
Perform 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 to ensure cross-system compatibility.
Produce technical documentation covering workflows, schema mappings, and validation processes.
Data Investigation And 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 And 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.
#J-18808-Ljbffr