Role Summary :

We are seeking a Data Architect to own canonical data modeling and abstraction discipline across our platforms, most notably our payroll-system-agnostic platform built on a Common Data Model (CDM). This role is distinct from a Data Integration Architect: you own the correctness of the model itself - how source-system concepts get abstracted into stable canonical entities.

Key Responsibilities :

- Own canonical data modeling: define stable, source-agnostic entities and relationships that represent the business domain.

- Design config-driven architecture: ensure new source systems, clients, or field variations are onboarded through configuration.

- Enforce correctness and reconciliation discipline: define and validate that canonical data reconciles against source system totals.

- Own production engineering and abstraction discipline: review and approve how abstraction layers are implemented in code.

- Partner with Solution and Data Integration Architects to ensure platform coherence.

Required Qualifications :

- 8+ years of total experience in data architecture or data modeling roles.

- Strong hands-on experience with dimensional and canonical data modeling.

- Demonstrated experience designing config-driven architecture for onboarding new data sources.

- Proficiency in SQL and Python; experience with PostgreSQL.

- Hands-on proficiency with AI coding assistants (Claude, Copilot, Cursor, etc.).

Tech Stack :

- SQL, Python, PostgreSQL, Azure, Orchestration tools (Prefect/Airflow/Dagster).