Power BI Architect

Adastra Corporation; Markham; On-site; CAD 85,000 - 120,000; Full time

Job summary

A data-focused consulting firm is seeking an experienced Power BI Architect to design and implement scalable Power BI solutions. The successful candidate will shape governance frameworks, execute migrations, and contribute to analytics projects across various industries. Candidates should possess a Bachelor's degree in a relevant field, a minimum of 3 years in a Power BI role, and strong problem-solving skills. The role offers competitive compensation and a hybrid working environment.

Benefits

Opportunity for advancement

Competitive compensation package

Comprehensive benefits plan

Flexible workplace

Qualifications

• Proven experience implementing Power BI platforms.
• 3+ years in a Power BI Architect role.
• Expertise in data warehouse design and security configurations.

Responsibilities

• Develop and execute a Power BI implementation roadmap.
• Design and implement Power BI platforms.
• Conduct skills assessments and deliver training sessions.

Skills

Power BI implementation

Data analysis

SQL proficiency

Strong communication skills

Problem-solving skills

Education

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

Tools

Power BI Service

Tabular Editor

DAX Studio

Job description

Overview

Adastra is seeking an experienced Power BI Architect to join our Visualization Practice. In this role, you’ll design and implement scalable Power BI solutions, shape governance frameworks, and contribute to impactful analytics projects across diverse industries.

Location: Greater Toronto Area, ON (Hybrid, up to 3 days onsite)

Status: Full-Time

Responsibilities:

• Develop and execute a Power BI implementation roadmap to achieve target architecture
• Design and implement Power BI platforms, including architecture (gateways, capacities), security, and admin settings for both cloud and on-premises environments
• Define governance and delivery models to support a self-serve BI platform
• Design and build complex Power BI reports, dashboards, datasets, dataflows, and datamarts
• Conduct skills assessments and deliver Power BI training sessions as needed
• Plan and execute migrations from legacy BI systems to Power BI

Qualifications, Skills & Experience:

• Bachelor’s degree in Computer Science, Engineering, or a related field
• Proven experience implementing Power BI platforms (Power BI Service and PBIRS)
• 3+ years of professional experience in a Power BI Architect role
• 3+ years as a hands-on Power BI Report Developer (Power BI Reports, Paginated Reports, or SSRS)
• Solid Center of Excellence (CoE) and Governance experience as it relates to Business Intelligence and Power BI
• Expertise with composite models, aggregations, and advanced DAX
• Proficiency in SQL and data warehouse design (e.g., dimensional modeling)
• Strong understanding of security and governance configurations within Power BI
• Familiarity with 3rd-party tools such as Tabular Editor and DAX Studio
• Knowledge of database management systems, OLAP, and ETL frameworks
• Analytical mindset with the ability to translate data into meaningful insights
• Self-starter with strong problem-solving skills and a proactive, innovative approach
• Excellent communication and client engagement skills

Nice to Have:

• Experience with Analysis Services Tabular models (SSAS or AAS)
• Experience with Power BI Dataflows and Datamarts
• Familiarity with Power Platform (Power Apps, Power Automate)

About Adastra

For more than 25 years, Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development. Our team of experts, combined with our worldclass data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes – from SMEs to Fortune 1000s – achieve their data transformation goals, whether that be accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.

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 Code. In addition, 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 ‘@adastragrp.com’ or ‘@talent.icims.com’ 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 [e-mail] to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.