IT Integration Engineer

Berkshire Health Systems - Pittsfield, MA

Full-time - Mid Level

Pittsfield, MA

Hospitals

About the position

The IT Integration Engineer plays a crucial role in the development and management of data integration processes within the organization. This position requires an individual who can independently develop programs, methodologies, and files for analyzing and presenting data. The engineer will utilize tools such as Visual Studio Development, NPR, Crystal Reports, MS SQL, and various scripting languages to accomplish these tasks. A significant aspect of the role involves SQL Server database administration, which includes designing and creating standard database objects such as tables, views, stored procedures, functions, triggers, indexes, and ensuring referential integrity. The engineer must also be proficient in using SQL Server Management Studio and have a strong understanding of SQL data retrieval and manipulation. In addition to database management, the IT Integration Engineer will be responsible for performing data analysis to support both ad-hoc and standing customer requests. This may involve analyzing, designing, documenting, testing, troubleshooting, coordinating implementation, and providing technical support for HL7 interfaces between Health Information Systems (HIS) and ancillary application systems. The role may also require setting up and supporting SFTP connections. The engineer will work on multiple project requests simultaneously, leading system/application testing alongside end users and collaborating with the PMO Office when necessary. This position may involve leading a team on assigned projects and orchestrating efforts between IT, end users, and vendors, ensuring that necessary updates are communicated to the PMO Office. The IT Integration Engineer will also be tasked with using and supporting various applications and analytical tools, evaluating data quality, and maintaining operations. This includes researching new data sources and analytical tools, contributing to product development, and improving product delivery and presentation. The engineer must develop an awareness of issues affecting customers and perform process improvements for existing and new production workflows. Effective communication and assistance to hospital associates regarding hospital operations are essential, and the engineer may serve as a department liaison when needed.

Responsibilities

• Develop programs, methodologies, and files for data analysis and presentation.
• Perform SQL Server database administration tasks, including creating and managing database objects.
• Provide technical support for HL7 interfaces and SFTP connections.
• Lead system/application testing and coordinate with end users and the PMO Office.
• Research new data sources and analytical tools for product development.
• Evaluate data quality and maintain operations of applications and analytical tools.
• Communicate effectively with hospital associates and provide assistance regarding hospital operations.

Requirements

• Six years of programming, analysis, or vendor provided software support experience.
• Microsoft SQL relational database experience preferred.
• Two years of HL7 Interface Engine Support experience.
• Demonstrated written and oral communication skills.
• Knowledge of computer programming practices and system analysis.
• Ability to present design concepts and system functions clearly.
• Project management skills to manage multiple complex projects simultaneously.
• Lead or supervisory experience in a technical environment.
• Interpersonal skills for conducting training and participating in meetings.
• Ability to establish and maintain effective business relationships.
• Experience with report writing/programming tools such as Meditech NPR, SQL, Visual Studio Development, and Polaris preferred.
• Previous experience in the healthcare industry is highly desirable.
• Training and education skills to teach IT concepts and application usage.

Nice-to-haves

• Familiarity with the JCAHO survey process and related regulations.