Advancement 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).

University Advancement (UA) promotes McGill to its global community and to the public, engaging alumni, volunteers and friends of the University, and building on McGill’s record of fundraising success in support of University priorities.

By joining UA, you can be part of a dynamic and exciting team of professionals that is making an extraordinary impact on the world by advancing the philanthropic and engagement ambitions of McGill University.

To find out more about UA, please visit us at www.mcgill.ca/advancement/ua-careers .

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 policy
• Two (2) personal days
• Two (2) floating holidays
• Nine (9) "Summer Fridays" - paid days off between the St-Jean Baptiste holiday and Labour Day
• Paid time off over the December holiday period
• Tuition waiver for regular employees and their dependents
• Up to two (2) days of remote work per week where the position permits

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 # 3 on a scale of 0-4.

For a definition of our language proficiency levels, please clickhere.

Minimum Education and Experience:

Annual Salary:

Job Profile:

Hours per Week:

Supervisor:

Position End Date (If applicable):

Deadline to Apply:

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].