Oracle Integration Analyst
Allegheny College
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Allegheny College seeks an Oracle Integration Analyst to design, coordinate, implement, and support critical integrations during the Ellucian Colleague to Oracle Student Management transition. This full-time temporary role sits within Information Technology Services (ITS) and collaborates with campus offices, system owners, and implementation partners to ensure secure data exchange across applications.
The analyst will own integration inventory, source-to-target mappings, interface specs,
Qualifications
- Bachelor's degree in a related field is required.
- Experience with enterprise integrations across campus systems.
- Strong analytical, documentation, and collaboration skills.
- Knowledge of FERPA and data privacy preferred.
Responsibilities
- Lead technical analysis and design of Oracle Student integrations.
- Maintain end-to-end integration inventory and mappings.
- Coordinate interface development, testing, and cutover readiness.
- Collaborate with vendors, campus offices, and ITS teams.
Skills
Education
Tools
Job description
The Oracle Integration Analyst is a full-time, temporary position responsible for designing, coordinating, implementing, and supporting integrations critical to Allegheny College’s transition from Ellucian Colleague to Oracle Student Management. As a member of Information Technology Services (ITS) and the Oracle Student implementation team, the analyst will work closely with campus functional offices, enterprise system owners, and implementation partners to ensure reliable and secure data exchange across institutional applications.
As a member of Information Technology Services (ITS) and the Oracle Student implementation team, the analyst will work closely with campus functional offices, enterprise system owners, and implementation partners to ensure reliable and secure data exchange across institutional applications.
This hands-on technical role owns the institutional integration inventory, source-to-target mappings, interface specifications, development coordination, testing, monitoring, troubleshooting, and operational handoff. The analyst will work with APIs, file-based interfaces, middleware and vendor-supported integration methods, while supporting dependencies across the student lifecycle and connected finance, human resources, identity, learning, advising, reporting, and other campus systems. The successful candidate combines integration engineering experience with strong analytical, documentation, and collaborative skills.
This full-time temporary position is aligned with the Oracle Student implementation timeline. As the College evaluates its long-term enterprise integration and Student support model, the position may be considered for longer-term employment based on institutional need. Continued employment is not guaranteed.
The Oracle Integration Analyst is a full-time, temporary position responsible for designing, coordinating, implementing, and supporting integrations critical to Allegheny College's transition from Ellucian Colleague to Oracle Student Management. As a member of Information Technology Services (ITS) and the Oracle Student implementation team, the analyst will work closely with campus functional offices, enterprise system owners, and implementation partners to ensure reliable and secure data exchange across institutional applications.
This hands-on technical role owns the institutional integration inventory, source-to-target mappings, interface specifications, development coordination, testing, monitoring, troubleshooting, and operational handoff. The analyst will work with APIs, file-based interfaces, middleware and vendor-supported integration methods, while supporting dependencies across the student lifecycle and connected finance, human resources, identity, learning, advising, reporting, and other campus systems. The successful candidate combines integration engineering experience with strong analytical, documentation, and collaborative skills.
This full-time temporary position is aligned with the Oracle Student implementation timeline. As the College evaluates its long-term enterprise integration and Student support model, the position may be considered for longer-term employment based on institutional need. Continued employment is not guaranteed.
- Lead the technical analysis and design of integrations required for Oracle Student Management.
- Maintain the end-to-end integration inventory, interface dependencies, owners, source/target systems, schedules, and criticality.
- Facilitate discovery with campus functional offices, ITS technical teams, Oracle, and the implementation partner to define interface requirements.
- Translate business events and data needs into technical specifications, interface contracts, mapping documents, and acceptance criteria.
- Assess existing Ellucian Colleague/Unidata feeds and determine whether integrations should be retired, redesigned, or replaced.
- Define integration patterns including APIs, event-driven exchanges when supported, scheduled file transfers, and vendor-managed connectors.
- Identify integration risks, sequencing dependencies, environment needs, and cutover requirements; esc leate issues promptly.
- Promote maintainable, supportable interfaces and minimize unnecessary point-to-point customization.
- Build or coordinate delivery of secure, reliable interfaces and student-related data flows.
- Develop, configure, or oversee integrations using Oracle-supported interfaces, REST/SOAP APIs, SFTP, middleware, and structured data formats as appropriate.
- Create and validate source-to-target mappings, transformations, field-level business rules, reference data, and error-handling logic.
- Partner with vendors and implementation teams to review design artifacts, code/configuration, and technical deliverables for completeness and quality.
- Work with teams supporting identity and access, LMS, student services, finance, HR, reporting, and other affected applications.
- Coordinate interface credentials, secure transfer methods, service-account access, environments, schedules, and operational controls.
- Support the transition from legacy Ellucian integrations, including parallel runs, reconciliations, and retirement of superseded feeds.
- Apply data quality, logging, reconciliation, and recovery practices to reduce integration failures and downstream impacts.
- Validate end-to-end exchanges and prepare interfaces for a controlled production transition.
- Develop and execute unit, system, end-to-end, regression, volume, and negative-path integration test plans.
- Validate records, transformations, timing, duplicate prevention, exception handling, and downstream reconciliation with functional owners.
- Track integration defects, coordinate fixes and retesting, and maintain evidence of test outcomes and sign-off.
- Create cutover runbooks, interface activation schedules, fallback procedures, and post-cutover verification checklists.
- Establish monitoring, alerting, incident escalation, retry/reprocessing, and ownership procedures for production interfaces.
- Document interface designs, configurations, support runbooks, and knowledge transfer materials for the Enterprise Systems team.
- Support hypercare and post-go-live stabilization, investigate failures, and coordinate corrective actions.
- Support the sustainability, security, and governance of the College’s integration ecosystem.
- Collaborate with Enterprise Systems, infrastructure, security, vendors, and business owners to troubleshoot production data flows.
- Apply FERPA, least-privilege access, encryption, secure credential handling, audit logging, and College security standards.
- Participate in integration change control, release planning, version management, and impact assessments.
- Promote agreed-upon authoritative data sources, data definitions, interface ownership, and support accountability.
- Cross-train ITS colleagues and share knowledge to reduce key-person dependency after implementation.
- Communicate integration health, technical risks, decisions, and milestones clearly to technical and nontechnical stakeholders.
- Support related enterprise system enhancements and integration improvements as assigned.
- Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, or related field
- Knowledge of systems integration architecture, interface life cycles, API design, and common enterprise integration patterns.
- Understanding of REST/SOAP services, JSON/XML, SFTP/file exchanges, authentication, data transformation, and error-handling approaches.
- Working knowledge of SQL, relational data models, source-to-target mapping, validation, and reconciliation techniques.
- Understanding of secure systems integration, least-privilege access, logging, and protection of regulated student information.
- Ability to learn Oracle Student Management, legacy Ellucian Colleague/Unidata structures, and higher-education data flows, including FERPA requirements.
- Hands-on experience developing, configuring, supporting, or coordinating complex enterprise integrations.
- Ability to write clear interface specifications, field mappings, diagrams, support procedures, and technical runbooks.
- Proficiency in SQL-based investigation, payload review, data analysis, troubleshooting, and reconciliation.
- Experience creating integration test cases, diagnosing failures, and managing technical defects through resolution.
- Strong organization and delivery skills with the ability to manage multiple dependent interfaces and project milestones.
- Demonstrated collaboration with business owners, application vendors, implementation partners, security, and infrastructure teams.
- Clear written and verbal communication skills, including translating technical integration issues for nontechnical audiences.
- Ability to understand complex cross-system dependencies and translate business workflows into technical data exchanges.
- Ability to investigate incomplete, delayed, duplicated, or inconsistent data across systems and identify root causes.
- Ability to work independently, contribute to a cross-functional implementation team, and follow through on deliverables.
- Ability to maintain accurate configuration, interface, and testing documentation with attention to detail.
- Ability to coordinate technical decisions with stakeholders who have competing timelines and operational needs.
- Ability to adapt to evolving Oracle Student capabilities, changing implementation plans, and vendor release cycles.
- Ability to handle confidential data responsibly and uphold College security and privacy requirements.
- Advanced knowledge of SQL queries, troubleshooting, mapping and reconciliation with SQL / Databases / Data Analysis required.
- Advanced knowledge of REST/SOAP, JSON/XML, SFTP, authentication and testing with API & Integration Technologies required.
- Intermediate knowledge of Secure file exchange, test scripts, API clients and logs with Secure Data Transfer & Testing required.
- Intermediate knowledge of Asana, diagrams, technical specifications and change tracking with Project & Documentation tools preferred.
- Intermediate knowledge of Oracle Integration Cloud or comparable middleware/iPaaS with Integration Platforms / Tools preferred.Intermediate knowledge of Oracle Student, Oracle Cloud, Ellucian Colleague/Unidata with Enterprise Applications / SIS preferred.
Temporary Position and Long-Term Employment Consideration: This is a full-time temporary role created to deliver the integration work necessary for Oracle Student implementation, migration away from legacy interfaces, and post-go-live stabilization. The College will evaluate longer-term integration ownership and staffing needs as implementation progresses. Any transition to ongoing employment will depend on institutional need and is not guaranteed.
Starting salary will be competitive, based on the candidate’s qualifications and experience.
Allegheny College , founded in 1815, is one of the nation’s most historic and innovative four-year colleges with the distinct requirement of completing a major and minor in different academic areas. This multidisciplinary learning celebrates students’ unusual combinations of interests and provides creative, independent thinkers with a path for educational depth and intellectual growth, preparing them for a successful launch after graduation and even for careers that may not yet exist. Located in western Pennsylvania, 1.5 hours equidistant from Pittsburgh, Cleveland and Buffalo, Allegheny College is one of 40 colleges featured in Loren Pope’s“Colleges That Change Lives” and recently ranked #4 by The Princeton Review in its Top 20 Best Private Schools for Making an Impact. In its 2025 rankings, U.S. News & World Report recognized Allegheny College as one of the country’s top 100 national liberal arts colleges, with special distinctions including one of the top 10 best for senior capstone experience and one of the top 25 best for undergraduate research and creative activities.
Allegheny’s undergraduate residential education prepares students for successful, meaningful lives by promoting students’ intellectual, moral, and social development and encouraging personal and civic responsibility.
Allegheny’s faculty
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
