Business Intelligence Officer (MR1140) McGill University Human Resources Canada

Business Intelligence Officer (MR1140)




McGill University - Human Resources


Position Title:

Business Intelligence Officer (COM2C)

Position Summary:


Under the general direction of the Director, Annual Giving & Business Intelligence, the Business Intelligence Officer 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 Officer 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


    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


    Develop and maintain a robust information sharing program through intranet platform

    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.


Minimum Education & Experience:


Undergraduate degree


Three (3) years' related experience

Other Qualifying Skills And/Or 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. 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. English (spoken and written), French (spoken and read).

Reference Number:


Reporting To:

Director, Annual Giving and BI

Salary Range:

(Grade 04) $50,800 - $63,500 (midpoint) $82,600


University Advancement

Position Type:


Hours Per Week:


How To Apply:


Please submit your cover letter and curriculum vitae, clearly indicating the reference number, to University Advancement at


The deadline to apply for this position is May 24, 2019 at 5:00 PM.


*Current employees: please indicate your McGill ID number in your application.*


We thank all applicants for their interest in McGill University. However, University Advancement will only contact applicants selected for an interview.

McGill applicants, covered by the McGill Non-Unionized, Non-Academic Personnel Policies and Procedures, must apply to a regular M and Excluded position within ten (10) working days of the date of publication to maintain internal priority.

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, Professor Angela Campbell, Associate Provost (Equity and Academic Policies) at or 514-398-1660.

If you apply for this position please say you saw it on Adminoxy


All Jobs


Harvard University Academic Positions

Kuwait University Current Faculty Openings

Osaka University Academic Opportunities

Purdue University Job Postings for Faculty Positions

Texas Tech University Faculty Openings

Tsinghua University Job Postings

University of Cambridge Job Openings

University of Geneva Faculty Opportunities

University of New South Wales Job Openings

University of Nottingham Research Positions

University of Oslo Academic Jobs

University of Saskatchewan Faculty Positions

University of Southampton Research Vacancies

University of Tokyo Current Academic Vacancies

University of Toronto Open Faculty Positions