Business Intelligence Specialist

Assignment: RQ11427 - Business Intelligence Specialist - Senior Job Title: Business Intelligence Specialist Requisition (SS): RQ11427 Start Date: 2026-09-08 Client: Health Services Cluster End Date: 2027-08-27 Office Location: 5700 Yonge St., Toronto Organization: Health Services Cluster Ministry: Ministry of Public and Business Service Delivery and Procurement # Business Days: 242.00 Assignment Type: Onsite - 5 days in the office

MUST HAVES:

• 5+ years of Power BI development experience.
• 7+ years of experience in data architecture.

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

Experience and Skill Set Requirements

Public Sector Experience - 5 points

• 3 years public sector/healthcare experience

Business Intelligence hands-on development skills - 55 points

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

Business Analysis Skills - 10 points

• 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

Data Architecture Skills - 30 points

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