What are the responsibilities and job description for the Lead Data Architect / Snowflake Technical Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Intake IT Solutions, is seeking the following. Apply via Dice today!
Job Title: Lead Data Architect / Snowflake Technical Architect
Duration: FTE/Contract
Location: Newport Beach, CA
Key skills: Expert in Snowflake-based data platform architecture, AWS S3 lakehouse (medallion), dbt/Matillion pipelines, and enterprise data modeling, with strong governance (Collibra) and CI/CD practices. large-scale data modernization, AI-enabled data engineering, (insurance/financial)
Bachelor s or Master s degree in computer science, engineering, or related technical discipline.
12 16 years of hands-on platform architecture, Snowflake data mesh, AI-augmented delivery, and enterprise-scale modernization.
12 years in data engineering and analytics with 3 years in a solution/technical architect role on enterprise-scale programs
Deep, hands-on expertise in Snowflake query optimization, clustering, Data Metric Functions, Snowpipe, Streams, and native AI capabilities
Proven experience designing medallion/lakehouse architectures with AWS S3 as the raw data lake layer
Strong command of dbt project structure, macros, testing frameworks, and CI/CD integration
Experience architecting data governance solutions using Collibra catalog, lineage, business glossary, and certification workflows
Demonstrated ability to lead multi-wave, multi-workstream data modernization programs in a regulated (insurance, healthcare, or financial services) environment
Hands-on experience migrating legacy ETL (Informatica or SSIS) to modern dbt/Matillion pipelines
Role Summary
We are looking for a seasoned technical architect to own end-to-end solution architecture for a Fortune 500 insurance and financial services enterprise's large-scale, multi-wave data modernization program. You will design and govern a Snowflake AWS S3 Matillion dbt platform built on medallion architecture principles, define the ACORD-based enterprise data model, and set the technical standards that all delivery workstreams will follow. This is a hands-on architecture role you will be deeply embedded in the delivery team, not a distant reviewer.
Key Responsibilities
Snowflake, AWS S3, Matillion, dbt (data build tool), Collibra, Profisee MDM, Python, SQL, Snowflake Cortex AI, WinAIDM, SnowConvert AI, Tableau, Power BI, CI/CD (Azure DevOps), Git, and the ACORD Data Model.
Architecture & Solution Design
Architect and deliver the enterprise data platform on Snowflake AWS S3 using a medallion (Bronze Silver Gold) architecture, supporting 80 source systems and 7-year historical migration
Design the ACORD Life & Annuity-based enterprise data model customized for insurance domains Policy, Claims, Finance, Actuarial, Agent/Distribution, Customer/Party
Define the data mesh architecture with federated governance, domain ownership boundaries, and self-serve platform patterns for multi-wave delivery
Establish reusable ingestion templates (Matillion), dbt transformation frameworks, and Snowflake-native quality patterns (Data Metric Functions) as cross-program standards
Govern architecture decisions across all 5 parallel workstreams: Ingestion, Transformation, Data Quality/DRE, Consumption, and Governance/MDM
Strong communication skills ability to explain technical concepts clearly.
Proactive, ownership-driven mindset with high accountability.
Ability to collaborate across engineering, operations, and support teams.
Adaptability to fast-paced iterative environments.
The candidate is expected to deliver the following measurable outcomes:
Wave 1 platform foundation (Snowflake environments, AWS S3 data lake, Matillion/dbt/Collibra/Profisee, CI/CD pipelines) delivered by Month 3 with no rework required
All 9 Wave 1 certified data products (CMD Life, Finance, Actuarial) achieve SLO targets: 99.9% completeness, 99.5% accuracy, end-to-end lineage in Collibra
Architecture standards and dbt/Matillion templates adopted consistently across all 5 delivery workstreams no divergence in patterns
WinAIDM accelerator framework implemented and deployed and contributing to 40 50% reduction in data engineering effort vs. baseline
Client technical stakeholders describe WinWire as a "trusted architecture guide" proactive, decision-ready, and commercially aware
Familiarity with ACORD Life & Annuity data standards and insurance domain concepts (Policy, Claims, Actuarial, Reinsurance)
Experience with Profisee MDM or equivalent enterprise MDM platforms
Exposure to Snowflake Cortex AI, AI-assisted development tools (GitHub Copilot, Azure OpenAI), or LLM-based data engineering accelerators
SnowPro Advanced certification (Data Engineer or Architect)
Job Title: Lead Data Architect / Snowflake Technical Architect
Duration: FTE/Contract
Location: Newport Beach, CA
Key skills: Expert in Snowflake-based data platform architecture, AWS S3 lakehouse (medallion), dbt/Matillion pipelines, and enterprise data modeling, with strong governance (Collibra) and CI/CD practices. large-scale data modernization, AI-enabled data engineering, (insurance/financial)
Bachelor s or Master s degree in computer science, engineering, or related technical discipline.
12 16 years of hands-on platform architecture, Snowflake data mesh, AI-augmented delivery, and enterprise-scale modernization.
12 years in data engineering and analytics with 3 years in a solution/technical architect role on enterprise-scale programs
Deep, hands-on expertise in Snowflake query optimization, clustering, Data Metric Functions, Snowpipe, Streams, and native AI capabilities
Proven experience designing medallion/lakehouse architectures with AWS S3 as the raw data lake layer
Strong command of dbt project structure, macros, testing frameworks, and CI/CD integration
Experience architecting data governance solutions using Collibra catalog, lineage, business glossary, and certification workflows
Demonstrated ability to lead multi-wave, multi-workstream data modernization programs in a regulated (insurance, healthcare, or financial services) environment
Hands-on experience migrating legacy ETL (Informatica or SSIS) to modern dbt/Matillion pipelines
Role Summary
We are looking for a seasoned technical architect to own end-to-end solution architecture for a Fortune 500 insurance and financial services enterprise's large-scale, multi-wave data modernization program. You will design and govern a Snowflake AWS S3 Matillion dbt platform built on medallion architecture principles, define the ACORD-based enterprise data model, and set the technical standards that all delivery workstreams will follow. This is a hands-on architecture role you will be deeply embedded in the delivery team, not a distant reviewer.
Key Responsibilities
Snowflake, AWS S3, Matillion, dbt (data build tool), Collibra, Profisee MDM, Python, SQL, Snowflake Cortex AI, WinAIDM, SnowConvert AI, Tableau, Power BI, CI/CD (Azure DevOps), Git, and the ACORD Data Model.
Architecture & Solution Design
Architect and deliver the enterprise data platform on Snowflake AWS S3 using a medallion (Bronze Silver Gold) architecture, supporting 80 source systems and 7-year historical migration
Design the ACORD Life & Annuity-based enterprise data model customized for insurance domains Policy, Claims, Finance, Actuarial, Agent/Distribution, Customer/Party
Define the data mesh architecture with federated governance, domain ownership boundaries, and self-serve platform patterns for multi-wave delivery
Establish reusable ingestion templates (Matillion), dbt transformation frameworks, and Snowflake-native quality patterns (Data Metric Functions) as cross-program standards
Govern architecture decisions across all 5 parallel workstreams: Ingestion, Transformation, Data Quality/DRE, Consumption, and Governance/MDM
Strong communication skills ability to explain technical concepts clearly.
Proactive, ownership-driven mindset with high accountability.
Ability to collaborate across engineering, operations, and support teams.
Adaptability to fast-paced iterative environments.
The candidate is expected to deliver the following measurable outcomes:
Wave 1 platform foundation (Snowflake environments, AWS S3 data lake, Matillion/dbt/Collibra/Profisee, CI/CD pipelines) delivered by Month 3 with no rework required
All 9 Wave 1 certified data products (CMD Life, Finance, Actuarial) achieve SLO targets: 99.9% completeness, 99.5% accuracy, end-to-end lineage in Collibra
Architecture standards and dbt/Matillion templates adopted consistently across all 5 delivery workstreams no divergence in patterns
WinAIDM accelerator framework implemented and deployed and contributing to 40 50% reduction in data engineering effort vs. baseline
Client technical stakeholders describe WinWire as a "trusted architecture guide" proactive, decision-ready, and commercially aware
Familiarity with ACORD Life & Annuity data standards and insurance domain concepts (Policy, Claims, Actuarial, Reinsurance)
Experience with Profisee MDM or equivalent enterprise MDM platforms
Exposure to Snowflake Cortex AI, AI-assisted development tools (GitHub Copilot, Azure OpenAI), or LLM-based data engineering accelerators
SnowPro Advanced certification (Data Engineer or Architect)