Business Intelligence Developer

Job Category

Job Profile

Job Title

Department

Compensation Range

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge qualifications and experience for the the normal course employees will be hired transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date

Note: Applications will be accepted until 11:59 PM on the Posting End Date.

Job End Date

This position is expected to be filled by promotion/reassignment and is included here to inform you of its vacancy at the University.

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 VPFOs 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 ones own.

• Demonstrates a commitment to enhancing ones 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.