Integration and Applications Engineer

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 Engineer assists in the development and maintenance of integration of data between hosted, cloud, and on‑premise systems and applications. They 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 (e.g., Anthology, Pathify, Azure Active Directory/Entra ) 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.

• Organize reliable and efficient operations of campus data integrations and tools used to implement integrations; major software updates and patches;
• Service lifecycle management and API management, including sub‑account and user management;
• Support for others working on integrations and design, implement, and maintain backend systems using ETL solutions, Microsoft Power/Web Apps and custom software solutions;
• Plan and implement roll‑out of Pathify at HMC and maintain tools for exchanging data and reporting (IBM Cognos, Microsoft Power BI, etc.);
• Conduct design architect reviews, gap analysis and assessments 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;
• Choose the appropriate platform(s) for new integrations in collaboration with the Data and Integrations Developer;
• Review integrations developed by others and provide constructive 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;
• Maintain fluency in software and data tools that CIS provides (Microsoft Integration Services, Microsoft Power/Web Apps, Boomi and Pathify Flow) and 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;
• Keep up to date with developments in data integration tools and methods, and provide recommendations to improve secure handling of data and to improve operational efficiencies;
• Attend conferences and training sessions that cover data integrations to and from cloud and local systems;
• Relay acquired knowledge back to CIS;
• Develop criteria and advise departments on topics of integrating and automating their exchange of data to vendors and other campus departments or Claremont Colleges, and ensure their ongoing support;
• Monitor critical services and take appropriate action to resolve issues, design methods for restoration and recovery of data and software for various systems;
• Provide application and system support outside of usual campus hours, as needed or required;
• Create and maintain needed documentation;
• Mentor, direct and train staff and perform as the technical lead where requested;
• Attend and actively participate in team, CIS department, and…