Integration and Applications Engineer

Location: Sprague

** 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.
* 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 hify 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.
* 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 Postgre

SQL.
* Experience with…