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 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 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 other Claremont technical meetings; Escalate urgent issues via phone and email to CIS managers outside of normal business hours when necessary; Support system and application related issues or initiatives in collaboration with other CIS teams; Ensure cybersecurity standards are upheld at all times in collaboration with TCC infosec and other partners; Perform other duties as assigned. Required Qualifications Education: Bachelor’s degree in Computer Science or related field and/or equivalent combination of education, training and experience. Minimum of 2 years of experience developing and maintaining software integrations in Microsoft Integration Services, Boomi or other similar systems. Experience managing database systems such as Microsoft SQL, MySQL or PostgreSQL. Experience with TypeScript/JavaScript and Node.js. Knowledge of REST and SOAP APIs, JSON and XML. Proficiency with API management and using Postman or similar API tools. Familiarity with iPaaS tools such as Boomi, Snaplogic, Mulesoft or Microsoft Integration Services. Flexibility to move between iPaaS solutions as required. Knowledge of data reporting solutions such as IBM Cognos and Microsoft Power BI. Proficiency in a software programming language (e.g., 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. Preferred Qualifications 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 to create outbound integrations from Workday to other target applications. Remote Work Eligibility Category C: All staff positions, regardless of remote work eligibility, require an initial 30‑calendar‑day on‑campus work period. Based on an evaluation by the Area Leadership Group (supervisor, area leader and area Cabinet member) and HR, this position is classified as Category C as defined in the College’s Remote Work Policy, with occasional ad‑hoc remote work flexibility as needed. Upon approval by the Area Leadership Group and HR, this position may work up to 2 remote work days per week during the academic year and up to 3 remote work days per week during the non‑academic year. These days may vary depending on departmental and College needs, and remote work is subject to the College’s remote work policy. Physical Requirements While performing the duties of this job, the staff member is regularly required to sit; stand, use hands and fingers and talk or hear. The employee is occasionally required to reach with hands and arms. The individual must regularly lift and/or carry up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, and the ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Salary $85,000 – $92,000 per year. Hours Regular hours are Monday‑through‑Friday, 8:00a.m. to 5:00p.m. (including a one‑hour meal period). Hours may vary due to the needs of the College or department. Classification This is an exempt, full‑time, regular, benefits‑eligible position. Reports To Senior Director of IT Infrastructure and System. Additional Information This job description defines the essential job duties of the position. Harvey Mudd College expects that employees hired for this position can perform the essential functions of the job without imposing risk of substantial harm to the health or safety of themselves or others. It may also include marginal functions, generally defined within TitleI of the Americans with Disabilities Act. Regular employment at the College is for no specified period; conditions and status of employment (hours, pay, title, duties, etc.) are subject to change at any time. Employment is at‑will and employees, and likewise the College, are free to end the employment relationship at any time, for any reason, with or without notice or cause, unless otherwise prohibited by law. Equal Opportunity Employer HarveyMuddCollege is an Equal Opportunity Employer. Qualified applicants will be given consideration for employment without regard to age, race, gender, national origin, sexual orientation, protected veteran’s status, disability, or any other characteristics protected by applicable law. #J-18808-Ljbffr The Claremont Colleges Services