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