Power BI - Business Intelligence Specialist - Senior

Job Title: Business Intelligence Specialist - Senior

Location: Toronto

Work Model: Onsite

Duration: 12 months

Extension: 1 Time

Must Haves

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

Description / Responsibilities / Skills

Description

• Sr. BI Specialist required to support architecture and development of Power BI to EHS Ambulance Dispatch Decision Support (ADDS) in ODP-HD.
• CSIMB will integrate required new data feeds into the Ministry's data environment to support seamless reporting, system monitoring, and analytics.

Responsibilities Data Architecture (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 CI/CD pipeline design, Non-Functional Requirements
• Architecture review and Sign-Off Package

Responsibilities Power BI Development (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,
• Support testing and deployment, and provide technical documentation and knowledge transfer

Deliverables

• 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

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

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