Senior Student Systems and Data Management Developer
Job Description
Colorado Mesa University is seeking a Senior Student Systems and Data Management Developer to serve as the University’s primary technical resource for the Student Information System (SIS), student-system integrations, and student data architecture and management. This role focuses on reliable Banner operations on Oracle today while building durable student-data capabilities that can support future SIS platforms. The position is onsite in Grand Junction, Colorado and operates without supervisory responsibilities.
Role summary
In this seat, you will maintain and evolve student systems, including Banner (Oracle-hosted) and its integrations, while owning SIS technical operations and development. You will lead technical participation across releases, testing, modernization, conversion, migration, and stabilization, and coordinate technical work with internal partners and vendors to deliver student data that is complete, timely, traceable, and reconciled to agreed source-system controls.
Responsibilities
- Own and maintain technical operations, development, configuration, integrations, security dependencies, releases, and lifecycle of the University’s SIS (current: Banner).
- Design and maintain student-system data structures, logical and physical data models, database objects, and source-to-target mappings, including data definitions, history requirements, and reconciliation controls from the SIS through Edify and downstream data products.
- Develop and support integrations using APIs, Ellucian Ethos, SQL/PLSQL, Linux scripting, Python, scheduled processes, secure file exchange, JSON, XML, and related technologies.
- Partner with the Data Engineer to build and maintain SIS-to-Edify feeds, trace data-quality issues to their sources, implement approved corrections, and keep student data consistent across operational and analytical platforms.
- Lead 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 UAT, validating production after Ellucian implementation, tracking defects, and escalating issues.
- Lead modernization, conversion, migration, cutover, and reconciliation and stabilization for future SIS platforms.
- Coordinate 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.
- Maintain accurate technical and operational documentation for assigned applications, integrations, configurations, procedures, and support responsibilities to support operational continuity, cross-training, and backup coverage.
- Own application-owner responsibilities including release-note and advisory review, institutional impact assessment, identification of affected integrations and business processes, coordination of technical regression testing and functional UAT, post-release validation, defect tracking, and escalation to Ellucian.
- Own day-to-day Banner technical operations, student-system database and application development, SIS integrations and outbound data feeds, and student data conversion and migration.
- Coordinate technical activities with Ellucian, Oracle, EAB, Workday, implementation partners, consultants, and third-party service providers.
- Support owned outcomes including completion of SIS updates, releases, testing, modernization, conversion, and migration milestones on approved priorities and committed timelines; meeting service expectations for critical SIS operations, integrations, scheduled processes, and data feeds; and ensuring Edify delivery meets completeness, timeliness, traceability, and reconciliation requirements.
- Maintain SIS (Banner), including SIS database and source data model development (current: Banner/Oracle), SIS integration and data lake source feed development (Linux, Python, Ellucian Ethos), SIS updates/releases/testing/modernization (Banner), and SIS data conversion and migration (Banner).
Required qualifications
- Advanced working knowledge of student information systems, student-system data architecture, integration patterns, database development, and downstream data-management practices.
- Advanced 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.
- Ability to work across Banner/Oracle today while transitioning 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.
- Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, Business Information Systems, or a related field (or an equivalent combination of education and experience may substitute year-for-year).
- 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, including advanced SQL and stored-programming capabilities (current Oracle SQL/PLSQL experience is strongly relevant).
- Experience with Linux scripting, Python, REST APIs, JSON, XML, and enterprise integration troubleshooting.
- Experience developing data models, source-to-target mappings, data conversion rules, reconciliation processes, and technical documentation.
- Experience supporting higher-education student business processes with functional stakeholders to gather requirements, review vendor release impacts, coordinate testing, and validate solutions.
- Ability to read and interpret technical documentation, professional materials, vendor documentation, procedures, and applicable regulations.
- Ability to write clear technical documentation, reports, requirements, test plans, support procedures, and presentations.
- Ability to explain complex technical information to functional users, technical staff, leaders, vendors, and implementation partners.
- Strong analytical and systems-thinking skills.
- Visa sponsorship is not available; applicants must be legally authorized to work in the United States at the time of hire and for the duration of employment without employer sponsorship.
- Employment is contingent upon maintaining valid work authorization for the expected duration of the position.
Technology and environment
- Current environment: Banner running on Oracle, hosted by Ellucian.
- Ellucian performs operating-system, database-engine, and application-layer patch installation for hosted services.
- Technology: Banner, Oracle, Oracle SQL/PLSQL, Linux, Python, Ellucian Ethos, Ellucian Student, REST APIs, REST, SOAP, JSON, XML, PostgreSQL, Workday Student, WQL, Git.
- The role also supports institutional data platforms including EAB Edify.
- Preferred experience includes: Ellucian Ethos, EAB Edify, PostgreSQL, Workday Student, WQL, Ellucian Student, SIS modernization, data conversion, data governance/stewardship support, Git or source control, and cross-platform integration architecture.
Compensation and benefits
- Salary: $80,000 - $90,000 per year, commensurate with education and experience.
- Excellent health and retirement benefits package.
- FLSA status: Exempt.
Work location and physical demands
- Location: Grand Junction, CO, onsite.
- Work environment is predominantly in-person in an office setting with extensive computer use.
- Occasional work outside regular hours may be required for upgrades, releases, production issues, testing, or implementation activities.
- Physical demands include frequent sitting, standing, walking, talking, hearing, and use of a computer, and occasional lifting or moving up to 10 pounds.
How to apply
Applicants will complete an online application by creating a profile and providing personal and demographic information. Upload a cover letter, resume, and copies of transcripts for all degrees completed (redact social security number or birthdate if included in transcripts). Official transcripts will be required upon hire.