Business Intelligence Developer

Primary Purpose : To support the reporting and data initiatives of the university through data management, integration, and business intelligence. This involves developing and implementing the data warehouse and business intelligence solutions that will meet the information needs of the university.

Nature of Work: Reporting to the Manager of Reporting and Data Systems, the business intelligence developer will perform hands-on technical work to code data transformations, develop dimensional data models, and build complex Power BI reports.  They will interact with business clients to understand information needs and develop reporting requirements.  They will have the personal initiative to develop an in-depth knowledge of business rules, processes, and workflows.  They will share knowledge with fellow BI developers to maintain consistent development practices and promote a positive team environment.   This position is in-person located at the Saskatoon campus.

Accountabilities

• Design, develop, and implement business intelligence solutions, including data models, reports, dashboards, and data visualizations using SQL, SSIS, ADF, and Power BI. Apply best practices in data visualization to present complex data in a clear and intuitive manner.
• Design, develop, and test extract-transform-load processes to integrate data into facts and dimensions in the institutional data warehouse. Monitor and troubleshoot nightly ETL jobs to identify and resolve performance or data load issues during on-call rotations.
• Work with business stakeholders to define management and strategic reporting requirements. Develop report and data visualization prototypes to validate the requirements.  Identify issues of data quality (e.g., accuracy, completeness, timeliness, and consistency) and ensure that data-related problems are addressed and resolved in a timely manner. 
• Ensure compliance with data governance policies and security standards. Implement access controls, data encryption, and data masking techniques to protect sensitive information. Work with data managers and data stewards to standardize business terms, define and classify data, and establish access and information requirements.
• Develop and post documentation for customized tasks, procedures, and services that relate to your work.
• Provide regular updates to the manager and the team on progress, emerging issues, and new opportunities.
• Stay current with the latest trends and advancements in business intelligence and take part in training opportunities as directed by your manager.
• Perform other related duties or projects as required.

Qualifications: An undergraduate degree in computer science, information systems or related discipline. Additional professional training relating to data warehousing, business intelligence, analytics or business analysis is a plus. Five year’s solid experience with data integration, data warehousing or business intelligence.

Skills

• Proficiency in SQL and database technologies such as SQL Server.
• Strong experience in ETL development using tools such as SSIS or Azure Data Factory.
• Strong experience with data warehousing concepts and dimensional modeling.
• Experience with reporting and data visualization tools such as SSRS and Power BI.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and handle multiple projects simultaneously.

Position is within ASPA

Department: ICT EnterpriseArch&DataMgmt

Status: Permanent

Employment Group: ASPA
Full Time Equivalent (FTE): 1.00

Salary: The salary range, based on 1.0 FTE, is $66,030.00 – 103,174.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: 1/8/2024

Closing Date: 1/14/2024 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

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 tendersglobal.net taapwaywin tendersglobal.net 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.