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