Lead Data Architect (Snowflake)

Job description

Job Title: Lead Data Architect (Snowflake) Location: Newport Beach, CA Work Type: Onsite Employment Type: FTE/Contract Visa Requirement: No OPT / CPT: Open to only: LOCALS: of 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 Domain ) 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, T...