Integration and Applications Engineer

NOTE TO APPLICANT:  Some positions require a resume, cover letter and/or other documents to be submitted with your application. Please submit these as one attachment in the My Experience section of the application under the "resume/CV" upload section. Once you submit your application, you will not be able to attach additional documents.

Job Posting Title:

Integration and Applications Engineer

Job Description:

Integration and Applications Engineer

Core Technology Systems

Computing and Information Services

POSITION SUMMARY

The Integrations and Applications Engineer (Engineer) works closely with the Data and Integrations Developer to ensure coordinated delivery of services to the HMC community. The Integration and Applications Engineer will assist in the development and maintenance of integration of data between hosted, cloud, and on-premise systems and applications. They will also develop and maintain functionality within the HMC portal, provided via the Pathify platform. The Engineer will support the Data and Integrations Developer to manage and support software (eg. Anthology, Pathify, Azure Active Directory/Entra ID) and integration services between various systems. The Engineer manages and maintains integrations built on iPaaS (integration platform as a service), currently Boomi, as well as developing and maintaining new integrations using Microsoft Integration Services, Microsoft Power/Web Apps and Pathify Flow. The Engineer will assist with daily operations, supporting existing software and data services and fostering continued integration and automation. The Engineer will play a key role for HMC in the launch of the Anthology Student Information System (SIS) along with ongoing support for the SIS and connected systems.

DUTIES AND RESPONSIBILITIES

Working as a member of an integrated team (CTS), the Engineer will:

• Organize reliable and efficient operations of campus data integrations and tools used to implement integrations; 

• • Major software updates and patches

  • Service lifecycle management

  • API management

  • Sub account and user management

  • Support for others working on integrations

• Design and implement and maintain backend systems using ETL solutions, Microsoft Power/Web Apps and custom software solutions. 

• Plan and implement the roll out of Pathify at HMC. Pathify is a portal and integration product that will be used in conjunction with the new Student Information System, Anthology.

• Plan, implement, and maintain tools for exchanging data and reporting (IBM Cognos, Microsoft Power BI, etc.).

• Conduct design architect reviews, gap analysis and assessment for existing and new integrations when required.

• Work closely with integration specialists from The Claremont Colleges (TCC) and The Claremont Colleges Services (TCCS) to ensure accurate and secure data flows between shared systems such as Anthology, OnBase, EMS, Student Health Services systems, Rapid Identity and Workday Reports as a Service.

• Develop, document, implement and maintain integrations using ETL solutions such as Microsoft Integration Services (ADF, SSIS), Microsoft Power/Web Apps and Boomi. Working closely with the Data and Integrations Developer, choose the appropriate platform(s) for new integrations. 

• Review integrations developed by others and provide feedback.

• Develop a comprehensive understanding of internal customer business needs, system functionality and business processes.

• Contribute to and follow CIS change management standards and processes.

• Design configurations for management and access control for student data and other campus information systems.

• Become fluent in software and data tools that CIS provides (Microsoft Integration Services, Microsoft Power/Web Apps, Boomi and Pathify Flow). Actively inform CIS staff and others on campus about features and functionality of these tools.

• Play a tier two role in day to day support for reporting and tools, supporting tier one staff in troubleshooting and end-user problem resolution.