McGill University

Senior BI Analyst (JR0000015787)

  • Temporary

***This position is a 1 year term***

Develop new and innovative business intelligence solutions. Document BI needs and evaluate project opportunities, liaise between the end users, the business SMEs and the BI project team, gain consensus and approvals on the produced documents and recommend appropriate scope and priorities, seek innovations to develop business understanding and insight across the business, produce some dashboards and lead all UAT activities.  Also, will ensure that the BI system meets the current and future needs of the stakeholders and users community.

Duties and Responsibilities:

• Work with the business stakeholders from the time a business need is identified to evaluate the BI opportunity.

• Responsible for validate BI-related business requirements, develop and plan, including functional, non-functional, dashboards/reports, training, service levels, and performance requirements, from business stakeholders via various mediums such as interviews, surveys, user workshops, product / prototype demos and others.

• Manage communication among team across multiple units and maintain relationship with the business users.

• Promote the value of the BI in the University.

• Provide training to the team and clients on BI information availability.

• Conduct interviews and workshops to determine the business entities definitions and relations across many stakeholders (university wide). Provide expertise in preparation of contracts.

• Conceive prototypes and dashboards/reports/score cards using the BI Power User tools (front-end).

• Lead the maintenance of the data dictionary

• Maintain the BI Catalog

• Identification of the BI data sources with the users

• Consulting role regarding the cubes models

• Develop test strategy, plan and scenarios and conduct functional testing to ensure programming / configuration has been done in accordance with functional specifications and business requirements.

• Ensure the cubes, reports, and dashboards present timely, consistent, accurate, complete and valid information.

• Manage the reporting of information quality key performance indicators.

• Responsible for defining user acceptance test strategy and plan based on business requirements and support the execution of User Acceptance Tests.

• Support Business Power Users and Regular Users.

• Revise and update documentation.

• Define training strategy and support development of training materials; support delivery of training to users.


Education:        Undergraduate Degree

Experience: Five (5) years’ related experience

Other Qualifying Skills And/Or Abilities:

  • Minimum 3 years as BI analyst
  • Deep understanding of McGill’s business goals and processes.
  • Ability to understand and clarify business needs formulated by requesters and stakeholders.
  • Must be able to communicate effectively and confidently with end users, team members and all levels of management.
  • Strong requirements elicitation and meeting facilitation skills and proven experience at driving consensus across multiple stakeholders.
  • Ability to produce and deliver informative, well organized presentations.
  • Ability to translate business requirements into data and technical requirements.
  • Strong experience in working with cubes, reports, dashboards and statistical analysis (for planning, forecasting, trending and variance analysis).
  • Demonstrated experience in working with the Microsoft BI stack(SQL Server, Sharepoint, and Excel)*
  • Demonstrated knowledge of analyzing and documenting business requirements, functional and non-functional specifications for Business Intelligence applications.
  • Demonstrated effective communication, writing and planning skills.
  • Well organized and self-motivated, with strong analytical and problem solving skills.
  • Demonstrated ability to work on multiple initiatives and to manage deadlines.
  • Demonstrated ability to work in an Agile Development environment.
  • English, spoken and written. French spoken and read.
  • Knowledge and experience in Higher Education business domain an asset.
  • Knowledge of the Team Foundation Server would be an asset.
  • Deep understanding of McGill’s business processes would be an asset
  • Our current environment is SQL 2012 based

Minimum Education and Experience:

Bachelor’s Degree 5 Years Related Experience /

Annual Salary:

(MPEX Grade 08) $90,210.00 – $135,320.00

Hours per Week:

33.75 (Full time)


Bus Intel & Analytics Mgr

Position End Date (If applicable):


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,

Job Overview

McGill University

You can apply to this job and others using your online resume. Click the link below to submit your online resume and email your application to this employer.