Lead Data Architect / Snowflake Technical Architect
OverviewLead Data Architect / Snowflake Technical Architect is required for a Fortune 500 insurance and financial services enterprise. The role focuses on end-to-end solution architecture for a large-scale, multi-wave data modernization program built on a Snowflake + AWS S3 + Matillion + dbt platform with medallion architecture principles. This is a hands-on architecture role, deeply embedded with the delivery team.Role SummaryWe 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 ResponsibilitiesSnowflake, 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.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.Communicate complex concepts clearly and collaborate across engineering, operations, and support teams.Demonstrate a proactive, ownership-driven mindset with high accountability and adaptability to fast-paced, iterative environments.Deliver measurable outcomes such as Wave 1 platform foundation by Month 3, certified data products with SLO targets, standardized templates across workstreams, and acceleration frameworks.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 (e.g., GitHub Copilot, Azure OpenAI), or LLM-based data engineering accelerators.SnowPro Advanced certification (Data Engineer or Architect) is desirable.QualificationsBachelor'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.Ability to lead multi-wave, multi-workstream data modernization programs in regulated environments (insurance, healthcare, or financial services).Hands-on experience migrating legacy ETL (Informatica or SSIS) to modern dbt/Matillion pipelines.J-18808-Ljbffr