Consulting Senior Data Architect (Microsoft Fabric Focus)

• It is a 100% Remote position in Canada.

• Candidates Preferred from EST/CST Time Zone.

• 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).

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

• 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).

• 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).

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

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

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

• Participate in architectural governance and provide architecture review/sign-off, with authority to mandate standards when necessary to protect platform integrity

• Partner closely with platform engineering to align patterns across identity, network, DevOps, and security.

• Hands-on architect: you can design and build the critical Fabric artifacts to prove patterns.

• Platform-oriented: you think in reusable standards, templates, and repeatable governance.

• Strong consultative presence: you can advise product teams while also driving decisions and outcomes.

• Comfortable with authority: you can mandate standards when required to protect the platform and business.

• Documentation discipline: you produce clear ADRs, standards, and operating playbooks.

• Supports product teams through office hours and project-based sprints.

• Works primarily with: Azure lead architect, security architect/engineer, DevOps platform engineer, and product engineering teams.

• Data ownership remains with product teams; this role defines the how (standards/patterns/governance), not centralized ownership.

• Target-state architecture

• Data model standards: conceptual / logical / physical + templates

• Domain-oriented data product patterns and operating guidance

• Governance model: classification, retention, lineage, access controls

• Fabric workspace strategy + operating model (environments, isolation, ownership, lifecycle)

• CI/CD approach for Fabric artifacts integrated with platform guardrails

• IaC approach using Terraform for Fabric-related configuration and

• Cost model + capacity planning strategy (SKU sizing, isolation, show back/chargeback)

• Architecture Decision Records (ADRs) for key platform decisions

• 10+ years in data architecture/data engineering roles, including platform-scale design.

• Proven Microsoft Fabric production implementations you have delivered Fabric solutions that run in production with real operational constraints.

• Deep hands-on expertise in Fabric areas central to our rollout:

• Data Engineering

• Data Factory (pipelines)

• Real-time analytics / Event Streams

• Strong architecture capability across mixed data types: transactional, telemetry/events, documents, geospatial, time series.

• Demonstrated experience implementing and governing:

• Data modeling standards (conceptual/logical/physical)

• Data governance (classification, retention, lineage)

• Security patterns using Entra ID, RBAC, workspace-level controls

• Compliance guardrails for GDPR, ISO 27001, and data residency

• Strong DevOps fluency:

• CI/CD patterns and operational delivery

• Terraform as mandatory IaC for repeatability and standardization

• Ability to define standards and enforce guardrails while maintaining a delivery-first, pragmatic approach.

• Experience supporting IoT and telemetry-heavy product ecosystems.

• Experience designing data quality frameworks and SLAs for operational analytics and near-real-time processing.

• Familiarity integrating observability/security signals into Log Analytics and Sentinel.

Omm IT Solutions