DESCRIPTION: Working under general supervision of the Lead Programmer, Manager of HIE, or the Director: develops, tests, implements, and supports clinical and administrative data interfaces and applications between Epic and ancillary systems, both internal and external, and between Trusting Data Sharing Organizations (TDSO) and external entities. The Programmer II is part of a team that is accountable for production support (including on-call duties in a 24X7 environment) as well as new projects to improve integration between Epic and other systems, and between TDSOs and external entities. Under the general supervision of the Lead Programmer, HIE Manager, or the Portfolio Director: responsible for working with internal and external customers to design, develop, implement, document and support all aspects of advanced and distributed computer systems including new features and related products. Performs database and application support, maintenance, testing, installation, training, documentation and coordination of system related activities. Strive for continuous quality improvement in attempts to exceed customer expectations. The Programmer II is a member in an IT team that is accountable for production support (including on-call duties in a 24x7 environment) as well as new projects. The ideal candidate will have experience using technical analytical skills to seek out, research and evaluate a variety of solutions to provide clients with high quality, efficient workflows and data that promote efficiency and enterprise-wide standardization. The ideal candidate will also understand design and development principles as they relate to interfaces, data, and applications; and may include but are not limited to: data flow diagrams, data element dictionaries, file mappings, field layouts and command level operations. He or she will also possess Epic Bridges 2012 certification (or higher), Interface (Mirth or Cloverleaf) Certification, Mirth Connect version 3.0 or higher experience (including JavaScript usage), preferably in an Azure environment. PRINCIPLE DUTIES AND RESPONSIBILITIES:
- Lead the configuration effort of new interfaces, applications, and enhancements to existing interfaces for Epic applications and their corresponding ancillary systems.
- Troubleshoot technical problems and conducts analyses for efficient program/application solutions (in Mirth, and Epic Bridges) which support client business processes, functional and technical requirements, and external services.
- Assists with activities to monitor and maintain a complex interface environment for efficient program/application operations (including functional and technical system balancing efforts)
- Coordinate solutions and planning with other IT teams. Collaborate with Application Analysts, IT, Operational areas, and TSDOs to identify and resolve workflow impacts.
- Direct and plan relevant workflow/dataflow sessions and manage resulting requirements changes with senior business sponsors.
- Collaborate with work teams, departments, system leadership, clinicians, staff, other IT groups, TSDOs, and technology vendors to define needs and facilitate solutions.
- Provides input to estimate work effort and resource requirements for SOWs.
- Manages simple to medium integration issues and critical support/enhancements issues in multiple systems.
- Performs maintenance (routine requests), incidents resolution, testing activities and assists teammates.
- Works closely with Ancillary Departments, HELIOS Application Analysts, Operations, Epic, TDSOs, other technology vendors, external entities, and other IT groups to triage, diagnosis and resolve all interface production support issues to the satisfaction of our customers.
- Possesses detailed technical knowledge of software development lifecycle (SDLC) and release management.
- Responsible for technical data conversion design and development, conversion strategy support, and delivering to established timelines.
- Serves as technical analyst responsible for the design and implementation of conversion activities with client engagements.
- Assist in the definition of systems and data solutions to functional problems, conforming to established system architecture standards and practices.
- Provide assistance to Data Conversion team members as necessary.
- Coordinates release program activities.
- Acts as a gatekeeper to the production environment, ensuring consistency in policies and operational procedures, release integration testing and production validation.
- Expert understanding of population health concepts to help facilitate maintaining patient identity management in the construction and maintenance of various ADT, Order and Result, and document interfaces. Assisting the CIN and SIM as needed.
- Responsible for converting data from multiple data sources including text files, HL7, ODBC and non-ODBC compliant data base files. Other data sources may include proprietary formats, MS Excel and MS Access.
- Uses all available vendor- based software applications and tools to complete data processing and conversion jobs in a timely and accurate manner.
- Create detailed mapping between old data elements and new data elements.
- Create mapping to allow filtering within the interfaces.
- Identify problems and make recommendations on how to overcome any issue.
- Assumes responsibility for conversion and interface related support calls from all business owners and TSDOs.
- Continues to refine conversion utilities and programs as required by business owners, teams, and TSDOs.
- Develop standardized procedures for common conversion routines to increase efficiencies.
- Develop/maintain utility programs/scripts to automate common pre/post conversion tasks.
EDUCATION/EXPERIENCE REQUIRED:
- Bachelor's degree required or five years of applicable work experience in lieu of a degree.
- Three (3) years of applicable work experience required;
- Two (2) years applicable experience in a Healthcare setting preferred.
- Three (3) years of experience working with Epic highly preferred.
- Three (3) years of experience working with the combination of data conversion interfaces and application interfaces highly preferred.
- Preferred technical experience includes strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging problems, and ongoing technical support, and ability to articulate examples of workflows and processes associated with that experience.
- Expertise with healthcare industry standard messaging formats (e.g., HL7, XML, JSON, ANSI x12)
- Experience with at least two (2) years programming JavaScript.
- Experience with at least two (2) years programming java preferred.
- Experience/exposure to the System Development Life Cycle (SDLC)
- Experience on at least two (2) major system implementations
- Excellent communication and interpersonal skills
- Demonstrated working knowledge of medical terminology
- Ability to translate complex business requirements into technical solutions.
- At least five (5) years working with databases, three (3) years of which should have involved MS-SQL.
- At least three (3) years of experience in SQL Server T-SQL database development (data modeling, stored procedures, functions and query optimization).
- Expert Knowledge in ETL tools, SQL query tools and Transact SQL (SQL Server v2005-2008), at least three (3) years of experience in SSIS and ETL development.
- Expertise in converting data from multiple data sources including text files, ODBC and non-ODBC compliant data base files, and HL7. Other data sources may include proprietary formats, MS Excel and MS Access.
- Excellent troubleshooting skills.
- Ability to create complex, high performance stored procedures in SQL Server 2008 or higher.
- Good understanding of HIPAA data Privacy and Security requirements.
- Ability to be flexible and work analytically in a problem-solving environment. Good organizational, multi-tasking, and time-management skills.
- Proven ability to work independently and as a team member
CERTIFICATIONS/LICENSURES REQUIRED:
- Current Certification on Epic Bridges (May hire into position without certification, but must attain certification within the first 6 months of hire to continue employment)
- Certification on an interface engine (Cloverleaf version 5.6 or higher OR Mirth version 3.0 or higher) (May hire into position without certification, but must attain certification within the first 6 months of hire to continue employment)
- Certified Professional Health Information Exchange (CPHIE) or CPHIMS certification preferred.
Additional Information
- Organization: Corporate Services
- Department: Ascension HIE
- Shift: Day Job
- Union Code: Not Applicable
|