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 part 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. Proficiency in SQL Server Management Studio is essential, along with a strong understanding of SQL data retrieval and manipulation. The engineer will also be responsible for standard management and maintenance tasks, including making and restoring backups and creating maintenance plans and jobs. In addition to database management, the IT Integration Engineer will perform 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 SFTP support and setup, with after-hours and on-call responsibilities to assist with any SQL or HL7 issues that arise. The engineer will manage multiple project requests simultaneously, leading system/application testing alongside end users and coordinating efforts with the PMO Office when applicable. This includes providing necessary updates to the PMO Office and leading a team on assigned projects. The IT Integration Engineer will also be responsible for using and supporting applications and analytical tools, evaluating data quality, and maintaining operations. This individual will need to research new data sources and analytical tools, contributing to product development and improvements in product delivery and presentation. Effective communication and assistance to all hospital associates regarding hospital operations are vital, and the engineer may serve as a department liaison when needed. Overall, this position requires a proactive approach to process improvements for existing and new production workflows, ensuring that the organization meets its data integration and analysis needs effectively.