Enterprise Data Architect

Role Purpose

We are building a reusable, enterprise-grade Gold Layer consisting of a conformed Common Data Model (CDM) and enterprise semantic layer that serves dashboards, self-service BI, APIs, and AI/Copilot capabilities from a single governed source of truth.

We are seeking an experienced Enterprise Data Architect for a focused 3-month engagement to assess the current Bronze–Silver data platform and design the Gold Layer architecture and operating model across a complex, multi-entity healthcare environment.

This is not a report development role. You will evaluate the end-to-end analytics platform—including architecture, scalability, governance, semantic modelling, and AI readiness—and define the architectural direction required to deliver a reusable, future-proof enterprise data foundation.

The primary objective is to determine whether the current data platform can support a reusable Gold Layer and semantic model and, where gaps exist, define the architectural changes required before implementation.

Key Responsibilities

• Assess the end-to-end analytics architecture (source systems → CDC → Bronze → orchestration → Silver), evaluating Bronze completeness and Silver readiness by mapping business KPIs to transformation logic, source tables, and data lineage.
• Design the enterprise Common Data Model (CDM) , including conformed dimensions, shared facts, grain definitions, surrogate keys, and Slowly Changing Dimensions (SCDs) to enable reusable analytics across dashboards, APIs, and AI applications.
• Define the enterprise semantic layer, including standardized KPI definitions (e.g., Length of Stay, Readmission Rate, Turnaround Time), business hierarchies, Row-Level Security (RLS), metadata, and business glossary.
• Recommend the optimal Gold Layer implementation approach, evaluating:
  • Native SQL/Stored Procedures with orchestration and BI semantic models
  • Modern analytics engineering using dbt, enterprise catalog, and universal semantic layers
  • Hybrid architecture where appropriate
• Establish enterprise governance, security, and AI readiness, including:
  • Metadata management
  • Business glossary
  • Data catalog and lineage
  • Master Data Management (MDM)
  • PHI governance
  • Audit controls
  • AI-ready metadata for Copilot and intelligent agents
• Provide architectural leadership through governance reviews and collaborate with executive stakeholders, business SMEs, clinical stakeholders, and delivery teams.
• Produce a build-ready architecture blueprint and transition documentation for implementation teams.

Required Experience

• 10–15+ years of experience in Enterprise Data & Analytics.
• Proven experience designing enterprise data warehouses, lakehouses, or modern analytics platforms.
• Demonstrated delivery of:
  • Medallion Architecture (Bronze/Silver/Gold)
  • Enterprise Common Data Models
  • Semantic Layers
  • Enterprise Analytics Platforms
• Experience transforming siloed reporting environments into reusable enterprise data products.
• Strong stakeholder management skills with experience presenting architecture to senior leadership and governance boards.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related discipline.

Required Technical Skills

Enterprise Architecture & Data Modelling

• Enterprise Data Architecture
• Medallion Architecture (Bronze / Silver / Gold)
• Common Data Models (CDM)
• Enterprise Data Warehousing
• Dimensional Modelling
• Kimball Methodology
• Star Schema Design
• Semantic Layer Architecture

Data Engineering

• Advanced SQL
• ETL / ELT Design
• Apache Airflow
• dbt
• Change Data Capture (CDC)
• Oracle GoldenGate
• SingleStore
• SQL Server
• Oracle Database
• Data Quality Frameworks

Business Intelligence, Governance & AI

• Microsoft Power BI
• Tabular Models
• DAX
• Row-Level Security
• Business Glossary
• Metadata Management
• Data Catalog
• Data Lineage
• Microsoft Purview and/or Collibra
• Master Data Management (MDM)
• AI Enablement
• Retrieval-Augmented Generation (RAG)
• Vector Search Concepts
• Microsoft Copilot
• Model Context Protocol (MCP)
• Performance Optimization
• PHI Governance
• Identity & Access Management (IAM/Active Directory)

Healthcare Experience (Preferred)

Experience working with healthcare information systems and standards, including:

• Cerner
• Epic
• HL7
• FHIR
• Laboratory Information Systems (LIS)
• Clinical Data Warehouses
• Hospital Analytics
• Population Health Analytics

Preferred Certifications

• Microsoft Certified: Azure Solutions Architect Expert
• Microsoft Certified: Azure Data Engineer Associate
• DAMA Certified Data Management Professional (CDMP)
• Kimball Dimensional Modeling
• TOGAF