Financial Aid System Administrator (Hybrid)

Job Responsibility: Regular/Temporary Regular Job Title Financial Aid System Administrator (Hybrid) Job ID 69571 Location Central Campus Open Date 05/23 Job Type Contractualy Limited =12 Close Date 06/01 Employee Group Unifor Unit 1, Staff Favorite Job Department Financial Support Salary Grade/Band Grade 8 Salary Range $28.90 - $43.51 (hourly) Contract Duration 12.4 Months Hours per Week 35 Posting Details Schedule 8:30 AM - 4:30 PM Education Level Bachelor's degree in a relevant field. Career Level 3 years of relevant experience.

Department Summary

The Office of the Registrar proudly supports McMaster University's academic mission through the creative, efficient provision of core administrative student services and the support of staff and faculty across all areas of the university community. Our work in supporting the student experience reaches from initial contact with prospective students through the celebrations of convocation. We are a smart, collaborative staff of over 100, spread across 9 departments: Student Services & Financial Support, Student Recruitment, Undergraduate Admissions, Records, Systems, Scheduling & Examinations, Student Communications and Central RO Administration.

The Financial Support department connects students with government financial aid, bursaries, work programs and scholarships. These resources help make post-secondary education more accessible and recognize students' academic, extracurricular and community achievements. We are currently recruiting a Financial Aid System Administrator.

General Description

Responsible for playing a key role in system administration and supporting both the centralized and decentralized financial aid activities of students, aid administrators, committee members and others, in the use of the Mosaic student online aid application and administrative components. Responsible for the creation of technical and user documentation for components, reports and batch processes. Also required to develop operational plans and schedules to ensure that all processing for all aid administrators is carried out in a way that ensures required standards and data integrity are maintained.

Representative Duties & Responsibilities

• Complete system rollover processes to set up new aid years.
• Accountable for the configuration and maintenance of delivered and customized configuration tables such as OSAP cost code tables, cost code pattern tables, USER table configuration, message text, translate values, early award categories and award values, checklists, comments, communications.
• Keep abreast of academic structure changes such as programs, plans, degrees, academic groups, subjects; new program/plan approvals; phasing out of programs/plans) and make necessary changes in system to ensure proper administration of aid programs/applications for students.
• Configure complex item types with strict adherence to coding structures and smart numbering as new sources of financial aid (e.g. trust funds, research, operating dollars) become available.
• Deactivate item types no longer in use.
• Generate, distribute and gather templates to collect fiscal balances for all sources of financial aid. Validate format/correctness/completeness of data and load to system on an annual basis to set fiscal spending limits.
• Set up and maintain the configuration required for scoring and ranking of award applications by Committee members.
• Develop and maintain online aid application controls and student fillable supporting documentation templates to ensure students have access to University-wide aid applications. Develop paper-based versions of all applications for students requiring additional accommodations.
• Create, validate and complete complex University and Government file loads and extracts using batch processes, templates, staging tables, validation reports, etc.
• Use queries, processes, and/or manipulation of spreadsheets to assist others with award and bursary aid assignment/allocations from operating and trust funds.
• Assist with work program administration by completing work program requisitions, student application approvals, work program hires, student status monitoring, end of work program processing and transfer of employer payroll subsidies.
• Develop and maintain an Excel template that collects aid administrator input and uses multiple formulas to calculate a standard need score for a student. The standard need score identifies a student's level of financial need and is used University-wide to ensure need-based aid is equitably distributed.
• Create technical/user documentation and develop operational plans and schedules to ensure that all processing for all aid administrators is carried out in a way that ensures standards and data integrity is maintained.
• Schedule and/or run batch jobs such as aid authorizations and disbursements; transcript notations; student communications, etc. Monitor the status of batch processes and follow up with aid administrators to advise of results. Take corrective action and/or direct appropriate corrective actions to remedy errors.
• Plan and co-ordinate a variety of events, such as workshops for financial aid administrators, user group meetings, training for committee members, system requirements gathering sessions and student focus groups.
• Provide technical advice and guidance to others. Train and support others on system functionality and business processes, both formally through presentations, demos, user group meetings and informally by telephone, email, one- on-one office visits.
• Liaise with UTS on systems-related issues. Create and maintain procedural and technical documentation for reporting, tracking, and troubleshooting financial aid system problems.
• Evaluate data query requests from aid administrators, assess feasibility and requirements to fulfill the requests. Plans and writes complex queries from multiple tables (with results generated in various formats), executes and validates query results. Promotes to public use as appropriate.
• Manage the security permission list and role authorization processes. Follow up with users to ensure security is granted/removed as expected.
• Track suggestions for system improvements from all users to ensure requests are evaluated, fleshed out, prioritized and logged.
• Understand complex business processes of aid administrators University-wide and identify barriers to successful use of financial aid components. Develop and implement best practices to support aid administrators and seek ways to improve system functionality, performance and efficiency to ensure it meets the business needs of the University community.
• Develop and conduct peer reviews of business requirements to ensure that user requirement specifications are correctly interpreted.
• Develop test cases and implementation plans for new/revised business processes and/or system enhancements/changes.
• Remain current with frequent updates and changes to relevant technology.
• Interpret and apply University and government policies.
• Evaluate student transcripts, student records data (e.g. program/plan/level/load), admission data (e.g. education source, grades), need score information and supporting documentation, appeal letters and award criteria to make decisions regarding a student's eligibility for merit awards and/or need-based aid.
• Ensure awards are processed and disbursed to student accounts prior to tuition deadlines.
• Manually enter award notations on student transcripts.
• Correspond and interact with students, parents, faculties and department offices. Respond to inquiries and provide information regarding award terms, eligibility criteria, application requirements, as well as financial aid policies, processes, and procedures.
• Independently troubleshoot issues raised by aid administrators and students. Determine the scope and severity of the issue and provide advice on how to resolve the problem. Escalate systems issues.
• Assist with government student aid processing during peak periods including keying of OSAP signature pages, reviewing student academic progress results, applying academic progress warnings/restrictions, completing OSAP drop units and withdrawals, updating OSAP applications as a result of changes identified on government aid status reports, etc.

Qualifications

• Bachelor's degree in a relevant field.
• 3 years of relevant experience.

Knowledge and Skills

• Communication (writing, presentation skills, emotional intelligence).
• Teamwork & collaboration (multiple teams/ audiences, project management, leadership).
• Analytical skills (problem solving, attention to detail).
• Technical skills (user tables, cost codes, excel, queries).
• Recommend system solutions.

Should the successful applicant be a Unifor Unit 1 bargaining unit member, who meets the eligibility conditions of Article 19.02 of the Unifor Unit 1 Collective Agreement, then the Limited Term Assignment will be defined as a Career Growth Opportunity in accordance with Article 19 of the Unifor Local 5555 Unit 1 Collective Agreement.

How To Apply

To apply for this job, please submit your application online.

Employment Equity Statement

McMaster University is located on the traditional territories of the Haudenosaunee and Mississauga Nations and within the lands protected by the “Dish With One Spoon” wampum agreement.

The diversity of our workforce is at the core of our innovation and creativity and strengthens our research and teaching excellence. In keeping with its Statement on Building an Inclusive Community with a Shared Purpose, McMaster University strives to embody the values of respect, collaboration and diversity, and has a strong commitment to employment equity.

The University seeks qualified candidates who share our commitment to equity and inclusion, who will contribute to the diversification of ideas and perspectives, and especially welcomes applications from indigenous (First Nations, Métis or Inuit) peoples, members of racialized communities, persons with disabilities, women, and persons who identify as 2SLGBTQ+.

As part of McMaster's commitment, all applicants are invited to complete a confidential Applicant Diversity Survey through the online application submission process. The Survey questionnaire requests voluntary self-identification in relation to equity-seeking groups that have historically faced and continue to face barriers in employment. Please refer to the Applicant Diversity Survey - Statement of Collection for additional information.

Job applicants requiring accommodation to participate in the hiring process should contact:

• Human Resources Service Centre at Voir le numéro de téléphone sur ca.edajobs.com-HR (22247), or
• Faculty of Health Sciences HR Office at ext. 22207, or
• School of Graduate Studies at ext. 23679

to communicate accommodation needs.

Hybrid Work Language

To ensure an ongoing and vibrant University community that meets the needs of our students, staff and faculty and supports the University mission, ability to work on-site continues to be a requirement for most University positions. The University is supportive of exploring flexible work arrangements that effectively balance operational needs and employee interests.