Crawford Services, Inc.
Position Summary
The Director, Data Architecture will own the design and implementation of our Databricks Lakehouse architecture, including bronze/silver/gold layers, dimensional modeling, data governance, and production-grade pipelines. This role ensures that our data is trusted, accessible, and actionable for business units across Operations, Finance, Marketing, and beyond.
Key Responsibilities
Architect & Implement Lakehouse Standards
Define and enforce bronze/silver/gold layer standards in Databricks.
Design conformed dimensional models (e.g., dim_center, dim_customer, dim_technician) and star-schema gold marts.
Governance & Compliance
Implement Unity Catalog for access control, lineage, and PII classification.
Establish data contracts, schema evolution policies, and metric governance processes.
Pipeline Development
Build production-grade pipelines using Delta Lake, Databricks Workflows, and Delta Live Tables.
Implement CDC and SCD Type 2 patterns for dimensions and facts.
Enable Analytics & BI
Deliver curated datasets and semantic layers for Power BI and Databricks SQL.
Define and maintain KPI catalog for consistent business reporting.
Operational Excellence
Stand up data quality checks, observability dashboards, and incident runbooks.
Drive CI/CD best practices for data (GitOps, automated testing, environment promotion).
Leadership & Collaboration
Act as Data Product Owner for core domains (Service Ops, Finance, Marketing).
Partner with IT, Security, and business stakeholders to align data strategy with corporate goals.
Qualifications Required
7+ years in data architecture or analytics engineering, with at least 2 years in Databricks Lakehouse (Delta Lake, Unity Catalog, Workflows).
Expert in dimensional modeling (Kimball), CDC, and SCD Type 2 implementations.
Strong experience with CI/CD for data pipelines and governance frameworks.
Proven ability to establish data contracts and manage schema evolution.
Excellent communication and stakeholder management skills.
Preferred
Experience in field services, HVAC, plumbing, or similar industries.
Familiarity with Power BI semantic modeling and performance tuning.
Knowledge of dbt or similar transformation frameworks.
#J-18808-Ljbffr
Key Responsibilities
Architect & Implement Lakehouse Standards
Define and enforce bronze/silver/gold layer standards in Databricks.
Design conformed dimensional models (e.g., dim_center, dim_customer, dim_technician) and star-schema gold marts.
Governance & Compliance
Implement Unity Catalog for access control, lineage, and PII classification.
Establish data contracts, schema evolution policies, and metric governance processes.
Pipeline Development
Build production-grade pipelines using Delta Lake, Databricks Workflows, and Delta Live Tables.
Implement CDC and SCD Type 2 patterns for dimensions and facts.
Enable Analytics & BI
Deliver curated datasets and semantic layers for Power BI and Databricks SQL.
Define and maintain KPI catalog for consistent business reporting.
Operational Excellence
Stand up data quality checks, observability dashboards, and incident runbooks.
Drive CI/CD best practices for data (GitOps, automated testing, environment promotion).
Leadership & Collaboration
Act as Data Product Owner for core domains (Service Ops, Finance, Marketing).
Partner with IT, Security, and business stakeholders to align data strategy with corporate goals.
Qualifications Required
7+ years in data architecture or analytics engineering, with at least 2 years in Databricks Lakehouse (Delta Lake, Unity Catalog, Workflows).
Expert in dimensional modeling (Kimball), CDC, and SCD Type 2 implementations.
Strong experience with CI/CD for data pipelines and governance frameworks.
Proven ability to establish data contracts and manage schema evolution.
Excellent communication and stakeholder management skills.
Preferred
Experience in field services, HVAC, plumbing, or similar industries.
Familiarity with Power BI semantic modeling and performance tuning.
Knowledge of dbt or similar transformation frameworks.
#J-18808-Ljbffr