Lead Data Architect (Semantic Layer)

Role Overview

We are seeking a Senior Semantic Layer Data Architect to lead the design implementation and evolution of a centralized semantic layer on Databricks. This role enables governed scalable and reusable data products across the enterprise while ensuring metric consistency trust and business alignment.

This position sits at the intersection of data architecture analytics engineering and governance partnering closely with stakeholders across the enterprise.

General Responsibilities

• Own and evolve the enterprise semantic layer strategy including modeling standards metric design and governance patterns.
• Define and maintain conformed dimensions canonical entities standardized KPIs and curated analytic views.
• Design and operate a trusted enterprise metrics layer to eliminate metric drift across Power BI dashboards and teams.
• Partner with Marketing Supply Chain Operations and Finance stakeholders to define KPI logic grains hierarchies and calculation rules.
• Establish governance processes for metric versioning change management and impact analysis.
• Leverage Databricks Unity Catalog to enforce access controls classification lineage and auditability for semantic assets.
• Enable consistent analytics consumption through star schemas aggregated views and certified datasets.
• Provide semantic leadership for enterprise domains applying CPG/QSR/Retail industry context.
• Create enterprise semantic modeling standards templates playbooks and enablement materials.
• Guide and review domain semantic implementations to ensure alignment with central standards and best practices.

Qualifications :

• 10 years of experience in data architecture analytics engineering BI architecture or related roles.
• Proven experience designing and operating an enterprise semantic layer or governed metrics framework.
• Strong handson experience with Databricks (Delta Lake Databricks SQL).
• Deep expertise in dimensional modeling including fact/dimension design conformed dimensions and grain management.
• Advanced SQL skills and strong understanding of analytical query patterns.
• Experience enabling enterprise analytics through Power BI.
• Excellent written and verbal communication skills with technical and business audiences.

Preferred Qualifications

• Experience with Databricks Unity Catalog for governance and semantic asset management.
• Background in CPG QSR or Retail domains particularly Finance Marketing or Supply Chain analytics.
• Experience operating within a centralized data platform or semantic layer center of excellence.
• Familiarity with data product operating models data quality frameworks and observability.

Additional Information :

Benefits:
    Paid Holidays and Vacation 
    Medical Dental & Vision benefits that start on the first day of employment
    No-cost mental health support for employee and dependents
    Childcare tuition discounts
    No-cost fitness nutrition and wellness programs 
    Fertility benefits
    Adoption assistance
    401k matching contributions 
    15% off the purchase price of stock 
    Company bonus 
 

Remote Work :

No

Employment Type :

Full-time