Snowflake Data Architect & Pre-Sales Lead

Atrium; United States; Remote; USD 140,000 - 230,000; Full time

Job summary

Atrium is seeking an experienced Snowflake Architect to join our data solutions team. You will design and deliver end-to-end Snowflake architectures across ingestion, transformation, storage, and consumption, balancing pre-sales activities with hands-on delivery on client projects.

You will collaborate with sales to shape solutions, build POCs and demos, and mentor engineers while driving scalable ELT/ETL pipelines, data quality, and cost optimization.

Qualifications

• Extensive experience in data warehousing and Snowflake architecture.
• Ability to lead customer discovery, demos and POCs.
• Strong SQL optimization and performance tuning skills.
• Experience integrating Snowflake with cloud services (AWS/Azure/GCP).
• Excellent communication and client-facing capabilities.

Responsibilities

• Lead end-to-end Snowflake solution design across ingestion, transformation, storage, and consumption.
• Partner with sales to shape solutions, build POCs and demos.
• Architect scalable ELT/ETL pipelines with data quality checks.
• Mentor data engineers and share best practices for data modeling and security.
• Create content for RFP/RFI responses and proposals.
• Deliver technical workshops, webinars, and client engagements.
• Define scope, estimates, and assumptions for proposals and SOWs.
• Ensure solutions align with business value for technical and executive audiences.

Skills

SQL optimization

Snowflake architecture

Data warehousing

Cloud platforms (AWS/Azure/GCP)

Pre-sales / client-facing

Python / Spark / dbt

Data integration tools

Mentoring & leadership

Education

Bachelor’s or Master’s degree in Computer Science or related

Tools

Fivetran

dbt

Git (Github/Bitbucket)

Matillion

Dagster

Job description

Atrium is seeking an experienced Snowflake Architect to join our data solutions team. You will design and deliver end-to-end Snowflake architectures across ingestion, transformation, storage, and consumption, balancing pre-sales activities with hands-on delivery on client projects.

You will collaborate with sales to shape solutions, build POCs and demos, and mentor engineers while driving scalable ELT/ETL pipelines, data quality, and cost optimization.