Data Architect (Snowflake Optimization)
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Xoriant Corporation, is seeking the following. Apply via Dice today!RESUMES without LINKEDIN profile wont get any response.Position Title: Data Architect (Snowflake Optimization)Location: 6 Months with possibility of extensionDuration: Portland, OR (Hybrid 3 days)Role SummaryThe Senior Snowflake Optimization Engineer will lead the assessment, rearchitecture, and optimization of PGE s Snowflake data platform.This role will act as the technical lead and primary onsite interface for Snowflake optimization initiatives, working closely with PGE stakeholders, data engineering teams, and Matillion pipelines.Key ResponsibilitiesSnowflake Cost & Performance OptimizationAssess current Snowflake warehouse usage, sizing, autoscaling, and autosuspend configurations.Identify cost drivers across Matillion jobs, adhoc analytics, and background workloads.Optimize warehouse strategies (multicluster usage, workload isolation, resource monitors).Analyze query history and execution plans to reduce compute inefficiencies.Architecture & ReengineeringReview existing Snowflake schemas, tables, tasks, and pipelines for architectural improvements.Recommend and implement Snowflakenative optimizations (dynamic tables, tasks, result caching where appropriate).Evaluate opportunities for hybrid compute (external tables, Iceberg, Spark/EMR) where costeffective.Advise on data lifecycle, retention, and archival strategies to reduce storage footprint.Matillion & Pipeline OptimizationReview Matillion ELT jobs for Snowflake best practices (pushdown transforms, avoiding rowbyrow logic).Improve pipeline execution efficiency and runtime SLAs.Define reusable optimization patterns and templates.Governance & Cost ControlHelp establish cost governance, monitoring, and guardrails.Support chargeback / showback models if required by PGE.Provide recommendations to ensure savings are sustainable postengagement.Stakeholder & Delivery LeadershipAct as the onsite technical lead, coordinating with PGE architects, developers, and business users.Lead technical workshops, optimization reviews, and recommendations walkthroughs.Provide documentation, implementation guidelines, and knowledge transfer to PGE teams.Support stabilization and postimplementation tuning.Technical SkillsRequired Skills & ExperienceStrong handson experience with Snowflake architecture, performance tuning, and cost optimizationDeep understanding of:Snowflake warehouses, clustering, caching, tasks, dynamic tablesQuery profiling and execution plansExperience with Matillion ELT on SnowflakeSolid knowledge of AWS (S3, security, cost considerations)SQL performance tuning and data modeling experienceGood to HaveExperience with Iceberg / external tables / Spark or EMRExposure to Snowflake Cortex or advanced Snowflake featuresCI/CD for data platforms (GitHub/GitLab/Jenkins)Data governance and cost management frameworksExperience Level8 12+ years in data engineering / cloud data platforms3 5+ years of focused Snowflake optimization experiencePrior experience in onsite consulting or lead roles preferred