ANNOUNCEMENT OF POSITION VACANCYFLSA Status: United States of America (Exempt)
Compensation: $80,000-$90,000
Commensurate with education and experience. Excellent health and retirement benefits package: Click here for more information!
SECTION II - THE SEATAt CMU, we look at every position as a seat. Every seat is vital and the individual in the seat contributes significantly to our mission of providing an affordable and accessible education and forming meaningful and mutually enriching partnerships that support the well-being and vibrancy of our community. As a human centric organization, a priority is to ensure we have the "right seats" in our organization, and that the expectations, ownership and accountabilities are defined and communicated clearly for the success of the individuals holding the seats.
This seat is the University's primary technical resource for the Student Information System (SIS), student-system integrations, and student data architecture and management. The current environment is Banner running on Oracle; the durable responsibility is to maintain reliable student systems and data regardless of whether the future platform is Ellucian Student, Workday Student, or another approved solution.
The current Banner and ancillary student environments are hosted by Ellucian. Ellucian performs operating-system, database-engine, and application-layer patch installation for hosted services. This seat owns CMU's application-owner responsibilities: release-note and advisory review, institutional impact assessment, identification of affected integrations and business processes, coordination of technical regression testing and functional user acceptance testing, post-release validation, defect tracking, and escalation to Ellucian.
The seat owns day-to-day Banner technical operations, student-system database and application development, SIS integrations and outbound data feeds, and student data conversion and migration. It designs, develops, and maintains source data structures, database objects, data models, source-to-target mappings, integration specifications, and reconciliation processes that support operational student systems and downstream institutional data platforms.
This seat works closely with the Data Engineer to maintain consistent student data from the SIS through EAB Edify and downstream institutional data products. The SIS seat owns source-system meaning, structures, security, APIs, extracts, and mappings; the Data Engineer owns Edify ingestion, transformation, cross-source modeling, quality controls, lineage, and delivery. Both seats jointly resolve data-quality and mapping issues across the handoff.
The seat leads technical participation in SIS updates, releases, testing, modernization, and implementation planning, including conversion analysis, historical-data decisions, interface mapping, reconciliation, cutover validation, and post-implementation data quality. Current technologies include Banner, Oracle SQL/PLSQL, Linux, Python, and Ellucian Ethos; future technologies may include PostgreSQL-based Ellucian Student services or Workday Student data access and WQL.
This seat has no supervisory responsibilities. It coordinates technical activities with Ellucian, Oracle, EAB, Workday, implementation partners, consultants, and third-party service providers. The Director of Enterprise Applications retains final responsibility for contracts, procurement, licensing, vendor selection, and strategic vendor management.
Visa sponsorship is not available for this position. Applicants must be legally authorized to work in the United States at the time of hire and for the duration of employment, without the need for employer sponsorship now or in the future. Employment is contingent upon maintaining valid work authorization for the expected duration of the position.
OVERVIEW AND ROLE SCOPE OF TEAM AND/OR TASKSStudent Information System Platform OwnershipOwn and maintain the technical operation, development, configuration, integrations, security dependencies, releases, and lifecycle of the University's SIS, currently Banner.
Student Data Architecture and ManagementDesign and maintain student-system data structures, logical and physical data models, database objects, source-to-target mappings, data definitions, history requirements, and reconciliation controls from the SIS through Edify and downstream data products.
SIS Integration and Automation DevelopmentDevelop and support integrations using APIs, Ellucian Ethos, SQL/PLSQL, Linux scripting, Python, scheduled processes, secure file exchange, JSON, XML, and related technologies.
Data Lake Source and Quality PartnershipPartner with the Data Engineer to build and maintain SIS-to-Edify feeds, trace data-quality issues to their source, implement approved corrections, and ensure student data is represented consistently across operational and analytical platforms.
SIS Updates, Releases, Testing, and ModernizationLead CMU technical participation for Ellucian-hosted updates and releases by reviewing release notes and advisories, assessing impacts to Banner modules, integrations, reports, data, and business processes, coordinating technical regression testing and functional user acceptance testing, validating production after Ellucian implementation, tracking defects, and escalating issues. Also lead modernization, conversion, migration, cutover, reconciliation, and stabilization for future SIS platforms.
Technical Vendor Coordination and Functional PartnershipCoordinate technical work with vendors and partners and translate requirements from Enrollment Services, Academic Affairs, Student Services, Financial Aid, Institutional Research, Finance, Human Resources, and Information Technology into durable technical solutions. For Banner Financial Aid, lead technical release-note review, impact assessment, test planning, technical defect analysis, and Ellucian escalation while Financial Aid owns regulatory interpretation, functional test execution, expected business results, and readiness approval.
Cross-Training, Documentation, and Operational ContinuityMaintain accurate technical and operational documentation for assigned applications, integrations, configurations, procedures, and support responsibilities to support operational continuity, cross-training, and backup coverage.
ACCOUNTABILITY TO RESULTSThe individual in this seat is accountable for delivering the following outcomes. Targets may be refined by the Director of Enterprise Applications as baselines and institutional priorities are established:
- SIS updates, releases, testing, modernization, conversion, and migration milestones are completed according to approved priorities and committed timelines.
- Critical SIS operations, integrations, scheduled processes, and data feeds meet established service expectations and are monitored, supportable, and recoverable.
- Student data delivered from the SIS to Edify is complete, timely, traceable, and reconciled to agreed source-system controls.
- Ellucian-hosted SIS updates and releases have documented release-note review, impact assessment, assigned technical and functional test coverage, post-release validation, defect tracking, and vendor escalation with minimal disruption to University operations.
- Modernization milestones, data-conversion deliverables, and integration designs are completed according to approved project priorities and timelines.
- Priority SIS, integration, and student-data incidents receive timely technical response, documented resolution, and appropriate escalation.
- Owned systems, integrations, database objects, mappings, and procedures have current documentation and effective contributor coverage.
Additional metrics and results may be assigned as needed by our business.
CORE PROCESSESEnsuring that core processes are known, documented, and operate effectively across departments brings clarity and efficiency to our business. This seat owns or contributes to the following processes:
Owned:- Maintain SIS (Banner)
- SIS Database, Application, and Source Data Model Development (Current: Banner/Oracle)
- SIS Integration and Data Lake Source Feed Development (Linux, Python, Ellucian Ethos)
- SIS Updates, Releases, Testing, and Modernization (Banner)
- SIS Data Conversion and Migration (Banner)
Contributor:- Enterprise Applications Portfolio Strategy
- Enterprise Application Vendor Management
- Documentation Standards and Operational Continuity
- Enterprise Applications Data Governance and Stewardship Support
- Institutional Data Platform Administration and Technical Data Management (Current: EAB Edify)
- Data Integration and ETL/ELT Pipeline Development (Current: EAB Edify)
- Data Products and Extracts for Reporting and Analytics (Current: EAB Edify)
- Document Management Platform Administration, Access, and Retention (Xtender)
- Document Workflows and Integrations (Xtender)
- Document Management Updates, Releases, Testing, Modernization, and Migration (Xtender)
- SIS Add-On Applications Administration and Support (Degree Works)
- Forms Management and Workflow Processing (SoftDocs)
DISCLAIMER - This position description is only a summary of the typical functions of this seat, and not an exhaustive list of all responsibilities and areas of accountability. SECTION III - OUR DESIRES FOR RIGHT FITFor the success of our mission and our teams, we desire to have individuals who are a "Right Fit" in our seats. We define "Right Fit" as those who embrace our culture, demonstrate our values, understand the seat and what is required. We seek individuals who want this seat, desire to be a part of a bigger vision and have the capacity to be a successful member of our CMU team.
CAPACITY REQUIREMENTS- Advanced working knowledge of student information systems, student-system data architecture, integration patterns, database development, and downstream data-management practices.
- Capacity to understand student-system business processes and translate functional requirements into reliable application, database, integration, and data-management solutions.
- Advanced capacity with Banner technical architecture and Oracle SQL/PLSQL, including tables, views, indexes, packages, procedures, functions, triggers, and scheduled processes.
- Capacity to design data models, source-to-target mappings, canonical definitions, conversion rules, reconciliation controls, and lineage across SIS and data-lake environments.
- Capacity to develop and support integrations using Linux, Python, Ellucian Ethos, REST/SOAP services, JSON, XML, secure files, and related technologies.
- Capacity to work effectively across Banner/Oracle today and transition to future student platforms without tying durable responsibilities to a single database technology.
- Ability to partner closely with the Data Engineer, Institutional Research, functional data owners, and designated data stewards to resolve source, mapping, quality, and lineage issues.
- Ability to lead institutional release readiness for hosted enterprise applications, including release-note review, impact assessment, test planning, technical regression testing, functional UAT coordination, post-release validation, defect escalation, conversion, migration, and cutover activities.
- Commitment to cross-training, shared support, and reduction of single-person dependencies within a small Enterprise Applications team.
ESSENTIAL EXPERIENCE FOR RIGHT FIT- Bachelor's Degree in Computer Science, Information Systems, Software Engineering, Business Information Systems, or a related field from a regionally accredited four-year college or university, or an equivalent combination of education and experience may substitute for the degree on a year-for-year basis.
- Minimum four (4) years of experience supporting and developing solutions within Banner SIS or a comparable higher-education student information system.
- Minimum four (4) years of experience developing and supporting student-system integrations, batch processes, APIs, or related data exchanges.
- Minimum four (4) years of experience developing and supporting relational database solutions, in