Data Analyst — Power BI & Automation Specialist

AFL; Calgary; Hybrid; 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

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.