Business Intelligence Analyst (MR5540)

McGill University - Human Resources
Position Title: 
Business Intelligence Analyst (IST2E)
Position Summary: 

The BI Analyst works with the business stakeholders to document BI needs and evaluate project opportunities. Also, serve as a liaison between the end users, the business SMEs and the BI project team, gain consensus and approvals on the produced documents, seek innovations to develop business understanding and insight across the business and produce some dashboards and lead all UAT activities. The BI Analyst will ensure that the BI system meets the current and future needs of the stakeholders and users community. 

Primary Responsibilities: 
  •  Work with the business stakeholders from the time a business need is identified to evaluate the BI opportunity.
  •  Responsible for eliciting detailed BI-related business requirements, 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.
  •  Responsible to communicate and maintain relationship with the business users.
  •  Promote the value of the BI in the University.
  • Educate the user’s community on information availability.
  • Conduct interviews to determine the business entities definitions and relations across many stakeholders (university wide).
  • Conceive dashboards/reports using the BI “Power User” tools (front-end).
  • Contribute at the maintenance of the data dictionary.
  • Identification of the BI data sources with the users.
  • Develop test 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.
  • Produce the user documentation.
  • Define training strategy and support development of training materials; support delivery of training to users.
Minimum Education & Experience: 

Undergraduate degree

Three (3) years' related experience

Other Qualifying Skills And/Or Abilities: 
Minimum 1 year 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. 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. 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, PowerBI, Excel, etc.) 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 Jira, Confluence and Test Rail would be an asset. Deep understanding of McGill’s business processes would be an asset.
Reference Number: 
Reporting To: 
Business Intelligence Manager
Salary Range: 
(Grade 05) $56,000 - $70,000 (midpoint) - $91,000
IT Services
Enterprise Application Services
Position Type: 
Hours Per Week: 
How To Apply: 

Please submit your cover letter and curriculum vitae, clearly indicating the reference number, to IT Services:


McGill University, HR IT Services

688 Sherbrooke Street West, 16th floor

Montreal, Quebec

H3A 3R1


(514) 398-4451


careeropportunity.its [at]

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

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