University of Calgary
UofC Navigation
Share this Job:

Specialist, Business Intelligence, Information Technology

Job ID: 22246

Updated: February 22, 2021

Location: Main Campus

We would like to take this opportunity to acknowledge the traditional territories of the people of the Treaty 7 region in Southern Alberta. The City of Calgary is also home to Métis Nation of Alberta, Region III.

Position Overview

The Department of Information Technology is currently seeking a Full-time Regular Specialist, Business Intelligence.

The position reports to the Associate Director, Applications and Web Services within the IT Operations portfolio at the University of Calgary.   The position is subject to high stress and requires balancing multiple priorities with tight deadlines.  There may be a requirement for after-hours work, depending on the nature of the projects.  

Position Description

Summary of Key Responsibilities (job functions include but are not limited to):

The position will be responsible for designing and managing the BI presentation tools and applications environment.  The incumbent will:

  • Configure BI Tools
  • Develop the semantic layer and metadata as well as create reports and dashboards.
  • Develops, manages, and updates data models, including conceptual and logical models of the data warehouse, data mart, and staging area, and may include an operational data store or source system.
  • Responsible for the scripts required to extract, transform, clean and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store.
  • Test, monitors, manages and validates data warehouse activity including data extraction, transformation, movement, loading, cleansing, and updating processes.
  • Tunes databases for performance, creates capacity plans, and manages data security.
  • Acts as a resource for colleagues with less experience and manages medium to low complexity projects.
  • Works with end users and business analysts to ensure tight fit between BI environment and business requirements.
  • Be involved in providing team training as well as end-user training and documentation.

Qualifications / Requirements:

  • Diploma or University Degree in Computer Science or similar field
  • Power BI or other DW/BI certifications are preferred
  • 5-7+ years¿ experience in Business Intelligence or related fields
  • Ability to translate business needs into technical solutions
  • Strong analytical, problem-solving and debugging skills
  • Program Delivery Methodology skills including SCRUM and Agile fundamentals is considered an asset
  • Ability to use standard BI and database tools including SSIS, SSAS, and Power BI
  • Understanding of SQL, including MS SQL and Oracle, and relational/multi-dimensional designs
  • Good understanding of the Kimball methodology
  • Strong understanding of Data Warehouse (DW)/BI concepts and principles
  • Strong conceptual, communication and technical skills
  • Knowledge of BI tool architectures, functions and features
  • Understanding of source and target data structures, ETL processes and products
  • Ability to learn and use other tools as required.
  • ITIL Foundations certification is an asset

Desirable Skills include:

  • Exposure or understanding of Dashboards, Scorecards, OLAP, Key Performance Indicators, Data Mining, Corporate Performance Management, Predictive Analytics.
  • Experience or exposure to data modelling tools such as Embarcadero, Erwin, Visio
  • Exposure or understanding of ERP data models and processes (e.g. PeopleSoft, SAP, etc)
  • Application development skills with .Net and knowledge of SOA.

Application Deadline:  March 8, 2021.

We would like to thank all applicants in advance for submitting their resumes. Please note, only those candidates chosen to continue on through the selection process will be contacted.

Additional Information

This position is classified in the Professional Career Band, Level 3 of the Management and Professional Staff Career Framework.

To find out more about management and staff opportunities at the University of Calgary and all we have to offer, view our Management and Staff Careers website.


About the University of Calgary

The University of Calgary is Canada’s leading next-generation university – a living, growing and youthful institution that embraces change and opportunity with a can-do attitude. Located in the nation’s most enterprising city, the university is making tremendous progress on its Eyes High journey to be recognized as one of Canada’s top five research universities, grounded in innovative learning and teaching and fully integrated with the community it both serves and leads. The University of Calgary inspires and supports discovery, creativity and innovation across all disciplines. For more information, visit

The University of Calgary has launched an institution-wide Indigenous Strategy in line with the foundational goals of Eyes High, committing to creating a rich, vibrant, and culturally competent campus that welcomes and supports Indigenous Peoples, encourages Indigenous community partnerships, is inclusive of Indigenous perspectives in all that we do.

The University of Calgary recognizes that a diverse staff/faculty benefits and enriches the work, learning and research experiences of the entire campus and greater community. We are committed to removing barriers that have been historically encountered by some people in our society. We strive to recruit individuals who will further enhance our diversity and will support their professional success while they are here. We encourage all qualified applicants to apply, however preference will be given to Canadian citizens and permanent residents of Canada.


Need help?

View our Application FAQs for answers to common questions regarding the application and selection process.