Lead Data Architect

• Lead the design and implementation of end‑to‑end Microsoft Fabric data architecture.
• Drive development of a lakehouse-based data platform using Bronze, Silver, and Gold layers.
• Oversee data ingestion, transformation, and integration from multiple sources (Postgres, APIs).
• Act as a technical leader and architect, ensuring scalable, reliable, and high‑quality data solutions.
• Translate business requirements into data models, data products, and architecture decisions.
• Enable adoption through knowledge transfer, best practices, and reusable frameworks.

Responsibilities

Technical Leadership & Architecture

• Design end‑to‑end data architecture in Microsoft Fabric.
• Define ingestion frameworks for:
  • AutoLeap (Postgres, partner APIs)
• Establish Bronze, Silver, and Gold data layers (medallion architecture).
• Define lakehouse strategy and semantic data models.
• Set standards for:
  • Change data capture (CDC) and incremental loads
  • Global identifiers (customer, vehicle, store)
  • Data quality, auditing, and reconciliation

Data Integration & Engineering

• Oversee development of:
  • Data pipelines (Fabric Pipelines, Notebooks)
  • Data staging, transformations, and conformance
• Consolidate multiple data sources (ICDB, DME) into a unified lakehouse.
• Ensure outbound data feeds meet requirements for:
  • Power BI reporting
  • External partners (e.g., RRD)
  • Internal systems (SAP, Oracle, Business Center)

Requirements & Mapping

• Lead structured requirements gathering with stakeholders.
• Translate business requirements into:
  • Canonical POS data models
  • Gold layer data products
• Validate and align mappings with source systems (AutoLeap schemas).

Testing & Quality Assurance

• Define and execute:
  • Data completeness and validation checks
  • Reconciliation with legacy systems (ICDB/DME)
  • Performance and refresh SLAs
• Develop formal:
  • Test plans
  • Acceptance criteria