Director, Data Architecture at Service Experts LLC

, , -

Full Time

Start Date

Immediate

Expiry Date

17 Apr, 26

Salary

0.0

Posted On

17 Jan, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Architecture, Databricks, Dimensional Modeling, Data Governance, Production-Grade Pipelines, Delta Lake, CDC, SCD Type 2, Power BI, KPI Catalog, Data Quality Checks, CI/CD, Stakeholder Management, Schema Evolution, Unity Catalog, GitOps

Industry

Consumer Services

Description

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 talentacquisition@serviceexperts.com

Responsibilities

The Director, Data Architecture will design and implement the Databricks Lakehouse architecture, ensuring data is trusted and accessible for various business units. Key responsibilities include establishing governance standards, building production-grade pipelines, and enabling analytics and BI.