Senior Planning Analyst

Please refer to the How to Apply for a Job (for External Candidates)  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).

Position Summary:

Reporting to the Executive Director of the Analysis, Planning, and Budget (APB) unit in the Office of the Provost and Executive Vice-President (Academic) and working as a member of a team of analysts, the Senior Planning Analyst performs in-depth analysis of complex issues, articulates alternatives, synthesize findings and make recommendations to senior administration. Extracts and transforms internal and external data and produces visualizations and reports using data. Anticipates and responds to client needs, and independently drives issues to resolution. Trains, coaches and guides junior team members. Builds relationships both across the university and with external contacts.

Primary Responsibilities:

• Develop and maintain a sophisticated understanding of University operations and the higher education landscape in Quebec and Canada.
• Transform operational data (e.g., student, finance, HR, etc.) into ready-to-use accurate and consistent analytical datasets to be leveraged by APB. Includes development (data modelling), cleansing, validation, maintenance and enhancements.
• Identify and address data integrity/reliability issues and use data cleaning processes to achieve required data quality standards.
• Use external data from a variety of sources including Statistics Canada and U15, in combination with institutional data, to prepare analysis and reports that address institutional research questions.
• Work with large data sets to perform data mining and complete statistical analyses.
• Analyze trends and patterns in university performance over time using various benchmarks and comparative data.
• Conduct quantitative and qualitative analyses, working independently and with team members to maximize knowledge sharing on complex projects and topics.
• Work with stakeholders to understand their information needs and tailor the analyses to address those needs.
• Provide expert advice on university rankings. Maintain an up-to-date knowledge of university rankings and ratings methodologies and timelines.
• Contribute to data collection and validation for McGill’s KPIs and monitor performance.
• Prepare standard and customized reports and submissions for the Ministry of Higher Education, university ranking agencies (e.g., THE, QS, Macleans, etc.), U15 Data Exchange and Statistics Canada.
• Prepare briefing documents for senior administration and disseminate key results to senior management and internal communications.
• Fulfill reporting requirements accurately and in a timely manner.
• Cultivate relationships with peers and collaborators both inside and outside the university

Other Qualifying Skills and/or Abilities

Strong analytical background and project management skills; ability to transform data into recommendations. Capacity to find creative solutions and make independent decisions. Ability to work in a PC environment using databases, spreadsheets, statistical and visualization tools to produce analyses and reports. Advanced knowledge of Alteryx, Tableau, Excel, PowerPoint. Proven experience working in an environment where confidentiality is foremost. Ability to work autonomously and as part of a larger team and to build strong relationships with internal and external partners. Excellent communications skills. Excellent consultative and collaborative skills, showing tact and diplomacy with clients at all levels. Excellent organizational skills and professional conduct. English and French (spoken and written).

“Knowledge of French and 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 #3 on a scale of 0-4.”

Minimum Education and Experience:

Bachelor's Degree 5 Years Related Experience /

Annual Salary:

(MPEX Grade 07) $87,090.00 - $108,860.00 - $130,630.00

Hours per Week:

33.75 (Full time)

Supervisor:

Executive Director (Analysis, Planning & Budget)

Position End Date (If applicable):

Deadline to Apply:

2024-05-24

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, [email protected] .