Advancement Analyst

Position Summary:
The Advancement Analyst provides support to University Advancement (UA), namely in areas related to performance tracking, value for money analyses, benchmarking, trend monitoring cross-departmental analytics initiatives and governance reporting. They collaborate with team members to support strategic planning and decision-making for UA's Senior Management Team.Primary Responsibilities:
Collaborate with team members to conduct and present high-level trend analyses, financial projections, value-for-money assessments, and performance reporting, including data mining, forecasting, benchmarking, and analysis of trends and patterns to support strategic planning and decision-making for UA's Senior Management Team. Actively seek and collect industry and benchmarking data that support the business processes/outcomes of McGill University’s fundraising efforts. Play an active role in Key Performance Indicators development and monitoring. Participate in the drafting of comprehensive review reporting of UA key results including related management discussion and analysis. Write, design, and present project reports, executive summaries on range of philanthropic issues, with particular focus on analytics, key performance indicators (KPIs) and emerging trends. Ensure timely delivery and provide accompanying analyses. Collaborate cross-functionally to enhance reporting tools and data structures for improved insight generation. Assist with the development of self-service analytics tools, using namely Power BI and Salesforce reporting features. Use analytical techniques to process large volume of data from multiple sources into actionable opportunities, including data analysis and interpretation. Utilize best-in-class data visualization tools to assist other departments in understanding and representing key information. Participate in statistical modeling, analysis and reporting to determine and optimize alignment of resources with the strategic plan, including, data mining, predictive modeling, forecasting and statistical analysis to identify trends and patterns. Effectively translate business questions into analytical solutions, ensure data integrity by investigating anomalies in reported numbers from a variety of sources. Assist in the development of data visualization, dashboard and reporting capabilities to enable more effective strategic, tactical, and operational insights and decision‑making. Conduct sophisticated ad‑hoc query data retrievals;
provide analysis of data extracts as required. Ensure data integrity by investigating anomalies in reported numbers from a variety of sources throughout Advancement. Participate in the development of standards, as led by various Units, in regards to data collection both from internal and external sources. Participate in University Advancement’s Analytics Centre of Excellence with the aim of creating synergies and best‑practices in analytics across University Advancement. Keep abreast of technology trends and new BI tools.Other Qualifying Skills and Abilities:
Bachelor’s degree in a pertinent field, Bachelor of Commerce an asset. Strategic and proactive business minded thinker, with proven expertise in business analysis. Ability to understand business needs formulated by senior management and other internal clients and translate them into actionable analysis and information. Proven experience translating business requirements into reporting specifications, data requirements and actionable insights. Ability to write and design reports and produce and deliver informative, well organized presentations. Strong interpersonal skills and the ability to work collaboratively across all levels of the organization. Must be able to communicate effectively and confidently with internal clients. Demonstrated effective communication, writing and presentation skills, with the ability to present findings. Experience facilitating meetings and proven experience at driving consensus across multiple stakeholders. Creative, well organized and self‑motivated, with strong analytical, planning and problem solving skills. Able to collect, interpret and synthesize data sets from various sources. High-level of accuracy and attention to detail. Conscientious and thorough, with a concern for the quality of deliverables. Proven experience performing detailed work. Demonstrated ability to effectively manage multiple analyses / projects in a timely manner and prioritize work. Is organized, autonomous, and able to meet strict deadlines. Demonstrated understanding of a variety of different modelling techniques with knowledge of data extraction and manipulation. Knowledge of and experience in building various statistical and machine learning models is an asset. Knowledge of cutting‑edge/emerging technologies as they relate to business needs is an asset. Strong SQL skills and experience analyzing data from multiple sources. Experience developing reports and dashboards using enterprise analytics and visualization tools (PowerBi, Python, R, Excel, Salesforce reporting). Demonstrated ability to understand data models and enterprise data environments.As one of Montreal's Top Employers, here is what we offer:
Competitive benefits package (Health, Dental, Life Insurance)Defined contribution pension plan (with employer contribution up to 10%)Group Registered Retirement Savings Plan (RRSP) and Tax Free Savings Account (TFSA)Competitive vacation policyTwo (2) personal daysTwo (2) floating holidaysNine (9) "Summer Fridays" - paid days off between the St-Jean Baptiste holiday and Labour DayPaid time off over the December holiday periodTuition waiver for regular employees and their dependentsUp to two (2) days of remote work per week where the position permitsTo 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.Minimum Education and Experience:
Bachelor's Degree3 Years Related Experience / Annual Salary: (MPEX Grade 05) $73,470.00 - $91,840.00 - $110,210.00Job Profile:
MPEX-COM2C - Development & Alumni Relations - Professional 2Hours per Week: 33.75 (Full time)Supervisor: Executive Director (Advancement Operations)Position End Date (If applicable):Deadline to Apply: 2026-11-05McGill 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, View email address on ca.hrm.tc in one of the world’s great multicultural and multilingual cities, McGill University is internationally recognized for its excellence as a leading institution of higher education and research. For nearly 200 years, through the work of dedicated people, McGill has been breaking ground in diverse fields and contributing solutions to some of the world’s most significant issues. McGillians are proud to be part of a community that is both global and local, inspired by challenge and committed to shaping a better future. McGill received a Platinum STARS rating in sustainability, is among Canada’s greenest employers, and is a top Montreal Employer. Grandescunt Aucta Labore. By work, all things increase and grow. Find a sense of purpose. Develop your future. Join us today.
#J-18808-Ljbffr