Integration Analyst II

Description GENERAL STATEMENT OF DUTIES The Integrations Analyst is tasked primarily with supporting and coordinating the implementation and operational needs of the various systems and services delivered by the integrations/interoperability team. This role plays a key part in supporting clients who the organization delivers services and products to. This role involves documentation, technical implementation, communication, scheduling, vendor coordination, project meetings, and maintenance of various integration systems. The work includes data collection, data validation, and data reporting related to existing and anticipated connections with clients, as well as active engagement in technical implementations and planning. Security and privacy are vital in the work performed, as it will commonly involve access to and reviews of electronic personal health information (ePHI) in the forms of HL7, CCDA, SQL, and other data formats. This position plays a key part in the overall integration operations of the organization both internally and for externally facing systems and partners. ESSENTIAL FUNCTIONS Manage technical documentation for client interfaces, connections, data transforms, and other areas related to clients. Coordinate and schedule both internal and external meetings and follow-up as necessary. Participate in kick-off and project integration calls for clients and external parties. Provide and serve as initial support for client connectivity or data issues. Professional communication with clients, vendors, and business partners related to ongoing implementations and operational needs. Data validation and testing as part of integration activities, upgrades, and other changes to the integration/interoperability infrastructure. Generate reports and documentation for consumption by clients, vendors, and business partners as needed. Assist with employees and contractors on how to properly use all systems, including writing training materials and tools utilized in daily work. Identify opportunities for process improvement or automation that improve the ability to deliver. Follow internal operational procedures and processes related to change control. Resolve and troubleshoot system issues across multiple environments. Participate in analysis and design of business process, training development, and deployment planning. Interact with staff across the organization to complete project activities and deliverables. Demonstrates the ability to support multiple integrations across multiple simultaneous projects, while staying within defined project timelines, and balancing multiple priorities/tasks. Ensures and enforces stability of data management and transfers through systems, for maintaining the integrity of the data residing on systems, facilitating and performing validations, and error resolution and decision making to complete or support business processing requirements. Works with vendors and clients to ensure needed coordination is in place between application owners and Integration development and support teams. Partners with product development teams providing real-world feedback impacting architecture, features, and roadmap. Demonstrates the ability to proactively escalate concerns/issues to the appropriate parties. Participates in on-call rotation providing after-hours support for production integrations/applications. Performs other duties as assigned. EDUCATION BA/BS in MIS, Computer Science, Engineering, Information Technology, or other technical fields. EXPERIENCE 3+ years clinical interface support, data management, database integrations, and data analysis 2+ years HL7, web services, XML, X12, 837/839, APIs, FHIR, SOAP, JSON 3+ years IT systems, networking, or infrastructure operations including troubleshooting connectivity issues. KNOWLEDGE Understanding and knowledge of HL7 interface engine technologies Working knowledge of communication methods (e.g. web services, SFTP, SSH, HTTP, TCP, etc.) Knowledge of data normalization (LOINC, Snomed, CPT, ICD-9, etc). Experience with multiple database platforms (e.g. MS SQL Server, Oracle, MySQL, etc…) Healthcare Industry knowledge and familiarity with medical terminology. Health technologies – e.g. EHR, HIS, PMS, HL7, HIE, CDR, etc. Familiarity with project management methodologies – e.g. waterfall, agile, etc. Familiarity with cloud services for databases and integrations delivered in Azure and AWS. Experience working with multiple clients and complex cross-environment data integrations SKILLS & ABILITIES Ability to work independently and as part of larger project teams Ability to manage multiple tasks and projects simultaneously Effective time management with both operational and project-based activities Professional communication skills internally and with external clients, both written and verbal Data and quality analysis from disparate data sources Scripting – e.g. Java/JavaScript, SQL, PHP, Perl, Python, PowerShell Ability to translate business needs into technical solutions Data mappings and transformations Advanced SQL Queries Advanced Excel Skills PowerBI and other visualization tools Ability to break down and resolve complicated technical challenges Ability to work with cross-disciplinary teams ENVIRONMENTAL WORKING CONDITIONS Normal office environment May require some travel. PHYSICAL/MENTAL DEMANDS Requires sitting and standing associated with a normal office environment. Manual dexterity using a calculator and computer keyboard. ORGANIZATIONAL REQUIREMENTS Hopper Mission, Vision and Values must be acknowledged and adhered to This description is intended to provide only basic guidelines for meeting job requirements. Responsibilities, knowledge, skills, abilities and working conditions may change as needs evolve.