Data Architect

The Ash Group

United States

Remote

USD 96,432

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) plan with 4% match

Job summary

A leading technology consulting firm is seeking a Snowflake Data Architect to lead the evolution of a cloud data warehouse for a client in the financial services sector. The role requires 7+ years of data architecture experience, expertise in Snowflake, and a strong background in data modeling and SQL performance tuning. This position offers competitive compensation of $70 per hour and is 100% remote for candidates located in specific U.S. states.

Qualifications

7+ years in data engineering or architecture roles, including 3+ years of cloud data warehouse experience.
Demonstrated expertise in SQL and strong proficiency in data modeling.
Experience managing compute monitoring, cost control, and resource optimization.

Responsibilities

Lead Snowflake platform architecture across U.S. and International instances.
Drive significant cost optimization efforts by performing query tuning.
Define best practices for data structures and ensure high efficiency.
Partner with Data Engineering to guide schema design.
Mentor engineers on best practices.

Skills

Cloud data warehouse experience

Data modeling

SQL performance tuning

Python

Computational monitoring

Cost control

Resource optimization

GitOps

ETL processes

Tools

Snowflake

Airflow

Job description

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.