Senior Snowflake Data Architect

*** 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, with a focus 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.

Role Details

• 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 (targeting 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!

#DataArchitect #Snowflake #CloudDataWarehouse #DataModeling #SQLOptimization #ETL #RemoteJobs #Contract