Integration And Data Integration Systems Specialist

Job Description

Community Health Systems is one of the nation's leading healthcare providers. Developing and operating healthcare delivery systems in 43 distinct markets across 15 states, CHS is committed to helping people get well and live healthier. CHS operates 77 acute-care hospitals and more than 1,000 other sites of care, including physician practices, urgent care centers, freestanding emergency departments, occupational medicine clinics, imaging centers, cancer centers and ambulatory surgery centers.

Summary:

The Integration and Data Integration Systems Specialist is a technology savvy individual with exemplary knowledge of industry trends and best practices and applies them successfully in their areas of work. They will lead requirements analysis, solutions design, estimation, and development of new interfaces as well as maintenance and support of existing ones. Responsible for programming system interfaces based on real-time HL7 and API transactions within a healthcare setting on MIRTH and Rhapsody. Maintain accurate documentation for data flows, connectivity specifications, routing, filtering, data manipulation, problem resolution, root cause analysis, and change control. They will also be responsible for data and analytics based efforts. These efforts are integrated over various systems and may include: free standing reporting systems, cloud based data, on GCP systems to include Enterprise Data Stores and Looker Studio Services.

Responsibilities:

• Use SQL queries and analyze FHIR data to test various ETL and data pipelines.

• Perform data validity, accuracy and integrity, test across different components of the Data Platform.

• Build automated test framework and tools to automate the Data Platform services and applications.

• Automate regression, test and perform functional, integration and load testing.

• Articulate issues to developers. Triage production level issues by analyzing the production logs and work with the development team until the issues are resolved.

• Proactively solve problems and suggest process improvements.

• Provide test case coverage and defect metrics to substantiate data integrity.

• Work with the product managers and the team leads to understand the requirements and come up with the relevant test cases and execute them.

• Knowledge of programming languages preferred, including SQL, Java and Python.

• Hands-on experience with SQL database design preferred.

• Experience with big data tools preferred, including GCP, Hadoop, Spark, and Kafka.

• Experience with relational SQL and NoSQL DBs preferred, including Postgres and Cassandra.

• Experience with Google Big Query cloud services preferred.

• Experience with stream-processing systems preferred.

• Experience with scripting languages preferred, such as Python, Java Script, JSON, Scala.

• Assist the Team Lead and Manager, Integration (HL7) in leading team building activities including recruitment, coaching and facilitating meetings.

• Design and develop interface solutions according to the project scope, scalability, portability, and best development practices given constraints such as limited client resources, time deadlines, and technological impediments.

• Development of interfaces that have included ADT's, Orders, Order Status Updates, Add-on Orders, Results, Charges and Transcription. This includes real-time interface spooling, archiving, traces, connectivity, client/server configuration, pseudo connections, routing, mapping, filtering, translations and error exception handling.

• Expert level knowledge and skills that support communication protocols and standards for HL7, FHIR, JSON, X12 and XML

• Expert level knowledge of batch processes and configurations involving polling, automation and scheduling

• Ability to successfully apply modifications to existing interfaces to enhance functionality or improve integrity

• Ability to monitor integration engine performance, logs, databases, connections and disk usage

• Ability to ensure test and training environments sustain a high level of synchronization and integrity with the production (live) environments.

• Advanced knowledge of network architecture (TCP/IP communication layer), servers, redundancy and clustering

• Work with Project Management and Business Analysis Teams to translate interface requirements into a well-defined project scope.

• Demonstrate excellent analytical, logical reasoning, problem solving, verbal, written communication, teamwork, and interpersonal skills. This includes consistently providing accurate estimates.

Qualifications:

Education Required: Bachelor's Degree

Experience required:

• 5+ years' experience with HL7 messaging on MIRTH and Rhapsody integration engines.
• 3+ years of experience in performing high and low level project analysis and design.
• 3+ years of experience with Healthcare registration, financial, and clinical systems preferred.
• 2+ years of advanced experience with Tool Command Language (TCL) and Java Script programming.
• 5+ years of experience with a multitude of interface connectivity methods such as HL7 socket communications, SFTP file transfers, and API.

Physical Demands:

In order to successfully perform this job, with or without a reasonable accommodation, the following are outlined below:

• The Employee is required to read, review, prepare and analyze written data and figures, using a PC or similar, and should possess visual acuity.

• The Employee may be required to occasionally climb, push, stand, walk, reach, grasp, kneel, stoop, and/or perform repetitive motions.

• The Employee is not substantially exposed to adverse environmental conditions and; therefore, job functions are typically performed under conditions such as those found within general office or administrative work.