Quick overview
Job description
ARCHITECTURE LEADERSHIP
-
Develop and evolve the enterprise data architecture blueprint including cloud, on premises, and hybrid environments ensuring alignment with business and analytical/AI needs.
-
Set the direction for modern data integration, event driven design, master data management, and responsible AI enablement.
-
Evaluate current systems and design a practical modernization path forward that reduces technical debt and improves data quality and performance.
DATA PLATFORM AND ENGINEERING DESIGN
-
Lead the architectural design of enterprise data platforms for structured and unstructured data.
-
Architect a medallion platform (Bronze, Silver, Gold) across Microsoft Fabric and Snowflake, defining what lives where and why.
-
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.
-
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.
-
Define cross-platform access patterns (shortcuts, mirroring, external tables) for secure, governed access.
-
Design standards for ingesting data (batch, CDC, event-driven) from policy, claims, CRM, billing, underwriting, and workflow systems.
-
Establish scalable patterns for operational data feeds, partner data exchanges, real-time integration, and analytical pipelines.
-
Define the strategy and technical patterns for managing data copies, extracts, and transformations securely, including when to copy versus virtualize.
COLLABORATION AND LEADERSHIP
-
Partner closely with the Director of Data Strategy to make sure architecture aligns with business priorities.
-
Work with engineering, application teams, analytics, and actuarial groups to ensure efficient, well designed data flows.
-
Provide technical leadership for system modernization efforts and influence guide how data is structured, integrated and maintained across the enterprise.
DATA QUALITY AND GOVERNANCE
-
Define architectural standards that support enterprise data quality, lineage, metadata, and stewardship expectations.
-
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.
-
Establish reliable integration patterns for the company’s core systems.
-
Ensure the architecture meets audit, compliance, and security requirements.
-
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.
TECHNICAL EXECUTION
-
Lead complex architecture reviews, solution designs, technical roadmaps, and build reference architectures.
-
Define semantic modeling standards and consumption patterns supporting Power BI Direct Lake, semantic models, Snowflake data sharing, and AI-ready data products.
-
Assess performance, cost, and scalability trade-offs across Fabric capacity and Snowflake compute.
-
Define semantic layer and consumption patterns (Power BI Direct Lake, Snowflake sharing) and AI-ready data foundations.
-
Oversee proof of concepts, technical assessments, and platform evaluations.
-
Bring structure and clarity to a mixed technology environment with legacy systems and modern cloud services.
QUALIFICATIONS
EDUCATION/CERTIFICATIONS
- EDUCATION: Bachelor's degree in Computer Science, Data Science, or related field, required. Master's degree preferred.
- CERTIFICATIONS: One or more preferred:
-
SnowPro Advanced: Architect or SnowPro Core
-
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
-
Microsoft Certified: Fabric Data Engineer Associate (DP-700)
-
Microsoft Azure Solutions Architect Expert (AZ-305)
-
TOGAF® Enterprise Architecture Certification
-
Certified Data Management Professional (CDMP)
-
DAMA Data Governance Certification
EXPERIENCE
-
12 plus years of experience in data architecture, data engineering, or system integration required.
-
Experience designing metadata-driven ingestion and transformation frameworks across medallion layers, including configuration-based onboarding of new sources.
-
Strong experience with large scale operational systems, transactional databases, and customer-facing platforms.
-
Deep experience with enterprise data feeds, real-time integration patterns, analytical data pipelines, and AI enabling architectures.
-
Experience designing enterprise data models, integration architectures, master and reference data solutions (MDM/RDM), and governed data ecosystems.
-
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.
-
Strong understanding of insurance data, regulatory requirements, and complex transactional systems.
-
Experience designing data models, integration patterns, master data structures, and governed data ecosystems.
WHAT WE OFFER
- Hybrid Work Schedule (up to 2 days work from home)
- Multiple Office Locations - Financial District Downtown or Walnut Creek
- Paid Time Off
- Paid Holidays
- Immediate Vesting of Retirement Savings + Company Match
- Group Health Insurance (Medical, Dental, and Vision)
- Life and AD&D Insurance
- Long Term Disability Insurance
- Hospital Indemnity Insurance
- Accident and Critical Illness Insurance
- Flexible Savings Accounts
- Paid Community Volunteer Day
- Employee Assistance Program
- Tuition Reimbursement Program
- Employee Referral Program
- Diversity, Equity and Inclusion Program
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Similar jobs
- SI
SAP BDC Data ArchitectRecently posted Auto Apply
SAP IT Business Systeme · Miami, FL · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementProcurementProject ManagementTechnology$151.9k - $340.9k/yr - 3C

Senior Consultant - Data Platforms & ArchitectureRecently posted Auto Apply
3Cloud · Remote - US · Remote · Posted 16 Nov 2026 🇺🇸
ArticulateDatabricksIntellectual Property+3Salary not listed - AI

Data Platform Principal Architect, Seattle/San FranciscoRecently posted Auto Apply
Airwallex · US - Seattle · Hybrid · Posted 16 Nov 2026 🇺🇸
ComplianceDatabricksKafka+3Salary not listed - NG

Senior Data ArchitectRecently posted Auto Apply
Nimble Gravity · LATAM (Remote) · Remote · Posted 15 Nov 2026 🇺🇸
SQLApache SparkCompliance+7TechnologySalary not listed - ST

Senior Data ArchitectRecently posted Auto Apply
Steerbridge · Vienna · Hybrid · Posted 13 Nov 2026 🇺🇸
GCPSQLGit+14Technology$150k - $185k/yr - WO
Data Architect/Engineer- Bilingual Korean/ English)Recently posted Auto Apply
Woongjin, Inc · Plano, TX · On-site · Posted 13 Nov 2026 🇺🇸
Microsoft ExcelGenerative AITechnology$110k - $120k/yr - RL

Head of Data (Remote)Recently posted Auto Apply
Rocket Lawyer · California; Colorado ; North Carolina ; Utah · Hybrid · Posted 13 Nov 2026 🇺🇸
GCPSQLSnowflake+8$204.9k - $361.0k/yr - 9W

Database ArchitectRecently posted Auto Apply
9th Way Insignia · United States - Remote · Remote · Posted 12 Nov 2026 🇺🇸
SQLT-SQLAWS+7$78.5k - $88k/yr - V4
Databricks Architect (Remote, US)Recently posted Auto Apply
V4C.ai · United States · Remote · Posted 13 Nov 2026 🇺🇸
SQLApache SparkETL+9Salary not listed - V4
Databricks Architect (hybrid) - Dallas, TXRecently posted Auto Apply
V4C.ai · Dallas, Texas · Hybrid · Posted 13 Nov 2026 🇺🇸
SQLApache SparkETL+9Salary not listed - CO
Technical Lead, Data Strategy Auto Apply
City of New York · Brooklyn, NY · On-site · Posted 10 Nov 2026 🇺🇸
Data AnalysisCI/CDTechnologySalary not listed - ST

Principal Data Architect & Technical Product Owner Auto Apply
Steerbridge · Vienna · Hybrid · Posted 30 Oct 2026 🇺🇸
GCPSQLGit+16Technology$170k - $190k/yr