Financial Assistance Systems and Data Analyst (App. D/Temp.: Nov. 2025 - Dec. 2026)

Status: Appendix D/Temporary Assignment (November 2025 – December 2026)

Hours: Monday – Friday, 35 hours/week

Home Campus: Fennell (hybrid work arrangements available)

Rate of Pay: Payband H (Start Rate: $36.29 per hour, plus 8% in lieu of vacation and benefits)

Posting Date: October 23rd, 2025

Closing Date: October 29th, 2025 at 7:00 pm EST

We believe the rich diversity among our students and the communities we serve should be reflected within our workforce. As educators, we believe it is important to act and show leadership in advancing the principles of reconciliation, equity, diversity, and inclusion in our community.

Reporting to the Manager, Financial Assistance, the Financial Assistance Systems and Data Analyst is a key member of the Financial Assistance Department and is responsible for providing technical, business and operational support in delivering Financial Assistance to our students, as well as ensuring effective organization of departmental activities.

The incumbent recommends and supports the planning, evaluation and continuous improvement of Financial Assistance services, systems and functions. Development, execution and maintenance of system enhancement strategies are key duties for the incumbent in supporting department operations.

The incumbent provides the technical expertise to administer Financial Assistance student supports offered by the Ministry and through the College initiatives, including functionality of our Banner Student Aid system; supporting administration of the Ministry’s Ontario Student Assistance Program (OSAP); performing data analysis utilizing the OSAP data files in conjunction with College records; updating and maintaining the Students with Permanent Disabilities Tuition Reduction system; reconciling and validating students’ data and records; and preparing statistical reports.

What you’ll be doing:

Financial Assistance – Banner and OSAP

• Responsible for the annual set-up and maintenance of Banner functionality as needed for Financial Assistance operations, as well as ongoing maintenance and updates through the year.
• Responsible for ensuring the integration of the Ontario Student Assistance Program (OSAP) file transmissions into the Banner Student Aid module by performing a series of recurring operations to transfer and process data received through the OSAP file transmission.
• Ensures efficiency in developing and maintaining a calendar of business cycle events to ensure all activities including, but not limited to, set-ups, system rolls and uploads, processes, system upgrades, and internal and external hard and soft communications occur on time, in the proper order and with absolute accuracy according to the business cycles of all concurrent terms.
• Provides Financial Assistance and Awards reports and statistics to management for decision-making and reporting at the senior level.
• Works closely with the Manager, Financial Assistance, Awards Officer and Financial Assistance Advisors to apprise them of system issues, communicates statuses, as well as addressing specific questions with respect to systems, reporting and student records.

Proactive Monitoring & Quality Control

Provides technical support to the Financial Assistance Office including:

• Analyzes needs and specifications to develop various reports for the department or related departments.
• Analyzes data and business process mappings to identify gaps or changes that need to be addressed across the academic year and document the solutions.
• Acts as a team member on various system projects targeted at improving efficiency.

Provides quality control, subject matter expertise and system support and ensures protocols, procedures, guidelines and timelines are followed, including:

• Coordinates all activity related and not limited to BSA by assigning access levels, troubleshooting, monitoring the site and logging enhancement requests.
• Prepares test scripts and performs validation tests for and not limited to BSA after upgrades are made and follows through on necessary corrections.
• Troubleshoots problems that arise.
• Analyzes data to determine student application trends, and benchmarks application data against current and previous submissions.
• Provides systems support and administration for applications tied to Confirmation or Enrollment and student Registration attributes.
• Troubleshoots technical support for OSAP-related process to the access and functionality of any of our applications: Cost Codes, email mailing lists, FAQs, webpage information, and other communication and outreach used by the department.
• Escalates as necessary to IT, ministry and other support teams.
• Monitors and maintains all aspects of our system processes to ensure functionality and performance is optimized.
• Acts as a central resource for Financial Assistance OSAP application issues, trends and reporting by interacting with stakeholders, Office of the Registrar staff and subject matter experts to understand their needs and requirements.
• Creates and runs reports to proactively find trends, anomalies and opportunities.
• Closely monitors the deferral attribute process on a regular basis and is the point person for any errors or anomalies that are flagged by staff during day-to-day activities.

Responsible for the ‘Tuition Fee Policy’ (TFP) process:

• Communicates with students and staff on timelines and responses to inquiries.
• Tracks students and inputs information into the Ministry database.
• Reconciles the database, with assistance from Finance staff, and updates the students’ status to ensure compliance with Ministry guidelines after every add/drop period, grading and promotion period and in January for year-end Ministry reporting.
• Notifies Accounting staff of necessary adjustments to students’ fee accounts and updates the students' OSAP files in the Ministry system.
• Tracks program changes from the Ministry, and keeps appropriate parties updated.
• Prepares annual report for the Ministry.

Contributes to the Administration and Operations of the Department

• Maintaining an annual timeline calendar for the Financial Assistance Department by updating the calendar with important dates, including semester start timelines, Ministry reporting due dates, etc.
• Following up with the appropriate team member(s) to ensure deadlines are met related to Ministry reporting, year-end reporting, and T4A requirements.
• Reviews, analyses and identifies students for mass communication (i.e. OSAP account restricted, documentation outstanding, no OSAP application on file, incorrect application submitted based on course load).
• Regularly monitors and updates departmental website.
• Prepares, submits and updates annual OSAP Cost Codes by validating information and entering the details on the Ministry’s dashboard to meet deadlines.
• Downloads Ministry files for populating our systems and correcting errors on the appropriate system.
• Assists with updates to internal and Ministry reports on Tuition Set Aside as requested.

Review and Analyze OSAP and Banner Data

• Download all required data files from MCU daily (Net-Cost file, Full-Time YTD, Part-Time YTD, Micro-credential YTD) as needed/requested by Manager, Financial Assistance.
• Audit and correct errors and omissions on student applications where possible.
• Identify students requiring Financial Assistance Advisor intervention and share with the appropriate individuals.
• Prepare reports of all applicants with outstanding OSAP documentation, or other issues affecting funding.
• Audit student enrolment (as per OSAP rules and regulations) and submit “confirmation-of-enrolment” report to the MCU on a daily basis.
• Reviews student grades at the end of each term, and prepares and uploads a report of any students that have not achieved “academic success” as defined in the OSAP rules and regulations.
• Assists with updates to internal and Ministry reports on Tuition Set Aside as requested.

System Enhancements and User Support

• Supporting development of seamless integration of OSAP data and information from the Ministry website to Banner.
• Developing and maintaining documentation for users.
• Proactively evaluating business processes and ongoing system opportunities to determine efficiencies.
• Assisting in the semi-annual review of departmental systems/process and data analysis to identify areas for improvement, i.e. refund process, disbursing Tuition Set Aside funds, etc.
• Researching best practices via the OASFAA forums and websites, and works with staff to determine logistics for implementing changes.
• Supporting Awards Officer with process and improvement strategies, as required.
• Investigating problems and creating innovative electronic solutions.
• Training staff on new screens/processes and updates to software.

Other duties as assigned.

What you’ll bring to the role:

• Minimum three-year post-secondary education in Business, Administration, Finance, Computer Science or related field
• Minimum three years of related work experience, preferably in a post-secondary environment, working with software applications and databases.
• Well-defined communication skills to articulate technical problems and solutions.
• Ability to work in Banner and become knowledgeable with upgrades, patches and versions that are implemented regularly.
• Knowledge and experience with project management.
• Demonstrated experience working with Ministry systems – Students with Disabilities Database, Bursary Reporting System, and OSAP System is required at the point of hire.
• Programming (SQL) experience.
• The incumbent must have proven technical skills with computer applications and high functioning level of MS Access and MS Excel computer software programs. Experience with interrogating databases is key.
• In depth knowledge of Banner forms and tables.
• Demonstrated commitment and understanding of human rights, equity, diversity, inclusion, and accessibility.
• The ability to communicate and work effectively with diverse students, employees, and communities.

What we offer:

• Opportunity to gain experience and build relationships at a Hamilton/Niagara Top Employer.
• Access to professional development opportunities.
• Option to enroll in Defined Benefit pension plan (CAAT) with contributions matched by Mohawk College.
• Discounted rate for full-service athletic facility and instructor-led classes.
• Opportunities to engage in wellness events and activities.

To find out more about working at Mohawk College, including our Employee Value Proposition, please visit https://www.mohawkcollege.ca/about-mohawk/careers-at-mohawk

We are committed to reconciliation and nurturing an inclusive, diverse, equitable, and accessible (IDEA) environment for everyone who learns and works at Mohawk College. We welcome applications from racialized persons, women, Indigenous people, persons with disabilities, 2SLGBTQIA+ persons, and others who may contribute to the further diversification of ideas.

The College is committed to fostering inclusive and barrier-free recruitment and selection processes. If you require accommodation during any stage of the recruitment process, please contact Human Resources.

To learn more about Mohawk College’s commitments, please visit the Mohawk College strategic plan webpage: https://www.strategicplan.mohawkcollege.ca/