Senior Research Systems Analyst

Institutional Data Warehouse

Competition No.  -    S100352294
Posting Date  -    Dec 07, 2023
Closing Date  -    Will remain open until filled.
Position Type  -    Full Time - Operating Funded
Salary Range  -    $75,869 to $107,406 per year
Grade  -    13
Hours  -    35

This position is a part of the Non-Academic Staff Association (NASA).

This position offers a comprehensive benefits package which can be viewed at: Faculty & Staff Benefits.

Location - Enterprise Square. This role is hybrid with a mix of remote and in-person.

Working for the University of Alberta

The University of Alberta acknowledges that we are located on Treaty 6 territory, and respects the histories, languages and cultures of First Nations, Métis, Inuit and all First Peoples of Canada, whose presence continues to enrich our vibrant community.

The University of Alberta is teeming with change makers, community builders, and world shapers who lead with purpose each and every day. We are home to more than 40,000 students in 200+ undergraduate and 500+ graduate programs, over 13,000 faculty and staff, 260,000 alumni worldwide and have been recognized as one of Canada’s Greenest Employers for over a decade.

Your work will have a meaningful influence on a fascinating cross section of people—from our students and stakeholders, to our renowned researchers and innovators who are quite literally curing diseases, making discoveries and generating solutions that make the world healthier, safer, stronger, and more just.

Working for the Department/Faculty 

Performance, Analytics and Institutional Research is a dynamic and team centric environment, where client service, transparency and clarity is paramount.


Reporting to the Director, Data Operations, the Senior Research Systems Analyst will play a key technical role in the build and delivery of the Institutional Data Warehouse (IDW), applying your expertise and insights to serve our internal and external clients. The successful candidate will have a high level of technical and business expertise, which includes technical savvy in requirements analysis, solutioning, data concepts, modeling, programming, and strong effective communication.

As the successful candidate you will:

  • Make a difference and have a lasting impact at one of Canada’s top universities;
  • Have leaders who support your work and professional development; Work with a high performing team in a positive and collegial environment;
  • Take on challenging projects, develop skills;
  • Build close relationships with colleagues and clients within the University.


  • Lead the analysis necessary to support the development of the Institutional Data Warehouse (IDW).
  • Maintain comprehensive specifications, including detailed textual methodology, entity relationship models, data dictionary, and taxonomies.
  • Research new approaches to improve operational efficiencies.
  • Manage all aspects of the life cycle of BI and Data Warehouse artifacts.
  • Aid in developing data management operational framework and architect processes and procedures.
  • Model and define proposed solutions for the IDW, ensuring alignment with business requirements.
  • Conduct Data Profiling and Data Mining of Data Assets.
  • Build and deliver components of the IDW solution, providing detailed requirements and confirming interpretations.
  • Define testing plans and coordinate or conduct testing for IDW modules, ensuring their robustness and accuracy.
  • Establish mechanisms to ensure data quality and proactively manage data quality issues.
  • Prepare briefings and comprehensive analytical reports.
  • Develop and deliver information products sourced from the IDW, such as standard BI reports, data marts, and business intelligence solutions.
  • Collaborate with business areas, data specialists, and stakeholders within the University and the Ministry of Advanced Education.


  • Bachelor's degree or diploma in Computing Science or a related field; equivalent combinations of education and experience will be considered.
  • Three to five years of hands-on experience in data warehouse development, with a focus on Data operations support.
  • Strong knowledge of data warehousing principles and the Data Management Body of Knowledge.
  • Proficiency in data modeling and developing cloud-based solutions.
  • Proven ability to oversee technical implementations, ensuring adherence to coding standards and effectively resolving technical issues.
  • Experience designing and implementing metrics and KPIs to support reporting and analytics.
  • Advanced skills in data visualization using industry-standard BI reporting tools.
  • Excellent problem-solving and analytical abilities.
  • Strong time management skills, including accurate estimation of project timelines.
  • Exceptional written and oral communication skills for internal and external consultations and reports.
  • In-depth knowledge of university data, policies, and procedures, particularly in the area of student data.
  • Superior ability to collaborate with colleagues and data specialists to address data quality and selection challenges.
  • Experience in coaching and mentoring junior team members is considered an asset.
  • Equivalencies will be considered.


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.