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