Business Intelligence Developer

Job Summary

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career.

The Business Intelligence Developer supports the planning, development and maintenance of business intelligence solution for the VPFO’s data and reporting needs. This role focuses on implementing and supporting data models, reports and dashboard that enhance data driven decision making across VPFO and the broader university community.

Working within a collaborative environment that includes analysts, developers and technical staff across UBC IT, Data Governance and Finance teams, the BI Developer contributes to the ongoing improvement of reporting and data integration processes.

This position requires strong technical skills, attention to detail and the ability to translate user requirements into effective BI solutions. Some work outside regular business hours may be required for system maintenance or in the event of major service disruptions.

Organizational Status

Reports to the Business Intelligence Manager and works closely with other developers, analysts and finance professionals in ensuring the highest quality of solution delivery.

Work Performed

Develops and maintains business intelligence reports, dashboards and data models using such tools as Microsoft Power BI, SQL Server Reporting Services (SSRS).

Designs and supports data extraction, transformation and loading (ETL) workflows using SQL Server Integration Services or other relevant tools.

Assists in the development and maintenance of data warehouses or data marts to support reporting needs.

Conducts data profiling, validation, and quality assurance to ensure data accuracy and reliability.

Works with business analysts and users to gather reporting requirements and translate them into BI solutions.

Troubleshoots and resolves issues related to data access, performance, and integration.

Contributes to documentation of data structures, processes, and BI standards.

Participates in testing and implementation of BI system enhancements or upgrades.

Provides user support and training on BI tools and reports.

Works collaboratively with IT and finance teams to ensure consistent and reliable delivery of BI services.

Consequence of Error / Judgement

Errors in data or reports may lead to inaccurate analysis and decision-making, potentially affecting financial and operational outcomes. The BI Developer must exercise sound judgment in verifying data accuracy and in maintaining security and confidentiality of information.

Supervision Received

Works with considerable latitude with regard to methods and procedures. Work is reviewed in terms of achievement of specific objectives and goals. Must work independently as well as contribute actively and collaborate openly as a team member.

Supervision Given

May provide guidance, coaching and technical support to other BI solution users in the VPFO and the University.

Minimum Qualifications

Undergraduate degree in a relevant discipline. Minimum of three years of related experience, or the equivalent combination of education and experience.

Willingness to respect diverse perspectives, including perspectives in conflict with one’s own.

Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion.

Preferred Qualifications

Experience developing reports and dashboards using Power BI, SSRS or similar tools. Proficiency with SQL for data extraction and transformation.

Microsoft Power BI. Familiarity with ETL tools and data warehousing concepts.

Experience with cloud-based BI solutions, particularly Microsoft Azure services such as Azure SQL Database, Azure Analysis Services, Azure Data Factory, and Azure Synapse Analytics.

Excellent written and verbal communications including effective presentation skills to technical and non-technical audiences.

Works collaboratively with IT and finance teams to ensure consistent and reliable delivery of BI services.

Effective interpersonal, communication and collaboration skills with both technical and non-technical audiences.

Demonstrated ability to handle multiple concurrent assignments and delivering high-quality work within deadlines.

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.