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 robust 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 usi

📌 Advancement Analyst (Montreal)
🏢 McGill University
📍 Montreal