Business Intelligence Specialist – Power BI (5+ yrs), Data Architecture (7+ yrs), Advanced SQL, DAX, Databricks, Azure Data Factory
Offre en anglaisThe role involves designing data architecture, including semantic models and CI/CD pipelines, for the ADDS Power BI solution. Additionally, the specialist will develop Power BI reports, implement DAX measures, and optimize performance using Databricks data sources.
- Sur place
- Toronto, ON
- Publié 24 août 2026
- Postuler avant le 23 sept. 2026
- 1 poste
D’autres postes auxquels postuler directement
Des possibilités semblables publiées par des employeurs qui recrutent sur Jobs.ca, sans formulaire externe.
Résumé du poste
Title Business Intelligence Specialist Description 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 Skills Experience and Skill Set 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. · 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. 30 points Assignment Type: Onsite - 5 days in the office MUST HAVES: · 5+ years of Power BI development experience. · 7+ years of experience in data architecture.
Ce que vous ferez
The role involves designing data architecture, including semantic models and CI/CD pipelines, for the ADDS Power BI solution. Additionally, the specialist will develop Power BI reports, implement DAX measures, and optimize performance using Databricks data sources.
Exigences
Candidates must have over 7 years of experience in data architecture and at least 5 years of Power BI development. Expertise in SQL, DAX, and Azure data tools, along with public sector or healthcare experience, is highly preferred.
Compétences indiquées
- Power BISouhaitée
- SQLSouhaitée
- CI/CDSouhaitée
- Analyse d’affairesSouhaitée
Autres compétences pertinentes
Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.
- Power BI
- Data Architecture
- SQL
- DAX
- Databricks
- Azure Data Factory
- Dimensional Modeling
- Star Schemas
- Data Governance
- Row-Level Security
- CI/CD
- Power Query
- Data Lake
- Synapse
- Stakeholder Management
- Business Analysis
Domaines d’emploi
- Data & Analytics
- Technology
- Government & Public Sector
- Consulting
- Software
Renseignements supplémentaires
- Expérience minimale
- 10+ ans
- Postuler avant le
- 23 sept. 2026
- Langue de l’offre
- anglais
- Heures de travail
- 37 heures par semaine
- Niveau d’expérience
- Mid-Senior level
- Mode de candidature
- La candidature directe est offerte