Strata Information Group (SIG)
Banner Technical Consultant (Financial Aid Module)
Strata Information Group (SIG) Solves Problems. We are a team of dedicated professionals deeply committed to excellence and innovation. SIG has been a trusted partner to over 1,000 higher education institutions globally since our inception in 1988. Our solution sets include Strategy & Optimization Consulting, Enterprise Applications Implementation and Managed Services, Data Services, and Cybersecurity.
SIG values client satisfaction, integrity, and expertise in higher education. We embrace diversity, collaboration, and personal growth in our inclusive environment.
Position Summary
Are you passionate about leveraging technology to enhance educational institutions? Do you thrive on solving complex challenges within the higher education landscape? This may be your perfect opportunity to join our innovative team as an Ellucian Banner Technical/Financial Aid Consultant. We are seeking a passionate and experienced Ellucian Banner Technical Consultant with a Financial Aid focus to support the technical configurations, integrations, and coding requirements for the Banner Financial Aid module. This full-time position offers a chance to make a significant impact by enhancing the efficiency and effectiveness of financial aid operations in higher education institutions.
Consulting & Implementation
- Collaborate with clients to implement and integrate the Ellucian Banner software suite and related applications, ensuring seamless functionality.
- Provide expert guidance on Banner Financial Aid setup, configuration, and optimization.
Technical Development & Configuration
- Design, develop, and optimize Oracle SQL and PL/SQL scripts for Banner Financial Aid rules.
- Configure and troubleshoot Banner pages, jobs, and functions to support financial aid operations.
- Manage security access requests and permissions for Banner Financial Aid pages.
- Set up and execute the New Year Roll process for financial aid systems.
Automation & Reporting
- Develop custom popsels and batch posting processes (e.g., RORPOST/RORBPST).
- Create and refine Oracle SQL queries for Banner rules, including:
- RORRULES (tracking, fund disbursement, awarding, packaging, SAP, budgets)
- RBRABRC (algorithmic budgeting)
- RORALGO (general algorithmic processing)
- RPRALGR (algorithmic packaging)
- Build enterprise reporting solutions (e.g., Evisions Argos) with dashboards, automated emails, and data processing tools.
- Maintain BDM tracking updates and automate document imaging processes using VBScript/PowerShell.
Job Scheduling & Automation
- Develop and maintain job scheduling workflows (e.g., Automic/UC4) for:
- Data loads, batch postings, letter generation, automated downloads
- File transfers to the Department of Education and state agencies
- Develop and troubleshoot Linux shell scripts for scheduled processes.
Testing & Compliance
- Test Banner updates, patches, and state-delivered modifications to ensure system stability.
- Develop SQL queries for institutional research, ad hoc reporting, and compliance reporting (IPEDS, NPSAS, HEERF, etc.).
Training & Support
- Troubleshoot end-user issues related to Banner pages, jobs, and functions.
- Train users on Banner Financial Aid system functionality and best practices.
Required Qualifications
- Previous Higher Ed Work Experience: 5+ years supporting Banner functionality within the Financial Aid Department of a higher education institution.
- Consulting and Training Experience: Ability to deliver high-quality client service, create strategies and train users on the Banner system.
- SQL & PL/SQL Programming: Develop and optimize queries, procedures, and scripts for Ellucian Banner Financial Aid.
- Reporting Experience: Expertise in Envisions Argos to design, develop, and maintain reports, dashboards, and automated workflows.
- Document Management: Experience implementing and supporting Banner Document Management or other imaging systems.
- Automation Tools: Experience automating batch processes with Automic Applications Manager (UC4) or similar software.
- Self-Management: The ability to manage multiple projects independently and solve problems effectively.
- Communication Skills: Excellent written and verbal communication skills with a strong customer service approach.
- Team Collaboration: A strong desire to learn, collaborate, and innovate with team members and clients.
- Flexibility: The ability to travel as needed.
Pay and Benefits
- The salary range is $90,000 -$120,000 plus bonus
- Health, Vision, Dental & Life Insurance
- Short & Long Term Disability
- Paid Parental Leave
- 3 Weeks Vacation, Sick Leave & Paid Holidays
- 401(K) with a 5% Employer Contribution
- Pet Insurance
The listed salary range for this position is indicative and subject to adjustment based on the candidate's unique skills and location. Final compensation will be determined through mutual agreement between the successful candidate and SIG.
SIG is an Equal Employment Opportunity
California Consumer Privacy Act Notice
Top Skills
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
