Business Intelligence Analyst

Microserve; Vancouver; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Microserve is seeking a Business Intelligence Analyst to join their Operational Excellence Team. The role involves gathering requirements, developing reports, and supporting business decisions through data analysis. Ideal candidates will have strong skills in data modeling and communication, and a degree in a relevant field.

Benefits

Time-off policies that promote work/life balance

Paid time off

Extended Medical and Dental plan from day one

Employee discounts with over 100+ companies

Fun Wellness & Engagement Activities

Career advancement opportunities

Hybrid working environment

Ongoing learning and development opportunities

Professional development & Training reimbursement support

Dog friendly offices

Qualifications

• Experience with Power BI or other BI tools.
• Ability to write and understand SQL queries.
• Strong MS Excel skills.

Responsibilities

• Gather requirements and build reports to drive business decisions.
• Develop business reporting solutions and translate needs into clear requirements.
• Identify opportunities for process improvements.

Skills

Data modelling

SQL

Communication

Problem-Solving

Adaptability

Education

University or college degree in computer science, business, management, or related disciplines

Tools

Power BI

Power Automate

Dynamics 365

Job description

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 Victoria, Calgary, and Edmonton, we employ over 550 team members, and are one of the largest technology solutions providers in Canada, recognized for our ability to deliver and innovate to meet the changing needs of our client.

Position Overview and Summary:

Microserve’s Operational Excellence Team is growing, and we are looking for a Business Intelligence Analyst to join the team!

This successful candidate will work closely with collaborators from other business units to gather requirements and build reports to drive business decisions. Your ability to lead interviews, ask insightful questions and make the process seamless for our internal stakeholders is essential!

The prime area of responsibility will be to support the development of reporting solutions which provide insight on KPI and overall business performance by designing, deploying and maintaining various reports & dashboards in Power BI. This means you can quickly understand the goals of each business unit and how data and analysis will contribute to achieving those goals.

If you can connect the dots between processes & technology, analyze large volumes of data and solve problems, we want to meet you!

Key Responsibilities

Develop & support business reporting solutions (90%):

• Requirement Gathering: Meet key stakeholders, including executives, directors, and senior leadership, to identify, define, and capture the right data and metrics for report and dashboard design.
• Report Development: Translate customer needs into clear requirements and create simple, meaningful reports by leveraging business intelligence infrastructure to transform raw data into intuitive visualizations.
• Problem-Solving: Use data analysis to diagnose business problems and develop innovative solutions. Collaborate with teams to implement these solutions and monitor their effectiveness.
• Process Improvement: Identify opportunities for process improvements by analyzing data and providing actionable insights. Participate in initiatives to streamline operations and enhance efficiency.

Support the BPM program (10%)

• Continuous Improvement Advocacy: Act as an Operational Excellence (OE) ambassador by raising awareness of continuous improvement concepts and tools among internal stakeholders. Promote a culture of continuous improvement and encourage the adoption of best practices.
• Process Improvement: Participate in process improvement initiatives by sourcing required data and supporting the team as needed.

Qualifications and Requirements:

Essential skills

• Data modelling experience with Power BI or other BI tools
• Knowledge or experience with Power Automate, DAX, Power Query/Power Automate
• Ability to write and understand SQL queries
• 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

Role requirements

• Strong ability to analyze and interpret data.
• Excellent spoken and written communication skills.
• Aptitude for identifying and solving business problems.
• Ability to think critically and make data-driven decisions.
• Adaptable and able to work in ambiguous situations.
• A university or college degree in computer science, business, management, or related disciplines

Preferred skillsets

• Familiarity with Dynamics 365/F&O or ConnectWise is an asset.
• Experience or exposure to Lean, Six Sigma, BPM Methodology.

CORPORATE RESPONSIBILITY

Employees will understand, meet and live our core values

Will Sweep Floors, Openness, Flexibility, Not Stuffy, Customer Driven

What do you get

• Time-off policies that promote work/life balance
• Paid time off
• Extended Medical and Dental plan from day one
• Amazing employee discounts with over 100+ companies (for example: cell phone plans, computer equipment, insurance, groceries, etc.)
• Fun Wellness & Engagement Activities – Such as chocolate making, exit rooms, staff holiday parties, to name a few
• Community Involvement – We care about giving back to our communities and plan for volunteering events at least once per quarter
• Career advancement opportunities
• Hybrid working environment for specific roles
• Ongoing learning and development opportunities
• Professional development & Training reimbursement support
• Dog friendly offices

If you feel like this role is your dream job and have questions about compensation and benefits please get in touch with us as we are always happy to discuss further. At Microserve we believe that compensation conversations should always be ongoing.