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

📌 Business Intelligence SpecialistHealth Services Cluster (Toronto)
🏢 Softline™ Technology
📍 Toronto