Data Analyst, Lead Jobs

Reporting and Data Analyst, Lead

Location: Remote Opportunity (Canada-wide)

Opportunity at Microserve

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 550 team members, and are one of the largest technology solutions providers, recognized for our ability to deliver and innovate to meet the changing needs of our clients.

Position Overview:

Microserve’s internal Business Process Management (BPM) Team is growing, and we are looking for a Reporting and Data Analyst, Lead to join the team! Key areas of responsibility will be to manage & grow the reporting service, support our (small) team of Reporting Analysts while also developing reporting solutions which will provide insight on KPI’s and overall business performance. This role can be performed anywhere remotely within Canada with an understanding of overlapping working hours within the Pacific Standard Time zone.

Key Responsibilities

Provide technical support & guidance (30%)

• Be the expert in all things PowerBI including Dataflows, distribution of reports, refresh, security, implement procedures to improve data management and time to deliver reports, etc
• Identify and propose strategies around technical problems affecting the team
• Support the team with technical questions and guidance on PowerBI, SSRS, SQL

Manage and grow the reporting service (20%)

• Own and improve internal operating procedures enabling the reporting services
• Implement best practices
• Prioritize & assign reporting requests, manage capacity of team members
• Digitize reports and improve self-serve reporting and analytics platform for the organization

Develop & support business reporting solutions (50%):

• Conduct requirement gathering meetings to identify, 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
• Pull raw data from enterprise systems and apply ETL (Extract, Transform, Load) techniques
• Oversee cross functional reporting initiatives such as operational performance, scorecard & KPI development
• Design, publish and maintain various reports & dashboards in PowerBI
• Building corporate and business unit dashboards using PowerBI (highest priority), Power Automate, DAX, PowerQuery
• Develop reports and dashboards using multiple data sources and to ensure they are built to specifications

Qualifications and Requirements:

• Knowledge or experience with Power Automate, DAX, PowerQuery/PowerAutomate;
• Conceptual & analysis skills
• Ability to speak with & interview internal clients (soft skills)
• Lean,Six Sigma, BPM Methodology experience or exposure
• Knowledge of data architecture & data warehousing
• Experience in analyzing, organizing, modeling and visualizing data
• Experience working with ConnectWise is an asset
• Strong MS Excel skills
• Ability to take self-guided online courses and to self-teach additional components of tools
• A university or college degree in science, engineering, management, or a related discipline
• Communication (spoken & written)
• Role requirements
• Ability to set schedules, deadlines, milestones, and work/project timelines to support delivery of assigned projects
• Preferred skillsets
• Experience with BrightGauge
• Data modelling experience with PowerBI
• Ability to write SQL queries and understand the syntax of SQL
• Knowledge/experience with Power Platform
• Flexible and adaptable. Able to work in ambiguous situations
• Essential skills