Business Data Analyst

AFL; Calgary; On-site; CAD 85,000 - 105,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive health, dental, and visa

Job summary

AFL is seeking a Business Data Analyst in Calgary to advance our BI capabilities across Canada. You will design, develop, and maintain Power BI reports and datasets, leveraging DAX, data modeling, and Power Automate to automate data refreshes and workflows.

You will collaborate with cross-functional teams to translate business needs into scalable data solutions, document technical specs, and contribute to continuous improvement initiatives while adhering to safety and ESG policies.

Qualifications

• Hands-on experience developing Power BI solutions in a production environment.
• Experience in DAX, data modeling, and BI development workflows.
• Experience using SharePoint as a data source.
• Interest in learning Microsoft Power Platform tools (Power Automate, Power Apps).
• Strong analytical and problem-solving skills with attention to data accuracy.
• Excellent communication to gather requirements and explain technical concepts to non-technical audiences.
• Self-driven, curious, and eager to learn new tools and technologies.
• Process efficiency mindset with ability to streamline, automate, and improve workflows.

Responsibilities

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

Skills

Power BI

DAX

Data modeling

BI development

Tools

SharePoint

SQL

Power Platform

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

Additional Perks:

• Competitive salary

• Comprehensive health, dental, and vision benefits.

• RRSP or retirement savings matching.

• Paid vacation and personal days.

• Professional development and training support.

• Hybrid work arrangements

• Employee assistance program and wellness resources.

• Collaborative, high-performing team environment.

• Strong safety, quality, and continuous improvement culture.

Ready to Join Us?We welcome diversity and encourage individuals of all backgrounds to apply!

We provide reasonable accommodations for individuals with disabilities. If you need accommodations during the application process, contact [e-mail]. We are an equal opportunity employer and value diversity, not discriminating based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability