Loading, Please wait..!!
Principal Data Architect
-
Posted on: Nov 16, 2026
-
Bodega Bay, California
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Principal Data Architect roles in California.
View Salary Guide →Find your match !
Job Title :
Principal Data Architect
Job Type :
Full-Time
Job Location :
Bodega Bay California United States
Remote :
No
Job Description :
Job Description
- \n
- \n
Develop and evolve the enterprise data architecture blueprint including cloud, on premises, and hybrid environments ensuring alignment with business and analytical/AI needs.
\n
- \n
- \n
Set the direction for modern data integration, event driven design, master data management, and responsible AI enablement.
\n
- \n
- \n
Evaluate current systems and design a practical modernization path forward that reduces technical debt and improves data quality and performance.
\n
- \n
- \n
Lead the architectural design of enterprise data platforms for structured and unstructured data.
\n
- \n
- \n
Architect a medallion platform (Bronze, Silver, Gold) across Microsoft Fabric and Snowflake, defining what lives where and why.
\n
- \n
- \n
Design a metadata-driven lakehouse architecture across Bronze (raw ingestion), Silver (conformed and quality-controlled), and Gold (business-ready data products) layers, leveraging declarative metadata to drive ingestion pipelines, transformation logic, lineage, quality controls, partitioning strategies, and workload orchestration.
\n
- \n
- \n
Establish Iceberg and Delta Lake as strategic open table standards, enabling ACID transactions, time travel, schema evolution, and cross-platform interoperability between OneLake, Snowflake, and downstream analytics workloads.
\n
- \n
- \n
Define cross-platform access patterns (shortcuts, mirroring, external tables) for secure, governed access.
\n
- \n
- \n
Design standards for ingesting data (batch, CDC, event-driven) from policy, claims, CRM, billing, underwriting, and workflow systems.
\n
- \n
- \n
Establish scalable patterns for operational data feeds, partner data exchanges, real-time integration, and analytical pipelines.
\n
- \n
- \n
Define the strategy and technical patterns for managing data copies, extracts, and transformations securely, including when to copy versus virtualize.
\n
- \n
- \n
Partner closely with the Director of Data Strategy to make sure architecture aligns with business priorities.
\n
- \n
- \n
Work with engineering, application teams, analytics, and actuarial groups to ensure efficient, well designed data flows.
\n
- \n
- \n
Provide technical leadership for system modernization efforts and influence guide how data is structured, integrated and maintained across the enterprise.
\n
- \n
- \n
Define architectural standards that support enterprise data quality, lineage, metadata, and stewardship expectations.
\n
- \n
- \n
Experience implementing enterprise data governance using Microsoft Purview and Microsoft Fabric governance capabilities, including data cataloging, lineage tracking, sensitivity labeling, data quality monitoring, access controls, and compliance reporting.
\n
- \n
- \n
Establish reliable integration patterns for the company’s core systems.
\n
- \n
- \n
Ensure the architecture meets audit, compliance, and security requirements.
\n
- \n
- \n
Embed data quality checks, lineage, and classification tagging into the metadata-driven framework at each layer boundary, so governance is built in rather than added later.
\n
- \n
- \n
Lead complex architecture reviews, solution designs, technical roadmaps, and build reference architectures.
\n
- \n
- \n
Define semantic modeling standards and consumption patterns supporting Power BI Direct Lake, semantic models, Snowflake data sharing, and AI-ready data products.
\n
- \n
- \n
Assess performance, cost, and scalability trade-offs across Fabric capacity and Snowflake compute.
\n
- \n
- \n
Define semantic layer and consumption patterns (Power BI Direct Lake, Snowflake sharing) and AI-ready data foundations.
\n
- \n
- \n
Oversee proof of concepts, technical assessments, and platform evaluations.
\n
- \n
- \n
Bring structure and clarity to a mixed technology environment with legacy systems and modern cloud services.
\n
- \n
- EDUCATION: Bachelor's degree in Computer Science, Data Science, or related field, required. Master's degree preferred. \n
- CERTIFICATIONS: One or more preferred: \n \n\n
- \n
- \n
SnowPro Advanced: Architect or SnowPro Core
\n
\n\n- \n
- \n
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
\n
\n\n- \n
- \n
Microsoft Certified: Fabric Data Engineer Associate (DP-700)
\n
\n\n- \n
- \n
Microsoft Azure Solutions Architect Expert (AZ-305)
\n
\n\n- \n
- \n
TOGAF® Enterprise Architecture Certification
\n
\n\n- \n
- \n
Certified Data Management Professional (CDMP)
\n
\n- \n
- \n
DAMA Data Governance Certification
\n
\n - \n
- \n
- \n
12 plus years of experience in data architecture, data engineering, or system integration required.
\n
- \n
- \n
Experience designing metadata-driven ingestion and transformation frameworks across medallion layers, including configuration-based onboarding of new sources.
\n
- \n
- \n
Strong experience with large scale operational systems, transactional databases, and customer-facing platforms.
\n
- \n
- \n
Deep experience with enterprise data feeds, real-time integration patterns, analytical data pipelines, and AI enabling architectures.
\n
- \n
- \n
Experience designing enterprise data models, integration architectures, master and reference data solutions (MDM/RDM), and governed data ecosystems.
\n
- \n
- \n
Hands-on experience architecting medallion platforms on Microsoft Fabric and/or Snowflake, with working knowledge of Iceberg and Delta table formats and cross-platform interoperability.
\n
- \n
- \n
Strong understanding of insurance data, regulatory requirements, and complex transactional systems.
\n
- \n
- \n
Experience designing data models, integration patterns, master data structures, and governed data ecosystems.
\n
- \n
- Hybrid Work Schedule (up to 2 days work from home) \n
- Multiple Office Locations - Financial District Downtown or Walnut Creek \n
- Paid Time Off \n
- Paid Holidays \n
- Immediate Vesting of Retirement Savings + Company Match \n
- Group Health Insurance (Medical, Dental, and Vision) \n
- Life and AD&D Insurance \n
- Long Term Disability Insurance \n
- Hospital Indemnity Insurance \n
- Accident and Critical Illness Insurance \n
- Flexible Savings Accounts \n
- Paid Community Volunteer Day \n
- Employee Assistance Program \n
- Tuition Reimbursement Program \n
- Employee Referral Program \n
- Diversity, Equity and Inclusion Program \n
Position Details
Posted:
Nov 16, 2026
Reference Number:
347e1cd6
Employment:
Full-time
City:
Bodega Bay
Job Origin:
ziprecruiter
Share this job:
Please wait..!!

