Business Intelligence Analyst

McGill University

jobsincanada.one

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, exciting and growing 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:

Under the general direction of the Director, Annual Giving & Business Intelligence, the Business Intelligence Analyst is responsible for statistical modeling exercises that allow for the prioritization of activities across University Advancement in addition to providing analyses on alumni and regional data, validating data selection for reports, and serving as cross-check for data use within University Advancement. As such, the incumbent would liaise with internal clients, including Systems, Annual Giving, Prospecting and Pipeline Management, Development Officers as well as other units within University Advancement. The Business Intelligence Analyst would also be responsible for handling data requests, maintaining data integrity on platforms and assisting other departments with technology integration.

Primary Responsibilities:

Analytics Program

  • Work with the Business Intelligence team to implement and oversee a comprehensive analytics program, to support the strategic information needs of University Advancement and its various Units.

  • Participate in the creation of a variety of data models that would assist various departments across University Advancement in lead generation and prioritization/identification of prospects or workflow.

  • Participate in statistical modeling, analysis and reporting to determine and optimize alignment of resources with the strategic plan, including constituent research, data mining, predictive modeling, forecasting and statistical analysis to identify trends and patterns in giving, volunteerism, event participation, alumni and donor behaviour, etc.;

  • Participate in the development of standards, as led by various Units, in regards to data collection both from internal and external sources

  • Ensure data integrity by investigating anomalies in reported numbers from a variety of sources throughout Advancement

  • Work with IT and Systems to ensure reporting standards are adhered to across different departments and units where information is shared.

  • Write and design project reports, executive summaries and white-papers on range of philanthropic issues, with particular focus on analytics, key performance indicators (KPIs) and emerging trends.

  • Play an active role in Key Performance Indicators development and monitoring, as led by the Unit – including developing reporting tools, reviewing existing data structures and researching emerging trends.

Statistical Analysis and Reporting Home

  • Work with Director, Annual Giving & Business Intelligence to report and present high level trend analyses, financial projections and data-insight in support of strategic planning for the Senior Management Team.

  • Ensure data integrity by investigating anomalies in reported numbers from a variety of sources throughout University Advancement.

  • Use analytical techniques to process large volume of data from multiple sources into actionable opportunities.

  • Conduct sophisticated ad hoc query data retrievals; provide analysis of data extracts as required.

  • Assist in the development of data visualization methods and reporting capabilities to enable more effective strategic, tactical, and operational insights and decision-making.

Other Responsibilities

  • Utilize best-in-class data visualization tools to assist other departments in understanding and representing key information.

  • Keep abreast of technology trends and new BI tools, as well as researching, testing and presenting solutions for integration into existing processes.

  • Actively seek and collect industry and benchmarking data that support the business processes/outcomes of McGill University’s fundraising efforts.

Other Qualifying Skills/Abilities:

  • Previous business intelligence experience in a non-profit fundraising environment.

  • 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 data requirements. Ability to write and design reports and produce and deliver informative, well organized presentations.

  • Must be able to communicate effectively and confidently with internal clients at all levels within the organization.

  • Knowledge in data extraction and manipulation

  • Technical experience with analysis and visualization tools (e.g. Excel, Power BI, Tableau, R, Python, …)

  • Demonstrated effective communication, writing and presentation skills.

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

  • Demonstrated ability to manage multiple projects and meet strict deadlines.

  • Knowledge of cutting-edge/emerging technologies as they relate to business needs is an asset.

  • Knowledge of and experience in building various statistical models.

  • Understanding of a variety of different modelling techniques including regression, RFM analysis, cross-tabulation, pivot table analysis, etc.

  • 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

Additional Information:

Testing may be administered.

Minimum Education and Experience:

Bachelor’s Degree 3 Years Related Experience /

Annual Salary:

(MPEX Grade 05) $65,500.00 – $81,870.00 – $98,240.00

Hours per Week:

33.75 (Full time)

Supervisor:

Executive Director (Advancement Operations)

Position End Date (If applicable):

Deadline to Apply:

2022-12-06

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

View or Apply
To help us track our recruitment effort, please indicate in your cover//motivation letter where (jobsincanada.one) you saw this job posting.

Leave a Reply