Business Intelligence Analyst

Global Technical Talent, an Inc. 5000 Company; Regina; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading staffing firm is looking for a Business Intelligence Analyst in Regina. The role focuses on enabling data-driven decision-making, transforming complex data into actionable insights. Key responsibilities include guiding business units throughout the BI solution lifecycle, optimizing SQL queries, and developing Power BI dashboards. Candidates should have deep technical expertise in SQL, Power BI, and cloud analytics. This position offers the opportunity to work with diverse teams on innovative solutions within a supportive environment.

Qualifications

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

Responsibilities

• Communicate and present complex information clearly to diverse audiences.
• Guide business units through the full BI solution lifecycle.
• Design and implement technology solutions aligned with digital transformation goals.

Skills

SQL query development and optimization

Power BI reporting, Power Query, and DAX

Cloud analytics (Azure, Databricks)

Tools

Power BI

SQL

Microsoft 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