Requisition Number: RQ11427

Requisition Title: Senior Business Intelligence Specialist

Requisition Location: Toronto, ON

Start Date: 2026-09-08

End Date: 2027-08-27

Description

NOTE

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 Client 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

- 3 years public sector/healthcare experience

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.

Business Analysis Skills

- Solid 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

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

Assignment Type: Onsite - 5 days in the office

MUST HAVES:

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

📌 Senior Business Intelligence Specialist (Toronto)
🏢 NLB Services
📍 Toronto