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