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