Data Analyst

Primary Purpose: To support the reporting and data initiatives of the university’s financial business unit through data management, integration and business intelligence initiatives. This involves the development and implementation of the enterprise-wide data warehouse and business intelligence solutions that will meet information needs of operational, planning, decision making and performance measurement activities.

Nature of Work: Reporting to the Manager of Reporting and Data Systems, the data analyst will work with data stewards, data managers and data users to establish information, data definition, compliance, and access requirements to make data and information accessible to users. They will use communication and facilitation skills with business clients to bridge technical IT skills with accounting/finance expertise. They will take personal initiative to develop an in-depth knowledge of the business requirements and information needs. They will understand and analyze business data in institutional databases and transform the data into useable information and insights. They will balance cyclical operational workloads with strategic reporting projects work.

Accountabilities

• Perform business analysis to understand financial reporting information needs and requirements, and how business rules and workflows translate into data and information.
• Facilitate discussions and educate data managers and data stewards to standardize business terms, define and classify data, establish access and information requirements.
• Design, develop, and implement information solutions relating to reporting, dashboards, and self-service data delivery methodologies to meet the needs of institutional financial reporting, campus users and entities external to the University of Saskatchewan.
• Provide system outputs and reports and help identify and create new opportunities for processes and process improvement related to financial data and reporting.
• Identify issues of data quality (e.g. accuracy, completeness, reliability, etc.) and ensures that data-related problems are addressed and resolved in a timely manner.
• Design, develop, and test extract-transform-load (ETL) processes for the acquisition and integration of data into new or existing facts and dimensions in the institutional data warehouse. Work collaboratively with the team to identify and address performance issues.
• Provide regular updates to the manager and the team on progress, emerging issues, and new opportunities.
• Promote a team environment through effective collaboration and communication.
• Access knowledge bases and FAQ resources on the Internet/Intranet to aid in incident resolution.
• Develop and post documentation related to customized tasks, procedures and services that relate to your position and to the areas in which you are working.
• Stay current and take part in training opportunities as directed by your Manager, IT Support Services.
• Perform other related duties or projects as required.

Qualifications
Education and experience: An undergraduate degree in a related discipline; a graduate degree or additional professional training relating to data warehousing, business intelligence, analytics or business analysis would be considered an asset; three years of experience with data integration, data warehousing or business intelligence;

Skills: An aptitude for research and understanding data and how business rules and workflows translate into data and information; ability to work effectively as part of a team or independently; proven success in completing high quality work in an accurate and timely manner; proficiency in data modeling and translating business needs into technical solutions; analytical, research, organizational and problem-solving skills; ability to think creatively and identify innovative solutions; experience in requirements gathering, documenting, problem resolution with clients;

Proficiency in SQL, Excel, SSIS, SSRS, PowerBI or equivalent. Expertise in Crystal Reports, Oracle, or Millennium FAST products would be considered an asset

Department: ICT Enterprise
Status: Permanent
Employment Group: ASPA
Full Time Equivalent (FTE): 1.00
Salary: The salary range, based on 1.0 FTE, is $64,107.00 - 100,169.00 per annum. The starting salary will be commensurate with education and experience.
Salary Family (if applicable): Information Technology
Salary Phase/Band: Phase 2
Posted Date: 6/1/2023
Closing Date: 7/12/2023 at 6:00 pm CST
Number of Openings: 1
Work Location: On Campus

The successful applicant will be required to provide the following current verification(s) where 'Yes' is indicated below. Further information is available at: https://careers.usask.ca/tips-for-applying.php

Criminal Record Check: Yes
Driver's License and Abstract Check: Not Applicable
Education/Credential Verification: Not Applicable
Vulnerable Sector Check: Not Applicable

Please review the University of Saskatchewan's health and safety requirements for faculty, staff and students in consideration of the COVID-19 pandemic.

The University is committed to employment equity, diversity, and inclusion, and are proud to support career opportunities for Indigenous peoples to reflect the community we serve. We are dedicated to recruiting individuals who will enrich our work and learning environments. All qualified candidates are encouraged to apply; however, in accordance with Canadian immigration requirements, Canadian citizens and permanent residents will be given priority. We are committed to providing accommodations to those with a disability or medical necessity. If you require an accommodation to participate in the recruitment process, please notify us and we will work together on the accommodation request. We continue to grow our partnerships with Indigenous communities across the province, nationally, and internationally and value the unique perspective that Indigenous employees provide to strengthen these relationships. Verification of Indigenous Membership/Citizenship at the University of Saskatchewan is led and determined by the deybwewin | taapwaywin | tapwewin: Indigenous Truth policy and Standing Committee in accordance with the processes developed to enact the policy. Successful candidates that assert Indigenous membership/citizenship will be asked to complete the verification process of Indigenous membership/citizenship with documentation. The University of Saskatchewan’s main campus is situated on Treaty 6 Territory and the Homeland of the Métis. We pay our respects to the First Nations and Métis ancestors of this place and reaffirm our relationship with one another. Together, we are uplifting Indigenization to a place of prominence at the University of Saskatchewan.