Integration and Applications Engineer

Harvey Mudd College•Spokane Valley, WA

2d•Hybrid

About The Position

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.

Requirements

Bachelor’s degree in Computer Science or related field and/or equivalent combination of education, training and experience.
A minimum of 2 years experience developing and maintaining software integrations in Microsoft Integration Services, Boomi or other similar systems.
Experience with management of database systems such as Microsoft SQL, MySQL or PostgreSQL.
Experience with typescript/javascript and node.js.
Demonstrated knowledge of REST and SOAP approaches to APIs including knowledge of JSON and XML.
Demonstrated proficiency with API management. Experience using Postman or similar API tools.
Demonstrated familiarity with iPaaS tools such as Boomi, Snaplogic, Mulesoft or Microsoft Integration Services. Flexibility to move between iPaaS solutions as required.
Demonstrated knowledge of data reporting solutions such as IBM Cognos and Microsoft Power BI.
Proficiency in a software programming language (for example, Python, Javascript, Typescript, Node.js, Ruby, Go). Experience using AI tools to streamline integration development.
Ability to communicate in an understandable, polite and friendly manner, both written and verbal. Ability to work with a range of technical staff of varying skill sets and backgrounds to troubleshoot and develop joint solutions.
Demonstrated understanding of technical troubleshooting methodology and effective analytical skills.

Nice To Haves

Familiarity with Anthology or similar SIS solutions.
Familiarity with Pathify, uPortal or other similar portal solutions.
Technical understanding of identity and access management and account lifecycle.
Experience and willingness to provide necessary server and system administrative support.
Strong organizational skills and ability to multitask in a campus environment.
Some experience writing Workday Reports as a Service or experience working with a skilled Workday report writer in order to create outbound integrations from Workday to other target applications.

Responsibilities

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.
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.
As part of a team, proactively 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. Sometimes responsible to mentor, direct and train staff and perform as the technical lead. Attend and actively participate in team, CIS department, and other Claremont technical meetings. Occasionally may need to escalate urgent issues via phone and email to CIS managers outside of normal business hours. Work directly with other CIS teams to support system and application related issues or initiatives. In consultation with the CTS team, TCC infosec and other partners, ensure that cybersecurity standards are upheld at all times. Other duties as assigned.