Integration Engineer

Job Description

Responsibility

40 New and Ongoing Interface Implementation

• Determines and analyzes interface/integration capabilities between client hospital information systems and Premier products by reviewing specifications and working with interface vendors and client technical teams to determine the best interface options.

• Analyzes raw data for structure, format, content, and relationships to ensure compatibility and requirements for the various analyses performed.

• Develops and maintains scripts, regular expressions, and other data transformations needed to support data interfacing.

• Generally sets up data processing for new clients to ensure proper data flow, analysis, and reporting.

• Serves as a liaison with vendors, clients, and consultants to resolve data integration issues.

• Collaborate closely with other internal teams to ensure proper data context, mapping, and analysis processing.

25 Analysis & Development

• Plan, design, implement, maintain, and provide ongoing optimization and support for specified clinical and/or business applications

• Perform workflow assessments, capture business needs, and analyze internal systems to determine functional requirements for optimal utilization of extracts

• Work with cross-functional team and with end-users to achieve application integration to meet clinical needs

• Execute builds, upgrades, and system enhancements as needed.

• Build and provide SQL and other database query technology for writing packages, functions, stored procedures, triggers and creating tables and indexes

• Performs data profiling, data analysis and modeling to provide customer-focused solutions

• Advise on the development of data specifications and canonicals that reflect source system data balanced with application requirements

• Participate in planning sessions and provide status reports using task tracking tools such as JIRA

• Communicate with Members regarding integration requirements and customizations

20 Client Technical and Data Support

• Provides application and client user support.

• Performs ad-hoc queries (esp. T-SQL) to troubleshoot and ‘sleuth’ data issues; often as a result of client Help Desk issues.

10 Implementation Support

• Support applications and interfaces throughout all phases of implementation

• Implement changes to extracts as needed

• Deliver post-implementation training, support, troubleshooting and maintenance

• On-call support responsibilities as assigned

5 Product Development

• Subject matter expert with vendor specific applications and technologies, and associated products

• Provides guidance and expertise in healthcare data domains, with particular emphasis on EMR and clinical data sets

• Provides expertise on database extraction techniques

Minimum Entry Requirements

Bachelor's Degree: Computer Science, Management of Information Systems, Information Technology or related discipline

3 years related experience

• Operational experience in information systems, including experience integrating large, complex, mission-critical systems. Experience in healthcare and/or financial environments is strongly preferred.

• A minimum of one (1) year commercial experience with programming languages including in-depth understanding and practical knowledge of relational databases.

• Experience with Java and MySQL is ideal.

• Extensive experience inspecting and parsing complex textual data using regular expressions.

• Strong working knowledge of HL7 2.x and XML a plus

• Excellent analytical ability and interpersonal skills to communicate and collaborate effectively with senior management, customers, and other staff members.

• Ability to work independently and proactively in a fast-paced, dynamic environment while delivering outstanding customer-focused software solutions.

Technical skills to include:

• Data Interfacing and Transformation Technologies: Experience with (or ability to quickly learn) data interfacing technologies such as SQL Server DTS, DataJunction/ DataIntegrator, and HL7.

• Data Filtering, Manipulation, and Loading: Experience with loading data into database tables, data filtering, parsing, and recognition using regular expressions and other common techniques.

• Data Processing Setup: Ability to learn proprietary data loading/processing techniques and implement initial workflow and data setup including loading workflow process data, initial data mappings, pick-lists, subscription information, user accounts, core reports, and other meta-data.

 Preferred

Master’s degree

5 years related experience

5 or more years’ experience in business or healthcare data environment that includes:

• Proven database and report/query development experience (T-SQL stored procedures, views, and other queries) in a small, fast-paced, growing environment

• Proven experience in data interfacing and transformation technologies

Demonstrable ‘must-have’ experience with the following technologies: SQL Server 2000 and Windows based operating systems

HL7 Certification

Qualifications

Additional Information

GOOD COMMUNICATION S

C2H

H1B,OPT- EAD,GC or USC

DURATION: 6 + MONTHS