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.
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 and staff combine high academic standards and a commitment to the exchange of knowledge with a supportive approach to learning. Graduates are equipped to think critically and creatively, write clearly, speak persuasively, and meet challenges in a diverse, interconnected world. Allegheny College is deeply committed to creating an inclusive community that actively challenges racism, sexism, heterosexism, religious bigotry, and other forms of bias (see Allegheny College Statement of Community).
Allegheny College is an Equal Opportunity Employer with a strong commitment to diversity, inclusion, and equity. Women, veterans, individuals with disabilities, and members of other underrepresented groups are highly encouraged to apply. Allegheny does not discriminate on the basis of race, color, religion, gender, gender identity, gender expression, sexual orientation, age, or national origin.
Allegheny College is committed to providing access, equal opportunity and reasonable accommodations for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, contact the Director of Human Resources.
Visit the Allegheny College Web
Site at http://www.allegheny.edu
