Retour à la recherche
CC

Business Intelligence Specialist – Power BI (5+ yrs), Data Architecture (7+ yrs), Advanced SQL, DAX, Databricks, Azure Data Factory

Offre en anglais

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.

  • 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