Sowflake Data Engineering Architect

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

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

Take your career to the next level with the only consulting firm born in AI and delivering with AI.

At Atrium, we’re not simply adapting to an AI-driven world, we’ve helped define it since we were founded. Our clients partner with us because we turn potential into measurable impact, reshaping industries, realizing exponential value, and empowering organizations to thrive in an era of unprecedented technological advancement.

As pioneers in AI-assisted delivery, we’re constantly optimizing how we deliver services for greater speed, accuracy, and efficiency. This commitment allows us to repeatedly deliver outcomes that other Salesforce and Snowflake partners merely promise. Care to join us?

Who are you?

You’re a smart collaborator who likes solving complex problems and takes ownership to get things done. You stay up to date with the latest and greatest in business and technology tools, platforms, and languages and want to ensure our clients do too. You love working across teams and are enthusiastic about doing your part to ensure everyone succeeds.

What will you be doing at Atrium?

At Atrium, you’ll be the Snowflake expert who helps us win the work and deliver it, with your time split roughly 50/50 between pre-sales and billable client projects. On the pre-sales side, you’ll partner with our sales team to shape solutions, build POCs and demos, and show clients what’s possible. On the delivery side, you’ll be hands‑on in client engagements, designing and guiding scalable, high-performing data architectures that drive real business results.

In this role, you will:

Spend roughly 50% of your time on billable client projects, leading end-to-end Snowflake solution design across ingestion, transformation, storage, and consumption layers

Partner with Account Executives and sales leadership as the Snowflake technical lead on new opportunities, from first discovery call through close

Lead technical discovery sessions with client stakeholders to uncover business goals, data challenges, and success criteria

Design and present solution architectures, roadmaps, and recommendations that tie clearly to business value — for both technical and executive audiences

Get hands-on-keyboard building proofs of concept (POCs) and live demos that show clients what’s possible in Snowflake

Shape scope, level-of-effort estimates, and key assumptions for proposals and SOWs, setting delivery teams up for a clean handoff

Contribute technical content to RFP/RFI responses, proposals, and pitch decks

Build reusable demos and best‑practice accelerators that grow Atrium’s IP library

Represent Atrium as a Snowflake subject‑matter expert in client workshops, partner events, and webinars

Set best practices for data modeling, query optimization, security, access control, and cost management

Architect scalable ELT/ETL pipelines and data quality checks using tools like Fivetran, dbt, and custom frameworks

Tune Snowflake performance and cost (clustering, materialized views, warehouse sizing) and troubleshoot issues to root cause

Translate business requirements into technical specs while ensuring security, privacy, and compliance standards are met

Mentor data engineers and stay current on new Snowflake features to keep our platform and offerings ahead of the curve

In this role, you will have:

Bachelor’s or Master’s degree in Computer Science, Engineering, or a related quantitative field

8+ years in data warehousing, data architecture, or senior data engineering, including 4+ years hands‑on as a Snowflake Architect

Customer‑facing pre‑sales, solution architecture, or consulting experience — you’re comfortable running discovery, demos, and POCs

Deep knowledge of modern data warehousing, dimensional modeling, and data architectures

Expert SQL skills, including performance tuning complex queries on very large datasets

Strong experience with AWS, Azure, or GCP and integrating Snowflake with cloud services

Proficiency with data integration tools and languages (e.g., Python, Spark, dbt, Fivetran, Matillion, Dagster), plus Git systems (Github, Bitbucket) and CI/CD approaches for data solutions

Excellent communication and presentation skills, with a knack for making complex concepts clear to any audience

The ability to work independently and collaboratively in a fast‑paced, agile environment

Snowflake certifications (SnowPro Core or Advanced) highly desired

Next Steps

Our recruitment process is highly personalized. Some candidates complete the hiring process in one week; others may take longer as it’s important we find the right position for you. It’s all about timing and can be a journey as we continue to learn about one another. We want to get to know you and encourage you to be selective - after all, deciding to join a company is a big decision!

At Atrium, we believe a diverse workforce allows us to match our growth ambitions and drive inclusion across the business. We are an equal opportunity employer and all qualified applicants will receive consideration for employment.