Job Description

Job Category: Information Technology
:
This competition is restricted to internal applicants of the University of Alberta. Please log in to verify your internal candidate status.
This position is a part of the Non-Academic Staff Association (NASA).
This position offers a .
Location - This role is hybrid with a mix of remote and in-person. Work primarily takes place at Enterprise Square.
The Senior Research Systems Analyst is a role reporting to the Director, Data Services. This position is a cornerstone in developing, delivering and operating the Institutional Data Warehouse (IDW), which supports the University's ability to make informed, evidence-based decisions. This role involves significant technical expertise in data management and modelling, alongside the ability to collaborate effectively with various stakeholders. The successful candidate will lead the development, quality assurance, and delivery of IDW components, train and mentor users, and develop essential documentation to ensure long-term usability.
Responsibilities:
Build and Deliver the Institutional Data Warehouse (IDW) - 35%

• Develop interim models and modules to validate design approaches.
• Design and implement data extraction processes from administrative systems (e.g., PeopleSoft
• Campus Solutions, HCM, Financials).
• Collaborate with IST staff to address system performance, security, and technical issues.

Develop IDW Data Products - 30%

• Create both scheduled and ad hoc data products using tools such as Python, SQL, Tableau, Excel, machine learning and data pipelines.
• Design data models, assets, and solutions tailored to stakeholder needs.
• Ensure data products align with the university's operational goals and strategic priorities.

Quality Assurance - 10%

• Define and execute testing plans to validate the accuracy, reliability, and performance of IDW modules.
• Monitor and manage data quality, identify anomalies, and implement corrective actions.

Training and Documentation - 20%

• Design and deliver training sessions for IDW users across varying technical skill levels.
• Develop and maintain comprehensive documentation, including methodologies, data dictionaries, data maps, and data flow models.

Collaboration and Support - 5%

• Collaborate with internal and external stakeholders to resolve data-related challenges.
• Ensure the IDW continues to evolve in alignment with emerging technologies and institutional needs.

Qualifications:

• Bachelor's degree or diploma in Computing Science or a related field (equivalent combinations of education and experience will be considered). Advanced degree preferred.
• 10+ years of experience in data warehouse development and data operations.
• Strong proficiency in data modelling and data engineering, such as Azure Synapse Python, and SQL.
• Superior knowledge with cloud-based solutions and data warehousing principles.
• Exceptional written and oral communication skills to produce detailed documentations and collaborate with stakeholders.

Application Instructions
Please submit your resume and cover letter.
About Us:
The University of Alberta acknowledges that we are located on Treaty 6 territory, and respects the histories, languages and cultures of First Nations, Metis, Inuit and all FirstPeoples of Canada, whose presence continues to enrich our vibrant community.
The University of Alberta is a community of knowledge seekers, change makers and world shapers who lead with purpose each and every day. We are home to over 14,000 faculty and staff, more than 40,000 students and a growing community of 300,000 alumni worldwide.
Your work will have a meaningful influence on a fascinating cross-section of people - from our students and community members, to our renowned researchers and innovators, making discoveries and generating solutions that make the world healthier, safer, stronger and more just. .
At the University of Alberta, we are committed to creating an inclusive and accessible hiring process for all candidates. If you require accommodations to participate in the interview process, please let us know at the time of booking your interview and we will make every effort to accommodate your needs.
We thank all applicants for their interest; however, only those individuals selected for an interview will be contacted.
All University employees have a responsibility to foster a workplace that prioritizes safety in all its forms-physical, cultural, and psychological. This is achieved by promoting a safe environment, adhering to all safety laws, policies and procedures, completing all required safety training, identifying hazards and implementing controls, reporting incidents, and contributing to a culture of belonging and respect, while endeavoring to ensure that all colleagues feel valued and safe to express their thoughts, perspectives and concerns.
The University of Alberta is committed to creating a university community where everyone feels valued, barriers to success are removed, and thriving connections are fostered. We welcome applications from all qualified persons. We encourage women, First Nations, Metis 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.
L'Universite de l'Alberta s'engage a creer une communaute universitaire ou chaque personne se sent valorisee, ou les obstacles a la reussite sont elimines et ou des connexions enrichissantes peuvent se developper. Nous accueillons les demandes de toutes les personnes qualifiees. Nous encourageons les femmes; Premieres nations, Metis et Inuits; membres des groupes minoritaires visibles; personnes handicapees; personnes de toute orientation sexuelle ou identite et expression de genre; et toutes les personnes qui peuvent contribuer a la diversification des idees et a l'universite a postuler.
About the Team: (IDA) mission is to serve the University of Alberta with high quality and impactful analytics, empowering data-driven decisions. The IDA unit operates in a team-oriented, fast-paced, and dynamic environment where responding quickly, clearly, and accurately is paramount. Our work focuses on building and maintaining the U of A's reporting and analytics environment, including our data warehouse, which is transitioning to the cloud. We deliver analytical products to support our key missions of teaching and research.

Skills Required