Oracle Integration Analyst

Summary of Position

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.

Key Responsibilities

Integration Architecture, Requirements & Design

• 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; escalate issues promptly.
• Promote maintainable, supportable interfaces and minimize unnecessary point-to-point customization.

Integration Development, Configuration & Data Exchange

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

Integration Testing, Cutover & Operational Readiness

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

Enterprise Integration Support, Governance & Collaboration

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

Experience and Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, or related field

Required Knowledge

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

Required Skills

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

Required Abilities

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

Computer Skills

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

Additional Information

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.

YOUR COMPENSATION

Starting salary will be competitive, based on the candidate’s qualifications and experience.