Business Intelligence Analyst

Global Technical Talent; Regina; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading staffing agency in Canada seeks a Business Intelligence Analyst to enable data-driven decision-making through actionable insights. The ideal candidate will transform complex data using SQL and Power BI, supporting strategic transformations in an onsite position. Responsibilities include guiding BI lifecycles, optimizing SQL queries, and developing dashboards. Candidates should have strong cloud proficiency and understanding of data privacy standards like PIPEDA.

Qualifications

• Expertise in SQL development and optimization.
• Extensive experience with Power BI, Power Query, DAX, and BI reporting.
• Understanding of Lakehouse architecture and Delta format.

Responsibilities

• Communicate complex information clearly.
• Guide business units through the full BI lifecycle.
• Design technology solutions for digital transformation.
• Write and optimize SQL queries for data reporting.
• Develop and publish Power BI dashboards.

Skills

SQL query development and optimization

Power BI reporting

Power Query

DAX

Cloud analytics

Presentation and communication skills

Problem-solving

Data management

Ability to derive insights from complex datasets

Tools

Azure

Databricks

Job description

Primary Job Title:

Business Intelligence Analyst

Alternate/Related Job Titles:

• Data Analytics Specialist
• BI Developer
• Data Insights Analyst

Location:

Regina, SK

Onsite Flexibility:

Onsite

Contract Details:

• Position Type: Contract
• Contract Duration: Approximately 14.5 months
• Start: As Soon As Possible

Job Summary

The Business Intelligence Analyst plays a pivotal role in enabling data‐driven decision‑making by transforming complex data into actionable insights that support strategic, operational, and digital transformation initiatives. This role requires deep technical expertise in data management, SQL development, Power BI, Azure, and advanced analytics. Analysts work closely with business units to design end‑to‑end BI solutions, support enterprise reporting modernization, and ensure alignment with security standards and compliance requirements such as PIPEDA.

Key Responsibilities

• Communicate and present complex information clearly to diverse audiences.
• Guide business units through the full BI solution lifecycle, from concept to delivery.
• Design and implement technology solutions aligned with digital transformation goals.
• Apply data architectural methodologies to ensure accuracy, efficiency, and data integrity.
• Identify and mitigate technical risks and propose effective solutions.
• Write and optimize SQL queries for data extraction, transformation, and reporting.
• Create and maintain reporting assets and SQL scripts based on evolving requirements.
• Develop and publish Power BI dashboards using Power Query, DAX, and BI best practices.
• Support reporting integration and visualization of data from legacy and on‑prem systems.
• Work with cloud environments such as Power BI Service, Microsoft Azure, and Databricks.
• Utilize knowledge of Lakehouse architecture and Delta format to model and manage large datasets.
• Ensure compliance with industry security standards and PIPEDA.
• Participate in enterprise BI design, governance, and content/data management programs.

Required Experience

• Expertise in SQL development and optimization.
• Extensive experience with Power BI, Power Query, DAX, and BI reporting environments.
• Cloud proficiency with Power BI Service, Azure, and Databricks.
• Understanding of Lakehouse architecture and Delta format.
• Experience integrating and visualizing data from legacy/on‑prem systems into modern BI solutions.
• Knowledge of content management, data governance, and analytical data models (including star schema).
• Strong understanding of data privacy, security standards, and PIPEDA compliance.

Nice‑to‑Have Experience

• Experience providing consulting‑style guidance to business units.
• Background supporting enterprise‑level digital transformation initiatives.
• Exposure to complex reporting changes and technical requirement analysis.

Required Skills

• SQL query development and optimization
• Power BI reporting, Power Query, and DAX
• Cloud analytics (Azure, Databricks)

Preferred Skills

• Lakehouse and Delta architecture
• Data modeling (star schema, analytical models)
• Technical risk identification and mitigation

Additional Skills

• Presentation and communication skills
• Problem‑solving and logical reasoning
• Data management and content governance
• Ability to derive insights from complex datasets
• Support for operational excellence and customer‑focused outcomes

About the Company

A leading power supplier operating one of Canada’s largest grids. Committed to delivering sustainable, reliable, and cost‑effective power while supporting customers through services such as meter reads, outage alerts, billing insights, and load data access. Dedicated to innovation, customer experience, and increasing gender diversity in skilled trades.

About GTT

GTT is a minority‑owned staffing firm and a subsidiary of Chenega Corporation, a Native American‑owned company in Alaska. As a Native American‑owned, economically disadvantaged corporation, we highly value diverse and inclusive workplaces. Our clients are Fortune 500 banking, insurance, financial services, and technology companies, along with major life sciences, biotech, utility, and retail organizations across the U.S. and Canada. We look forward to helping you land your next great career opportunity!

Job Number

25-29185

#gttca #LI-GTT #gttjobs #LI-Onsite