Data Architect & Canonical Model Lead
Core
Design and enforce canonical data models for policy, customer, and distributor domains across multiple systems, ensuring consistency and accuracy in a regulated environment.
Role type
Senior IC data architect (canonical modeling & AWS data platform)
Builds
Cross-system entity models, warehouse/lakehouse schemas, event/API contracts, and automated data quality pipelines
Domain
Financial Services & Insurance, Data Architecture & Engineering
Required skills
Canonical data modeling, Cross-system entity modeling, AWS data platform design, SQL, Python, ETL/ELT design, Infrastructure as code, Automated data quality, Data governance, CI/CD practices
Preferred skills
Insurance/financial services domain knowledge, ACORD/OMG data models, Master data management, Event streaming, Legacy modernization
Technologies
AWS (S3, Glue, Athena, Redshift, Lake Formation), dbt, Terraform, Kafka, Iceberg, Delta Lake, Erwin, SQLDBM
Responsibilities
Own canonical data model reconciliation across teams, Design and maintain cross-system entity models, Translate canonical models into physical implementations, Define and enforce data contracts with breaking-change detection, Design integration patterns across batch and streaming, Embed automated data quality into pipelines, Design access controls and masking for regulated environments
Seniority
Senior, hands-on IC
