Power BI Reporting Analyst

Company Intro:

Company in Burnaby, BC that specializes in Information Technology & Services. Delivers IT solutions to clients across BC and Alberta for over 30 years. Based in Burnaby BC, also holds branches in Victoria, Edmonton, and Calgary in addition to service networks across both provinces.


Number of Employees:

201 - 500


RESPONSIBILITIES

  • Develop & support business reporting solutions (90%):

  • Conduct requirement gathering meetings to identifying, define, and capture the right data and metrics for report and dashboard design

  • Translate customer needs into clear requirements and simple/meaningful reports by leveraging business intelligence infrastructure to transform raw data into meaningful and intuitive visualizations

  • Develop reports and dashboards using multiple data sources and to ensure they are built to specifications

  • Building corporate and business unit dashboards using PowerBI (highest priority), Power Automate, DAX, PowerQuery

  • Pull raw data from enterprise systems and apply ETL (Extract, Transform, Load) techniques

Support the BPM program (10%)

  • Participate in process improvement initiatives by sourcing required data and providing support to the team as required

  • Create process maps, standard operating procedures and supporting documentation, such as process documentation/workflows, knowledge articles, and self-service guides

  • Act as an ambassador of BPM by raising awareness of continuous improvement concepts and tools to internal stakeholders

QUALIFICATIONS

Essential skills

  • Data modelling experience with PowerBI and/or Brightguage

  • Knowledge or experience with Power Automate, DAX, PowerQuery/PowerAutomate;

  • Ability to write SQL queries and understand the syntax of SQL is an asset

  • Strong MS Excel skills

  • Ability to speak with & interview internal customers (soft skills)

  • Ability to set schedules, deadlines, milestones and work/project timelines to support delivery of assigned projects

  • A university or college degree in science, engineering, management, or a related discipline

Role requirements

  • Ability to take self-guided online courses and to self-teach additional components of tools

  • Conceptual & analysis skills

  • Communication (spoken & written)

  • Flexible and adaptable. Able to work in ambiguous situations

  • Preferred skillsets

  • Experience working with ConnectWise is an asset

  • Lean,Six Sigma, BPM Methodology experience or exposure