Smart IT Frame LLC
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
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.
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.
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.
Seniority level Mid‑Senior level
Employment type Full‑time
Job function Engineering and Information Technology
Industry: Software Development
Location: New York, NY
#J-18808-Ljbffr
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
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.
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.
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.
Seniority level Mid‑Senior level
Employment type Full‑time
Job function Engineering and Information Technology
Industry: Software Development
Location: New York, NY
#J-18808-Ljbffr