Job Description

Business Intelligence DeveloperLocation: Saskatoon Campus (In-Person)
Reporting To: Manager of Reporting and Data SystemsNature of Work: The Business Intelligence Developer will collaborate with business clients to understand their information needs and develop reporting requirements. You will engage in hands-on technical work, including coding data transformations, developing dimensional data models, and building complex Power BI reports. This role requires personal initiative to gain an in-depth understanding of business rules, processes, and workflows. Sharing knowledge with fellow BI developers to maintain consistent development practices and promote a positive team environment is essential.Accountabilities * Stakeholder Collaboration: Work with business stakeholders to define management and strategic reporting requirements. Develop report and data visualization prototypes to validate requirements. Address data quality issues (e.g., accuracy, completeness, timeliness, and consistency) promptly.

• Design and Development: Create and implement business intelligence solutions, including data models, reports, dashboards, and data visualizations using Microsoft Fabric, SQL, SSIS, and Power BI. Apply best practices in data visualization to present complex data clearly and intuitively.
• ETL Processes: Design, develop, and test extract-transform-load (ETL) processes to integrate data into the institutional data warehouse. Monitor and troubleshoot nightly ETL jobs to resolve performance or data load issues during on-call rotations.
• Data Governance and Security: Ensure compliance with data governance policies and security standards. Implement access controls, data encryption, and data masking techniques to protect sensitive information. Collaborate with data managers and data stewards to standardize business terms, define and classify data, and establish access and information requirements.
• Documentation: Develop and post documentation for customized tasks, procedures, and services related to your work.
• Communication: Provide regular updates to the manager and the team on progress, emerging issues, and new opportunities.
• Continuous Learning: Stay current with the latest trends and advancements in business intelligence and participate in training opportunities as directed by your manager.
• Additional Duties: Perform other related duties or projects as required.

Qualifications:

• An undergraduate degree in computer science, information systems, or a related discipline. Additional professional training in data warehousing, business intelligence, analytics, or business analysis is a plus.
• Five years of 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 Fabric.
• 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 with attention to detail.
• Excellent communication and collaboration abilities.
• Ability to work independently and handle multiple projects simultaneously.

Why Join Us?

• Inclusive Culture: We are committed to fostering an inclusive workplace where everyone feels valued and respected.
• Professional Growth: Opportunities for continuous learning and development, including training programs and certifications.
• Work-Life Balance: We support flexible working hours and work-life balance initiatives.
• Team Culture: Join a collaborative and supportive team environment with regular team-building activities.
• Impactful Work: Contribute to meaningful projects that drive business success and innovation.

Department: ICT, Enterprise Architecture & Data Management
Status: Permanent
Employment Group: ASPA
Full Time Equivalent (FTE): 1.0
Salary: The salary range, based on 1.0 FTE, is $67,681.00 - 105,753.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: 12/9/2024
Closing Date: 1/20/2025 at 6:00 pm CST
Number of Openings: 1
Work Location: On CampusThe successful applicant will be required to provide the following current verification(s) where 'Yes' is indicated below. Further information is available at:Criminal Record Check: Yes
Driver's License and Abstract Check: Not Applicable
Education/Credential Verification: Yes
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 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 Mxc3xa9tis. We pay our respects to the First Nations and Mxc3xa9tis 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.

University of Saskatchewan