Data Architect

Snowflake Data Architect at The Ash Group W2 Contract Only – No C2C – No 3rd Parties Summary The 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 Doing Lead 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 For 7+ 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 level Mid-Senior level Employment type Contract Job function Information Technology #J-18808-Ljbffr