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 position. In 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

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.

Job Summary

The Business Intelligence Developer will play a crucial role in enhancing all aspects of the planning, implementation and operation of an enterprise-scale business intelligence solution for the VPFO’s data and reporting strategy. This includes implementing of a variety of strategic initiatives and projects vital for the VPFO and the University.

The Business Intelligence Developer’s responsibilities includes gathering and analyzing data, consults with users and BI Analysts and develops solutions to streamline processes and create well designed data stores to support the VPFO data and reporting strategy.

This is a hands-on delivery role within a multi-disciplinary technical and business team. Working closely with analysts, technical leads, managers and developers from UBC IT, Data Governance, ISC sustainment teams, the broader IT and Finance community.

Interfacing with key business leaders from VPFO departments and UBC, Business Intelligence Developer’s work will enable the VPFO and the University to leverage data, performance metrics to facilitate strategic, financial and operational decisions as well as support service transformation by driving accountability and improving transparency in support of UBC core mission.

This role will partner closely with other support teams to foster a culture of data driven decision making across the VPFO and UBC by working with departments and teams to increase data literacy, enable data exploration, and disseminate business intelligence tools and processes amongst end users.

This position works to provide coverage during core business hours (8:30 AM to 4:30 PM) but requires flexibility as some work must be performed outside of regular operating hours. The Business Intelligence Developer will also be required to act in an on-call capacity to provide maintenance activity and in the event of major service disruptions.

Organizational Status

Reports to the Business Intelligence Manager, this position will administer business intelligence systems solutions and participate in a number of projects as part of a project team, so may indirectly report to a Project Manager. This position will work with other data developers, engineers, business analysts and finance professionals in ensuring the highest quality of solution delivery.

The Business Intelligence Developer will interact with all levels of staff including Senior Academic officers, Executives, Deans, Directors, Department Heads, Senate Committees, and representatives of other universities.

Work Performed

• Contributes to the VPFO’s Finance data and reporting strategy and promotes adoption of BI tools and reporting throughout UBC

• Ensures overall quality of the development work and strives for zero errors in data and reports provided by the Business Intelligence team

• Responsible for developing and maintaining business intelligence solutions using (but not limited to) Microsoft BI stack technologies, including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and Power BI.

• Design, development, and optimization of ETL workflows and data pipelines to extract, transform, and load data from various sources into data warehouses or data marts. Including the creation and maintenance of OLAP cubes, tabular models, and data mining solutions to support complex analytical queries and reporting requirements.

• Managing data profiling, cleansing, and quality assurance activities to ensure the accuracy, completeness, and consistency of data across different systems and platforms.

• Leading the VPFO Finance BI solution including identifying and resolving performance issues, data discrepancies, and other technical challenges in a timely manner.

• Develops and maintains BI application platforms including database systems, business intelligence solutions and dashboarding.

• Write complex solutions utilizing SQL, Python, R, MDX, DAX, VBA & Power Query to produce data models, or statistical reports to support business intelligence reporting and dashboards across UBC.

• Build and sustain collaborative relationships across campus. This involves dealing with confidential and sensitive information and liaising with numerous partners to clarify and confirm data, gathering, and analyzing, documenting, and recommends options for automated systems and other business solutions.

Consequence of Error/Judgement

The Business Intelligence Developer is expected to work independently in development activities under direction of Senior Business Intelligence Developer. Data and system errors could lead to incorrect decisions by Executives and Leadership, which could have significant effects on university standards and operations.

Decisions and actions taken by the Business Intelligence Developer will have a direct impact on how efficiently and effectively the systems and processes will perform and function. Errors in judgment, poor analysis, or failure to act decisively could have a detrimental effect and adversely impact VPFO, affecting faculty and staff, and could result in lost productivity, funding and revenue.

The incumbent takes an active, participatory role in ensuring the reliability and availability of UBC mission critical 24x7x365 systems including application monitoring, tier 2 support, problem analysis and resolution, and ensuring services meet or exceed customer service levels at all times. Errors in judgment, poor planning, or failure to act decisively could have a detrimental effect on these systems. Unreliable systems and code errors that disrupt the reliable operations of these system will damage the reputation of the University.

Supervision Received
Works with considerable latitude with regard to methods and procedures. Work is reviewed in terms of achievement of broad objectives and goals. Must work independently as well as contribute actively and collaborate openly as a team member. The Business Intelligence Developer reports directly and works under general direction with the Business Intelligence Manager but may take feedback or direction from the Vice President of Finance & Operations, Directors and Senior management within the VPFO, along with feedback from project and program team members and stakeholders.

Supervision Given
The Business Intelligence Developer may provide guidance, coaching and technical leadership to other BI solution users in the VPFO and the University.

Minimum Qualifications
Undergraduate degree in a relevant discipline. In-depth knowledge of applications and the business requirements supporting them. Minimum of five 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

• Bachelor's degree or higher in Computer Science, Information Systems, Data Science, or a related field. Minimum of four years of related experience or the equivalent combination of education and experience.

• Experience with Microsoft SQL Server, T-SQL programming, stored procedures, functions, and performance tuning.

• Knowledge of financial system applications, OLAP, RDBMS, ETL and dashboarding experience with experience with SQL, MDX, DAX, R, Python, VBA in Excel.

• Exposure to designing and implementing BI solutions using Microsoft BI stack technologies, including SSIS, SSAS, SSRS, and Power BI.

• Knowledge of data warehousing principles, methodologies, and best practices, with experience in designing and implementing data warehouses or datamarts.

• 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.

• Strong problem-solving and analytical thinking skills, coupled with initiative, meticulous troubleshooting, and a unique ability to devise creative solutions in a dynamic work environment.

• Strong interpersonal and collaboration skills and the ability to establish and maintain effective working relationships internally and externally and provide excellent customer service levels.

• Demonstrated ability to handle multiple concurrent assignments and prioritizing competing resource demands.

• Equity and diversity are essential to academic excellence. An open and diverse community furthers the inclusion of voices that have been underrepresented or discouraged. We encourage applications from members of groups that have been marginalized on any grounds enumerated under the B.C. Human Rights Code, including sex, sexual orientation, gender identity or expression, racialization, disability, political belief, religion, marital or family status, age, and/or status as a First Nation, Metis, Inuit, or Indigenous person.