Consulting Senior Data Architect (Microsoft Fabric Focus)

Category: IT Services

Location: Montreal Quebec Canada

PLEASE NOTE:

- It is a 100% Remote position in Canada.

- Candidates Preferred from EST/CST TimeZone.

JOB SUMMARY:
We are seeking a Consulting Senior Data Architect with deep, production-grade Microsoft Fabric experience to accelerate our active rollout of Fabric for customer-facing and revenue-impacting digital products hosted in Azure. This is a hands-on role responsible for designing and building Fabric artifacts (pipelines, lakehouses, eventstream/real-time patterns), defining data architecture standards (conceptual/logical/physical), and implementing governance and security guardrails that scale across multiple product teams.

Key Responsibilities:

Microsoft Fabric Enablement (Hands-onDelivery + Standardization)

- Architect and implement Fabric solutions for data engineering (Spark), Data Factory pipelines , and real-time analytics / Event streams aligned to digital product needs.

- Build and standardize Fabric patterns for ingestion, transformation, and serving across workloads including operational analytics, near-real-time, batch, and data science/ML.

- Create repeatable reference implementations for common digital product scenarios (IoT telemetry, time series, transactional + event fusion, documents, geospatial).

Unified Data Platform Architecture (TargetState + Roadmap)

- Produce and maintain the target-state architecture for Fabric-based data platform capabilities.

- Define domain-oriented data product patterns including how shared/enterprise datasets are curated and reused.

- Establish architectural boundaries and integration guidance for shared datasets vs. product-owned datasets.

Data Modeling Standards (Conceptual / Logical/ Physical)

- Define and enforce data modeling standards and templates appropriate to Fabric Lakehouse/Warehouse patterns and product analytics needs.

- Provide modeling guidance for high-variance data types (telemetry, geospatial, documents) and hybrid operational-analytics use cases.

- Define standards for schema evolution, versioning, and contract-first data interfaces (where applicable).

Governance, Security, and Compliance byDesign

- Design and implement a governance model covering classification, retention, lineage, and auditability.

- Ensure compliance guardrails are built into delivery patterns and operational processes to meet GDPR, ISO 27001, and data residency requirements.

- Define and enforce Fabric access controls using Entra ID, RBAC, and workspace-level controls (including guidance for separation of duties and least privilege).

CI/CD + Infrastructure as Code (IaC) forFabric

- Define and implement a CI/CD approach for Fabric artifacts as the enterprise source of truth.

- Establish release patterns for Fabric changes (promotion strategy, environment separation, approvals, and quality gates) aligned to platform standards.

- Manage Fabric-related platform configuration using Terraform as the IaC approach (including reusable modules/patterns).

- Create golden path templates and guidance that product teams can adopt with minimal friction.

Capacity Planning, Cost Model, andChargeback/Show back

- Design Fabric capacity strategy (SKU sizing, workload isolation, scaling model) to support multiple products reliably.

- Define guardrails and operational practices that reduce waste and improve predictability.

Reliability, Observability, and OperationalReadiness

- Define reliability patterns and operational standards for data pipelines and real-time workloads.

- Integrate logging/monitoring with Log Analytics and security monitoring with Sentinel, including alerting and incident response considerations.

- Define and operationalize data quality SLAs (freshness, completeness, accuracy, timeliness) and embed quality checks into delivery pipelines.

Consulting Engagement + Governance Forums

- Participate in architectural governance and provide architecture review/sign-off, with authori