Senior Power BI Developer (Thought Leader)

Adastra Corporation; Calgary; Remote; CAD 90,000 - 115,000; Full time

Job summary

A leading international consulting firm is seeking a Senior Power BI Developer in Calgary, Alberta. This role involves designing scalable analytics solutions, integrating with cloud platforms, and mentoring junior developers. A Bachelor’s degree and 8 years of Power BI experience are required. The position offers opportunities for career advancement and a competitive compensation package.

Benefits

Opportunities for career advancement

Competitive compensation

Comprehensive benefits

Flexible, dynamic, and diverse workplace

Qualifications

• 8 years of hands-on experience building Power BI solutions.
• Advanced proficiency in DAX and SQL.
• Experience integrating Power BI with Azure and AWS data sources.

Responsibilities

• Design and deliver scalable solutions in complex environments.
• Engage stakeholders and challenge assumptions.
• Lead discussions on best practices and foster a data-driven culture.

Skills

Business Intelligence

SQL

Power BI

Data Modeling

DAX

ETL frameworks

Data Warehouse

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

Azure

AWS

Power Platform tools (Power Apps, Power Automate)

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's 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 insights. You'll design and deliver scalable solutions that operate within complex enterprise environments, integrating with cloud platforms like Azure and AWS, while 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 difficult 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.

Equally important, you'll act as a trusted advisor—engaging stakeholders, challenging assumptions, and bringing clarity in ambiguous situations. You will lead discussions on best practices, bridge the gap between technical and non-technical audiences, and foster a data-driven culture by example.

Location: Across Canada (work hours are in MST)

Qualifications, Skills & Experience:

• Bachelor's degree in Computer Science, Engineering, or a related field
• 8 years of hands-on experience building Power BI solutions, including standard and paginated reports (or SSRS)
• Advanced proficiency in DAX and SQL, with a proven track record of writing optimized queries for performance at scale
• Deep understanding of data modeling, especially dimensional modeling for analytical workloads
• Strong background in ETL frameworks, OLAP, and relational database design
• Experience integrating Power BI with Azure and AWS data sources
• Skill in designing and implementing Power BI Dataflows and working with SSAS/AAS models
• Ability to configure and manage Power BI tenant and workspace security, including Row-Level Security (RLS), aligned with governance standards
• Proficiency in Power BI tenant administration; 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 providing strategic insights backed by data
• Experience managing client expectations, navigating dynamics, and resolving conflicts diplomatically
• Ability to mentor junior developers, share best practices, and elevate team standards
• A proactive self-starter who drives progress and introduces innovative ideas
• Exceptional communication skills, capable of translating technical details into business value for non-technical audiences
• Comfortable leading discussions with technical teams and executive stakeholders

About Adastra

For over 25 years, Adastra Corporation has focused on data and supporting infrastructures. We are an international consulting firm working with businesses and IT leaders to extract value through data, analytics, AI, ML, governance, hyper-automation, and enterprise application development. Our team, combined with our world-class data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes globally. We have a proven track record of helping organizations of all sizes—from SMEs to Fortune 1000s—achieve their data transformation goals, whether accelerating innovation, improving operational excellence, or creating memorable customer experiences.

What We Offer:

• Opportunities for career advancement
• Competitive compensation
• Comprehensive benefits
• Successful referral program
• Work for a reputable company
• A flexible, dynamic, and diverse workplace

Equal Opportunity Employer

Adastra is committed to fair and equitable treatment for all employees and applicants. We provide equal employment opportunities regardless of age, sex, disability, race, ethnicity, citizenship, creed, sexual orientation, marital status, or other grounds as per the Ontario Human Rights Code. We also provide accommodations during the hiring process. We encourage a diverse labor force participation and equal access to opportunities based on merit and performance.

Note: There has been an increase in fraudulent job offers from individuals posing as Adastra HR employees. Adastra will never request fees during our recruitment process. All legitimate employment offers are sent via DocuSign. If you receive an offer from a suspicious email or outside of DocuSign, it is fraudulent. Please contact us to report any suspicious requests or offers.

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 Type: Unclear

Experience: Years

Vacancy: 1