Business Intelligence Developer

Position Job Title:

Primary Purpose

Specific Responsibilities

• Design relational databases to support business enterprise applications and physical data modeling according to business requirements
• Gather requirements from various business departments at UCW and transform them into self-serve reports/dashboards for the various business units using Power BI
• Understand ad-hoc data requirements and convert it into reporting deliverables
• Contribute to driving reporting automation and simplification to free up time for in-depth analyses
• 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
• 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. Contributes to the development of training materials, documenting processes, and delivering sessions.
• Develop strategies for data modeling, design, transport, and implementation to meet requirements for metadata management, operational data stores, and ELT/ETL environments
• 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
• Research modern technologies, data modeling methods, and information management systems and recommend changes to company data architectures
• Contribute to a team environment where all team members consistently experience a sense of belonging and inclusion

Position Requirements

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

Education and Experience:

• Bachelors or masters degree in business, Information Systems, Computer Science, or related discipline
• Demonstrated experience in using Power BI 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