Business Intelligence Specialist - Senior

The Code Crackers Inc; Toronto; On-site; CAD 95,000 - 130,000; Full time

Job summary

The Code Crackers Inc is seeking an experienced Power BI/Data Architecture professional for an onsite role in Toronto. The position focuses on data architecture for ADDS/Databricks Lakehouse, and hands-on Power BI development across dashboards, semantic models, security (RLS), and performance optimization.

Responsibilities include architecture design, data governance, CI/CD pipelines, and mentoring BI developers.

Qualifications

• 5+ years of Power BI development experienced in public sector or healthcare
• 7+ years of data architecture experience with enterprise BI solutions
• Expert-level DAX, Power Query, and data modeling skills
• Advanced SQL and data warehouse development
• Experience designing enterprise semantic models and reporting architectures
• Strong stakeholder management and leadership skills
• Experience mentoring developers and leading BI initiatives

Responsibilities

• Design and develop Power BI semantic models and dashboards
• Connect and integrate Databricks data sources
• Implement DAX measures and KPIs
• Configure security including Row-Level Security
• Optimize performance and support testing/deployment
• Provide technical documentation and knowledge transfer
• Create data architecture artifacts (models, lineage, governance)
• Lead BI initiatives and mentor junior developers
• Architect data flow and CI/CD pipelines for BI solutions

Skills

Power BI

DAX

SQL

Databricks

Azure Data Factory

Data modeling

Data governance

RLS

Stakeholder mgmt

Performance optimization

Tools

Databricks

Azure Data Factory

Data Lake

Synapse

SQL Server

Job description

NOTE Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.

Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Responsibilities

Data architecture for ADDS Power BI solution (representing 40% of time)

Solution Architecture Document

Data Flow Diagrams

Conceptual/Logical/Physical Data Models

Databricks Lakehouse Design

Power BI Semantic Model Design

Role model and security design, including Row-Level Security Design

Data Governance Framework

Data Lineage Documentation

Performance & Capacity Plan

Environment and Continuous Integration and Continuous Delivery (CI/CD) pipeline design

Non-Functional Requirements

Architecture review and Sign-Off Package

Hands on Power BI development for reports (representing 60% of time)

Design and develop Power BI semantic models,

Connect and integrate Databricks data sources,

Implement DAX measures and KPIs,

Build dashboards and reports,

Configure security and RLS,

Optimize performance,

Support testing and deployment, and provide technical documentation and knowledge transfer

Skills

Experience and Skill Set Requirements

Public Sector Experience

3 years public sector/healthcare experience 5 points Business Intelligence hands-on development skills

7+ years of Business Intelligence and Data Analytics experience.

5+ years of Power BI development experience.

Expert-level DAX, Power Query, and data modeling skills.

Advanced SQL and data warehouse development experience.

Ability to design enterprise semantic models and reporting architectures.

Strong stakeholder management and leadership skills.

Experience mentoring developers and leading BI initiatives.

55 points Business Analysis Skills

Strong experience of working with business team to identify and gather requirements for Business Intelligence enhancements or defect fix items

Experience in performing deep-dive data analysis to resolve data issues and answer questions from business

Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

10 points Data Architecture Skills

7+ years of experience in data architecture.

Expert knowledge of dimensional modeling, star schemas, and enterprise data warehouse design.

Strong experience designing Power BI semantic models and enterprise reporting solutions.

Strong expertise with Databricks, Azure Data Factory, Data Lake, Synapse, and SQL Server.

Proven experience implementing data governance, security, and performance optimization strategies.

Ability to translate business requirements into scalable data architecture solutions.

30 points Supplier Comments Closing Date - 2026-08-25, 1:30 p.m. Maximum Number of Submissions - 1 (one) Assignment Type: Onsite - 5 days in the office MUST HAVES:

5+ years of Power BI development experience.

7+ years of experience in data architecture.