Business Intelligence Developer Jobs

Position Job Title: Business Intelligence Developer

Location: Hybrid

Reports To: Business Intelligence Manager

Primary Purpose

The BI developer applies business and advanced technical expertise in meeting business data and reporting needs. The position supports business planning by compiling, visualizing, and analyzing business and statistical data from UCW’s information systems. The BI developer liaises with various stakeholders across the university to provide them with the data, reporting, and analysis required to make informed data driven decisions.

The Business Intelligence developer will work on projects that will have a significant impact on student, faculty, and staff experience.

Specific Responsibilities

The BI Developer will at various times be responsible for the following as well as other related duties as assigned to support the business objectives and purpose of the Company:

• Collaborate with internal and external team members, including system architects, software developers, database administrators and design analysts to find creative and innovative approaches to enrich business data
• Understand ad-hoc data requirements and convert it into reporting deliverables
• Research modern technologies, data modeling methods and information management systems and recommend changes to company data architectures
• Design relational databases to support business enterprise applications and physical data modeling according to business requirements
• Contribute to a team environment where all team members consistently experience a sense of belonging and inclusion
• Gather requirements from various business departments at UCW and transforms them into self serve reports/dashboards for the various business units using Power BI
• Provide business and technical expertise for the analytics process, tools, and applications for the University. Identify opportunities that improve data accuracy and efficiency of our processes. Contribute to the development of training materials, documenting processes, and delivering sessions.
• Create and test data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
• Contributes to driving reporting automation and simplification to free up time for in-depth analyses
• Develop strategies for data modeling, design, transport, and implementation to meet requirements for metadata management, operational data stores and ELT/ETL environments

Competencies

• Strong analytical, problem solving, and data analysis skills
• Ability to implement row-level security on data along with an understanding of application security layer models in Power BI
• Demonstrated ability to collect data from a variety of sources, synthesize data, produce reports, and make recommendations
• Understanding of statistical analysis techniques such as correlation and regression
• Demonstrated experience in creating complex data models and developing insightful reports and dashboards using Microsoft PowerBI
• Connecting data sources, importing data, cleaning, and transforming data for Business intelligence
• Ability to manage multiple concurrent tasks and competing demands
• A good sense of design that will help communicate data using visually compelling reports and dashboards
• Ability to translate business requirements into informative reports/visuals
• Experience in ETL (Extract, Transform and Load) processes an asset
• Knowledge of database management principles and experience working with SQL/MySQL databases
• Ability to ensure organizational data privacy and confidentiality
• Must possess advanced skills in using DAX queries for Power BI
• Experience in being involved in the development of a data warehouse is an asset
• Data analysis and visualization skills using Python and/or R an asset

Education and Experience

• Bachelor’s or master’s degree in Business, Information Systems, Computer Science, or related discipline
• Demonstrated experience in using PowerBI to create reports, dashboards, and self serve analytics
• Must have 3+ years of experience in data-specific roles especially in the use of Power BI, Excel, and SQL.