Senior Power BI Developer (Thought Leader)

Adastra Corporation; Calgary; Remote; CAD 100,000 - 130,000; Full time

Job summary

A reputable technology firm in Canada is seeking a Senior Power BI Developer to lead the design and delivery of analytics solutions. This role involves transforming data into actionable insights while collaborating with stakeholders to foster a data-driven culture. The ideal candidate has over 8 years of experience in Power BI, advanced skills in DAX and SQL, and is comfortable navigating complex data environments. Offers competitive compensation and a flexible workplace.

Benefits

Opportunity for advancement

Competitive compensation package

Comprehensive benefits plan

Dynamic and diverse workplace

Qualifications

• 8 years of hands-on experience building Power BI solutions including both standard and paginated reports.
• Advanced proficiency in DAX and SQL with a strong track record of writing optimized queries for performance.
• Deep understanding of data modeling, particularly dimensional modeling for analytical workloads.
• Solid experience integrating Power BI with Azure and AWS data sources.
• Ability to configure and manage Power BI tenant- and workspace-level security.

Responsibilities

• Design and deliver scalable Power BI solutions that work within complex enterprise environments.
• Lead conversations on best practices and bridge the gap between technical and non-technical audiences.
• Act as a trusted advisor and foster a data-driven culture.

Skills

Power BI solutions

DAX

SQL

Data modeling

ETL frameworks

Azure integration

SSRS

Dataflows design

Tenant-level security

Communication

Education

Bachelor's degree in Computer Science or Engineering

Tools

Power Platform

Tableau

Microsoft SQL Server

SSIS

Job description

Overview

We are looking for a Senior Power BI Developer who brings not only deep technical expertise but also the confidence and clarity to lead within the modern analytics landscape. This role goes beyond building dashboards; it is about shaping the future of how data is consumed, governed, and acted upon in the organization.

You'll be at the intersection of business strategy, data engineering, and visual storytelling, helping clients turn raw data into actionable insight. Youll design and deliver scalable solutions that work within complex enterprise environments, integrating with cloud platforms like Azure and AWS and embedding governance and performance optimization into every layer of your work.

This is a hands-on, high-impact role for someone who thrives on solving hard problems with elegant solutions. You should have a strong command of Power BI’s underlying architecture and be comfortable navigating everything from dimensional modeling and complex DAX to tenant-level security configuration and report performance tuning.

Just as importantly, you’ll act as a trusted advisor—someone who can engage stakeholders, challenge assumptions, and bring clarity in the face of ambiguity. You’ll lead conversations on best practices, bridge the gap between technical and non-technical audiences, and help foster a data-driven culture by example.

Location: Across Canada (work hours are in MST)

Qualifications & Skills

• Bachelors degree in Computer Science, Engineering, or a related field
• 8 years of hands-on experience building Power BI solutions including both standard and paginated reports (or SSRS)
• Advanced proficiency in DAX and SQL with a strong track record of writing optimized queries for performance at scale
• Deep understanding of data modeling, particularly dimensional modeling for analytical workloads
• Strong background in ETL frameworks, OLAP, and relational database design
• Solid experience integrating Power BI with Azure and AWS data sources
• Demonstrated skill in designing and implementing Power BI Dataflows and working with SSAS / AAS models
• Ability to configure and manage Power BI tenant- and workspace-level security including Row-Level Security (RLS) in line with governance and compliance standards
• Proficiency in Power BI tenant administration and familiarity with Power Platform tools like Power Apps and Power Automate is a plus
• Proven ability to serve as a technical thought partner to business stakeholders, asking the right questions, anticipating roadblocks, and offering strategic insights backed by data
• Experience navigating client dynamics, managing expectations, and resolving conflicts diplomatically and confidently
• Demonstrated ability to mentor junior developers, share best practices, and elevate the technical standards of the team
• A self-starter who proactively drives progress and brings forward new ideas
• Exceptional communication skills with the ability to translate technical details into clear business value for non-technical audiences
• Comfortable leading discussions with both technical teams and executive stakeholders

What We Offer

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• Satisfaction of working for a reputable company
• A flexible, dynamic and diverse workplace

Equal Opportunity Employer

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights legislation. Accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from @ or @ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign it is fraudulent.

Contact to inquire about jobs at Adastra to report a suspicious request for money or personal information from external websites or suspicious employment offers.

Requirements

Required Experience: Senior IC

Key Skills

Business Intelligence, Cognos, SQL, Power BI, QlikView, Microsoft SQL Server, SSRS, Tableau, SSIS, T-SQL, Data Modeling, Data Warehouse

Employment Details

Employment Type: Unclear

Experience: years

Vacancy: 1