HR Data Solutions Architect

Duties and Responsibilities

• Serve as the subject-matter expert for HR data domains — core HR, payroll, benefits, talent, time & attendance, and organizational structures — including their business rules, definitions, and lineage.
• Design and govern conceptual, logical, and physical data models for HR data, and implement them across the Medallion architecture (bronze/silver/gold) using Delta Lake on Azure Databricks.
• Lead source-to-target mapping from legacy HR systems and the existing HR Warehouse to the target Lakehouse, applying dimensional modeling to support HR reporting and analytics.
• Identify and document the System of Record (SoR), Single Source of Truth (SSoT), and Single Version of Truth (SVoT) for HR entities, and govern the distinction between them across the Medallion architecture.
• Provide architectural guidance on entity resolution and cross-system key management for HR identifiers (e.g., worker, position, and organization keys) spanning multiple source systems.
• Partner with data engineers to migrate the HR Warehouse and associated integrations, mapping existing HR feeds and pipelines to Databricks-based ingestion patterns.
• Support validation, reconciliation, and cutover between the legacy warehouse and the new platform.
• Contribute to metadata and catalog practices (e.g., Unity Catalog), including lineage representation and business glossary definitions for HR data.
• Champion data quality and ensure sensitive HR/PII data is modeled and handled in line with privacy, security, and compliance requirements.
• Document data dictionaries, models, and source-to-target mappings to serve as authoritative references for HR data on the platform.
• Mentor engineers and analysts on HR data modeling and migration best practices.

Required