Snowflake Data Architect at The Ash GroupW2 Contract Only – No C2C – No 3rd PartiesSummaryThe Ash Group is hiring an experienced Snowflake Data Architect for our client, a trusted financial services and media company offering investing advice, stock research, and education to individual investors, based remotely in one of the approved US states below.This is a strategic role requiring 7+ years of data architecture experience, focused on leading the evolution of a Snowflake cloud data warehouse environment. You will be responsible for setting architectural standards, driving major cost optimization efforts, and ensuring scalable analytics across the enterprise.Compensation: Competitive pay rate of $70 per hour.Benefits: Medical, dental, vision, and direct primary care benefits. After six months of employment, enjoy a 4% matched 401(k) plan with immediate 100% vesting.Duration: 12-month contract (ongoing).Location: 100% Remote but must be located in one of the following states : CA, CO, FL, LA, MD, MA, NJ, NY, NC, OR, PA, SC, TN, TX, VA, WA DC, or WI.What You'll Be DoingLead Snowflake platform architecture across U.S. and International instances, implementing and adhering to medallion-layer principles and scalable data modeling standards.Drive significant cost optimization efforts by performing query tuning, resource configuration, and architectural improvements (ing 10% quarterly cost reduction ).Define best practices for data structures, object naming, and compute utilization, while ensuring high efficiency (targeting >90% of data pipeline jobs completing within 10 minutes).Partner with Data Engineering to guide schema design and collaborate with the Platform Engineer on implementing Git-based version control and metadata standards.Represent the data warehouse in strategic projects, architecture reviews, and enterprise analytics initiatives, and mentor engineers on best practices.What We're Looking For7+ years in data engineering or architecture roles, including 3+ years of hands‑on cloud data warehouse experience ( Snowflake preferred).Expertise in data modeling and SQL performance tuning , with strong proficiency in SQL and a working knowledge of Python.Demonstrated experience with architectural principles like medallion architecture and implementing data model standardization .Proven ability to manage compute monitoring, cost control, and resource optimization in a large cloud environment.Familiarity with GitOps or CI/CD workflows and ETL processes and tools like Airflow .Apply today to utilize your cloud data architecture expertise to drive efficiency and standardization for a trusted leader in financial services!Seniority levelMid-Senior levelEmployment typeContractJob functionInformation Technology#J-18808-Ljbffr