NOTEExtension/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 DocumentData Flow DiagramsConceptual/Logical/Physical Data ModelsDatabricks Lakehouse DesignPower BI Semantic Model DesignRole model and security design, including Row-Level Security DesignData Governance FrameworkData Lineage DocumentationPerformance & Capacity PlanEnvironment and Continuous Integration and Continuous Delivery (CI/CD) pipeline designNon-Functional RequirementsArchitecture review and Sign-Off PackageHands 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 transferExperience RequirementsPublic Sector Experience3 years public sector/healthcare experience5 pointsBusiness Intelligence hands-on development skills7+ 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 pointsBusiness Analysis SkillsStrong experience of working with business team to identify and gather requirements for Business Intelligence enhancements or defect fix itemsExperience in performing deep-dive data analysis to resolve data issues and answer questions from businessExcellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills10 pointsData Architecture Skills7+ 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 pointsSupplier CommentsClosing Date – 2026-08-25, 1:30 p.M.Maximum Number of Submissions – 1 (one)Assignment Type: Onsite – 5 days in the officeMUST HAVES:5+ years of Power BI development experience.7+ years of experience in data architecture. #J-18808-Ljbffr

📌 Business Intelligence Specialist (Rq11427) Health Services Cluster (Toronto)
🏢 Softline™ Technology
📍 Toronto