Internship Microsoft Power Apps Developer Jobs in Riverside, CA

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.
• 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.

Other Responsibilities

• 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.

APPLICANTS WITH AT LEAST SOME OF THE FOLLOWING ARE ENCOURAGED TO APPLY.
REQUIRED QUALIFICATIONS:
Education:
Bachelor's degree in Computer Science or related field and/or equivalent combination of education, training and experience.
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.

Knowledge, Skills, and Abilities:

• 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.

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 in order 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. Please note these days may vary depending on departmental and College needs. Additionally, remote work is subject to the College's remote work policy. The College reserves the right to revoke or modify a remote work arrangement for any staff, at any time and for any reason as articulated in the College's remote work policy.
Standard working hours for this position will generally be from 8:00 a.m. to 5:00 p.m., Monday through Friday, though these hours may vary depending on departmental and College needs.
All remote work arrangements, including ad-hoc remote work, must be approved by the direct supervisor, area Cabinet member and Human Resources, and are subject to periodic review based on institutional needs. These arrangements are neither guaranteed nor considered entitlements and may change due to factors such as employee performance, evolving business needs, or changes to the position.
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.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Salary: $85k-92k/year
Hours:
Regular hours are Monday, through Friday, 8:00 A.M. to 5:00 P.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 Title I 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.
Harvey Mudd College 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.
Please note that in order to be considered an applicant for any staff position at Harvey Mudd College you must apply for each position for which you believe you are qualified.