Senior Data Architect

Role Overview

We are seeking a
Senior Data Architect
with strong experience in Azure, Databricks, Data Vault, and enterprise data modeling to support data modernization initiatives across insurance business units. This role focuses on designing standardized, scalable data models and developing reusable data components that support analytics, reporting, and operational use cases across P&C and L&A domains.

Key Responsibilities

Data Modeling & Design

• Design and maintain enterprise data models using Data Vault 2.0, dimensional modeling (Kimball), and normalized approaches (Inmon).
• Develop modular, reusable model components that can be adapted across multiple business entities.
• Build curated datasets and support the development of data products for business consumption.

Architecture & Implementation

• Work with engineering teams to implement models on Azure and Databricks platforms.
• Align data model designs with ETL/ELT pipelines, ingestion frameworks, and BI/reporting tools.
• Ensure models support performance, scalability, and data quality requirements.

Standards & Governance

• Establish and maintain modeling standards, documentation guidelines, metadata structures, and lineage requirements.
• Promote consistency and adherence to data governance practices across teams.

Collaboration & Leadership

• Work closely with business stakeholders to translate requirements into data model designs.
• Provide guidance and mentorship to junior data modelers.
• Serve as a subject matter expert for data modeling methodologies and modern data architecture practices.

Required Skills & Experience

• 10–12 years of experience in data architecture, data modeling, or data warehousing.
• Strong expertise in Data Vault 2.0, including hub, link, and satellite design.
• Hands-on experience with Azure (ADF, Synapse, ADLS) and Databricks.
• Deep understanding of Kimball and Inmon modeling techniques.
• Proficiency in SQL and ELT/ETL concepts.
• Experience with metadata management and modeling documentation.
• Insurance industry experience in
  P&C and/or L&A
  (policy, claims, underwriting, billing, actuarial, etc.).
• Strong communication and collaboration skills; able to guide junior team members