University of Alberta

Senior Research Systems Analyst

Strategic Analysis

Competition No.  -    S106934437
Posting Date  -    Nov 23, 2017
Closing Date  -    Dec 17, 2017
Position Type  -    Full Time - Operating Funded
Salary Range  -    $73,825 to $104,512 per year
Grade  -    13
Hours  -    35

This position offers a comprehensive benefits package which can be viewed at:

Strategic Analysis and Data Warehousing is a fast-paced and dynamic work environment in the University of Alberta, where the ability to respond quickly, clearly and with accuracy, is paramount.  Reporting to the Associate Director, Strategic Analysis and Data Warehousing, the Senior Research Systems Analyst will play a key technical leadership role in the build and delivery of the Institutional Data Warehouse (IDW), providing answers to the University’s senior executive officers, other University planning and presentation units and to external partners. The successful candidate will have a high level of technical and business expertise, including the ability to understand users’ business requirements and translate these into technical solutions. These skills will be supported by their understanding of the business of the University, exceptional technical SQL programming skills and ability to communicate with faculty and senior administrators in a non-technical, business style.

As the successful candidate you will:

  • Make a difference and have a lasting impact at a leading post-secondary institution
  • Have leaders who support your work and professional development
  • Work with a high performing team in a positive and collegial environment
  • Do challenging work
  • Build close relationships with clients within the University


  • Leads analysis necessary to support rule definition in the build of the IDW
  • Conducts the data extraction and liaison functions as necessary to populate and update the IDW
  • Works with the contracted entity to build and deliver the IDW solution, confirm interpretation and provide further detail of requirements
  • Defines plans, including use cases for testing IDW modules and coordinate or conduct testing
  • Defines mechanisms to ensure data quality and manage data quality issues
  • Develops and delivers information products sourced from the IDW, including, but not limited to, standard reports and queries, ad hoc statistical reports, data marts, and business intelligence solutions
  • Liaises with business areas and data specialists throughout the University and the Ministry of Advanced Education
  • Develops and maintains documentation, including detailed textual methodology, entity relationship models, data dictionary and taxonomies


  • Minimum Bachelor’s degree in Computing Science or related field (Honours degree preferred); equivalent combinations of education and experience will be considered
  • 3-5 years of experience in database management, with particular attention to extraction, transformation and loading operations
  • In-depth knowledge of data warehousing principles
  • Excellent knowledge of programming and database management/operations
  • Advanced programming skills in SQL
  • Ability to use relevant computer application programs for data extraction, programming, report and statistical development, graphic and other presentations (e.g., SQL; Excel; Access; PowerPoint; Cognos tools) and to learn to use new ones as they evolve
  • Understanding of data management and data quality principles
  • Superior ability to work cooperatively with colleagues and with data specialists in other units on and off campus to identify and solve data quality, data validity and data selection problems to the mutual satisfaction of report clients and system contributors
  • Excellent problem solving and investigative skills
  • Excellent time management, including accurate preliminary estimates of project time expectations
  • Excellent written and verbal communication skills, both for internal and external consultations and reports
  • In-depth knowledge and understanding of relevant university data, issues, policies and procedures in a range of areas, in particular, expertise with student data
  • Business intelligence and data presentation skills an asset
  • Continuous upgrading of skills in computer programming, database management and software as products and services evolve
  • Effective experience in committee work, facilitating collaborative projects across the organization

How to Apply

Apply Online

Note: Online applications are accepted until midnight Mountain Standard Time of the closing date.

We thank all applicants for their interest; however, only those individuals selected for an interview will be contacted.

The University of Alberta is committed to an equitable, diverse, and inclusive workforce. We welcome applications from all qualified persons. We encourage women; First Nations, Métis and Inuit persons; members of visible minority groups; persons with disabilities; persons of any sexual orientation or gender identity and expression; and all those who may contribute to the further diversification of ideas and the University to apply.