You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

Reporting and Analytics Lead

Full Time
6 days ago

About us: 

At Microserve, we are an industry leader in providing technology solutions to public and private sector clients across Western Canada. Headquartered in Burnaby, BC, with offices in Halifax, Victoria, Calgary, and Edmonton, we employ over 380 staff, and are one of the largest technology solutions providers, recognized our ability to deliver and innovate to meet the changing needs of our clients. 


Position Overview and Summary:  

Microserve’s internal Business Process Management (BPM) Team is growing, and we are looking for a Power BI Reporting Team Lead to join the team remotely anywhere in Western Canada.  As the Power Bi Reporting Team Lead, a key area of responsibility will be to support a team of Reporting Analysts with their technical questions and guidance on PowerBI.  

You will also support the development of reporting solutions which provide insight on KPI’s and overall business performance.  You will help provide direction and coaching on the designing, deploying of reports as well as maintaining reports & a dashboard within PowerBI. Not only will you be coaching this team, you will also act as another reporting resource and will be jumping in to support business reporting needs as well.  Another key area of responsibility will be to develop data models defining the framework for data warehouse storage. 


Key Responsibilities:  

  • Responsible to implement ETL framework 

  • Support all questions from the PowerBI reporting analyst team 

  • Coach and mentor, the Power Bi reporting analyst team  

  • Responsible for the daily performance management of the Power Bi reporting analyst team 

  • Responsible for onboarding any new members to your team 

  • Identify and propose strategies around technical problems affecting the team 


Develop & implement a data warehouse 

  • Create and develop data models 

  • Prepare plans for all ETL procedures 


Develop & support business reporting solutions:  

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

  • 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 and Requirements: 

  • A university or college degree in data analytics, data science or a related discipline 

  • Minimum 3-5 years’ experience with Power Bi 

  • Minimum 2 years' experience in team leadership or supervisory role 

  • 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 

  • Knowledge of data warehouse platforms 

  • Understands database architectures, and data warehousing concepts 

  • Experience in building SQL Server Analysis Services models and understanding how they compare to Power BI Datasets 

  • 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 

  • Experience working with ConnectWise is considered an asset 

  • Lean Six Sigma, BPM Methodology experience or exposure is considered an asset

Information Technology