Business Data Analyst

AFL; Surrey; On-site; CAD 80,000 - 120,000; Full time

Job summary

AFL is seeking a Business Data Analyst to translate business needs into scalable data solutions within a Microsoft ecosystem. You will develop end‑to‑end Power BI reports, models, and dashboards, collaborating with cross‑functional teams to deliver timely insights for internal and external stakeholders.

The role focuses on data preparation, automation with Power Platform, and thorough documentation to support long‑term sustainability.

Qualifications

• Hands-on experience developing Power BI solutions in production or enterprise environments.
• Strong data modeling and DAX skills with BI development workflows.
• Experience connecting to SharePoint data sources and leveraging Microsoft 365 tools.

Responsibilities

• Support full lifecycle report development from requirements to deployment.
• Design and maintain datasets and data models to support reporting needs.
• Build and maintain Power BI datasets, reports, and dashboards.
• Use Power Automate to streamline data refreshes and automate processes.
• Connect to data sources including SQL databases, REST APIs, and SharePoint.
• Identify data quality issues and collaborate to resolve them.
• Document reports, data models, ETL pipelines, and automations for sustainability.
• Contribute to continuous improvement initiatives, including AI-driven tools adoption.

Skills

Power BI

Data modeling

DAX

BI development workflows

Analytical skills

Communication skills

Automation mindset

Tools

Power BI Desktop & Service

SharePoint

Power Automate

Power Apps

SQL

REST APIs

Job description

At AFL, we're building more than networks – we're helping connect communities, businesses, and people across Canada. Our teams deliver the critical infrastructure that keeps people connected, businesses running, and communities moving forward. Behind everything we do is a commitment to ensuring every employee returns home safely every day.

We are seeking a motivated Business Data Analyst with handsâon experience in business intelligence, data modeling, and a strong interest in process automation within the Microsoft ecosystem. The successful candidate will support endâtoâend report development, from requirements gathering and data preparation to report design, deployment, and ongoing enhancement, using Power BI and other Power Platform and Microsoft 365 tools.

Under the general direction of the Reporting to the Manager of Data and Analytics, the Business Data Analyst will maintain and improve existing BI solutions while contributing to new initiatives that support accurate and timely reporting for internal and external stakeholders. The Business Data Analyst will work closely with cross functional teams and executives, leveraging strong communication and analytical skills to translate business needs into scalable, reliable data solutions, while using automation to enhance and optimize reporting and business processes.

What You Will Do

• Support full lifecycle report development, including requirements gathering, data modeling, ETL, visualization, and deployment.
• Design and maintain datasets, data models, and data extractions to support reporting needs across assigned business scopes and stakeholder groups.
• Build and maintain Power BI datasets, reports, and dashboards using data modeling best practices.
• Use Power Automate to streamline data refreshes, automate business processes, and optimize reporting workflows.
• Connect to and manage data sources including SharePoint Lists and libraries, SQL databases, REST APIs, etc.
• Identify data quality issues in source systems, collaborate with stakeholders to resolve them, and recommend improvements.
• Partner with crossâfunctional teams to translate business needs into technical specifications and reporting solutions.
• Create and maintain technical documentation covering reports, datasets, ETL pipelines, data models, automations, and business processes to support longâterm sustainability and team knowledge retention.
• Contribute to continuous improvement initiatives focused on system optimization, automation, and reporting efficiency, including the adoption and integration of AIâdriven tools.
• Follow and promote AFL’s environmental, health, and safety policies.

What You Bring

• Handsâon experience developing Power BI solutions (Desktop & Service) in a production or enterprise environment.
• Experience in DAX, data modeling, and BI development workflows.
• Experience using SharePoint as a data source (Lists, document libraries, folder connectors).
• Experience or demonstrated interest in learning Microsoft Power Platform tools (Power Automate, Power Apps).
• Strong analytical and problemâsolving skills with attention to data accuracy, including the ability to normalize inconsistent client data for analyticsâready ingestion.
• Excellent communication skills for gathering business requirements and explaining technical concepts to nonâtechnical audiences.
• Selfâdriven, curious, and eager to learn new tools and technologies.
• Process efficiency mindset with the ability to identify opportunities to streamline, automate, and improve existing workflows.
• Ability to manage multiple priorities and work independently or collaboratively in a fastâpaced environment.

Nice to Have

• Experience using Microsoft Power Platform tools to support automation, workflow improvement, or data integration.
• Experience developing Copilot agents using the Microsoft 365 Copilot app and Copilot Studio.
• Background or domain experience in Telecommunications or Construction.

Working Conditions

• Hybrid office environment
• General hours of Monday through Friday 8:00am to 5:00pm
• Some travel may be required