Director, Data Architecture

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.

Service Experts Heating & Air Conditioning is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

The job description is not intended to be a complete list of all responsibilities, duties or skills required for the job and is subject to review and change at any time, with or without notice, in accordance with the needs of Service Experts.

Service Experts is committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to participate in the application and hiring process. To request an accommodation, please email [email protected]