Business Intelligence Analyst

Accion Labs; Regina; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology company is looking for an experienced Business Intelligence Analyst in Canada. The role involves designing and delivering BI solutions, optimizing SQL, and building Power BI content to provide actionable insights. Candidates must have over 10 years of experience in BI and advanced expertise in SQL and Power BI. Familiarity with Azure and Databricks is essential. This position offers an opportunity to impact business decisions through data-driven insights.

Qualifications

• 10+ years experience in BI or similar, applying modern data management principles.
• Advanced SQL and Power BI expertise, including Power Query and DAX.
• Proficiency in Azure and Databricks; experience with Lakehouse/Delta.

Responsibilities

• Translate stakeholder needs into BI/analytics solutions.
• Design and deliver Power BI reports with tailored presentations.
• Write/optimize SQL for data extraction/transformation.
• Integrate data from legacy systems into modern solutions.
• Build star schema models; govern content/data for accuracy.
• Use Azure, Databricks, Lakehouse, and Delta to deliver scalable solutions.
• Identify and mitigate technical risks; uphold PIPEDA and security standards.
• Partner with business units from concept to delivery.

Skills

SQL

Power BI

Azure

Databricks

Lakehouse architecture

Star schema

Education

Degree/Diploma in CS/Engineering/Data Science or 10 years related work experience

Job description

Title: Business Intelligence Analyst

Tools/Tech

• SQL (advanced; query optimization; reporting/script maintenance)
• Power BI (Power Query, DAX, Power BI Service)
• Microsoft Azure, Databricks; Lakehouse architecture; Delta format
• Star schema & analytical data models; content/data management & governance
• Compliance: PIPEDA and industry security standards

About the Team & Impact

The Digital, Technology & Security (DT&S) group delivers enterprise IT services across applications, data, and infrastructure. The BI practice connects business needs with data capabilities, transforming data into actionable insights that support digital transformation and operational excellence.

Purpose/Impact

Design and deliver modern BI solutions—optimizing SQL, modeling data, and building Power BI content—to provide clear, compliant insights that guide decisions.

Responsibilities

• Translate stakeholder needs into BI/analytics solutions aligned to enterprise data architecture
• Design and deliver Power BI reports with effective, tailored presentations (Power Query/DAX) ,
• Write/optimize SQL for extraction/transformation; maintain reporting scripts ,
• Integrate and visualize data from legacy/on‑prem systems into modern solutions ,
• Build star schema models; govern content/data for accuracy and consistency ,
• Use Azure/Databricks/Lakehouse/Delta to deliver scalable pipelines and datasets ,
• Identify and mitigate technical risks; uphold PIPEDA and security standards ,
• Partner closely with business units from concept to final delivery; communicate clearly to diverse audiences ,

Must‑Have Qualifications

• 10+ years (within last 15) in BI or similar, applying modern data management principles
• Degree/Diploma in CS/Engineering/Data Science or 10 years related work experience
• Advanced SQL and Power BI expertise (Power Query/DAX, Power BI Service) ,
• Cloud proficiency: Azure, Databricks; Lakehouse/Delta experience
• Data modeling (star schema), governance, and integration/visualization delivery
• Provide Criminal Reference Check (≤6 months) before start