Job Description

Please refer to the job aid for instructions on how to apply.
If you are an active McGill employee (ie: currently in an active contract or position at McGill University), do not apply through this Career Site. Login to your McGill Workday account and apply to this posting using the Find Jobs report (type Find Jobs in the search bar).
Hiring Unit:
Desautels IT
Position Summary:
The Data Workflow Assistant will help streamline and simplify the faculty merit process. The student will build a reliable data pipeline that consolidates inputs from multiple sources, applies scoring logic defined with the merit committee, and presents results for committee review and final reporting to the Dean and Academic Affairs. The work will emphasize accuracy, usability, and sustainability so that future cycles require minimal manual effort and no ongoing student involvement.
Key Responsibilities

• Map the end to end workflow with committee chairs for Teaching, Research, and Service, and document pain points and decision points.
• Consolidate, clean, and validate data from CSV and Excel files into a structured and reusable format.
• Implement repeatable automation for data intake, validation, transformation, and scoring using Excel, Power Query, and Python as appropriate.
• Build a secure and intuitive review experience for committee members using Power BI dashboards.
• Enable entry of final committee decisions and comments through a controlled input method such as a SharePoint list, a protected Excel Online form, or a simple Power App.
• Produce exports that align with the format required by Academic Affairs for entry into Workday.
• Create clear documentation, data dictionaries, and quick reference guides for users and administrators.
• Pilot the solution with a sample cycle, collect feedback, and incorporate improvements.
• Respect confidentiality and privacy at all times.

Students will need to sign an NDA to ensure confidentiality
Other Qualifying Skills and/or Abilities
Required:

• Current undergraduate or graduate student in Information Systems, Analytics, Computer Science, or a related field.
• Strong proficiency in Excel including functions, lookups, data cleanup, and Power Query.
• Experience with data preparation and transformation using Python, SQL or R.
• Ability to design effective visuals in Power BI.
• Strong communication skills and the ability to collaborate with faculty, IT, and administrative staff.
• Demonstrated attention to detail and commitment to data quality and reproducibility.

Preferred:

• Experience with Power Automate for workflow orchestration.
• Familiarity with SharePoint, OneDrive, and Microsoft Teams for secure collaboration.
• Experience documenting processes, writing user guides, and creating handover materials.
• Exposure to academic data, assessment rubrics, or similar scoring workflows.

Before applying, please note that to work at McGill University, you must be both authorized to work in Canada and willing to work in the province of Quebec at the campus where the position is based / located.
Knowledge of English: McGill University is an English-language university where day to day duties may require English communication both verbally and in writing. The level of English required for this position has been assessed at a level # (qualifier) on a scale of 0-4.
For a definition of our language proficiency levels, please click .
Minimum Education and Experience: High School Diploma 2 Years Related Experience
Hourly Salary: (AMUSE C) $23.00
Estimated Number of Work Hours per Week: 10 (Part time)
Position Start Date: 2025-10-20
Position End Date: 2026-03-31
Deadline to Apply: 2025-10-15
This position is covered by the AMUSE collective agreement.
McGill University hires on the basis of merit and is strongly committed to equity and diversity within its community. We welcome applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to productively engage with diverse communities. McGill implements an employment equity program and encourages members of designated groups to self-identify. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, .

Skills Required