Technical SME/ Architect

About Apexon:

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation. Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

We enable #HumanFirstDIGITAL

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

Our Commitment to Diversity & Inclusion:

Did you know that Apexon has been Certified by Great Place To Work , the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy ()