Snowflake Data Architect – Onsite in Atlanta, GA
IDR is seeking a Snowflake Data Architect to support a large-scale enterprise data platform modernization. This role will focus on leading data modeling, optimization, and migration efforts within Snowflake on AWS. This is an onsite position based in Atlanta, GA.
Position Overview / Responsibilities:
-
Lead architecture design and implementation of Snowflake data platforms
-
Design dimensional and normalized data models to support BI and reporting
-
Collaborate with engineering and analytics teams to align technical architecture with business needs
-
Define ETL/ELT standards, build SnowProc pipelines, and support SnowSQL scripting
-
Implement Snowflake access control, masking policies, and compliance practices
-
Tune data warehouse performance and optimize costs
-
Stay current with Snowflake features, CI/CD best practices, and orchestration strategies
Required Skills:
-
5+ years of experience in data architecture or engineering roles
-
3+ years of hands-on Snowflake development and administration
-
Proficiency in SQL and modeling (star, snowflake, normalized)
-
Experience with dbt, Matillion, or Informatica for ETL/ELT workflows
-
Strong understanding of SnowProc, SnowSQL, and AWS integration
-
Background in performance tuning, query optimization, and security in Snowflake
Nice-to-Have Skills:
-
Snowflake certifications (SnowPro Core or Architect)
-
Experience in regulated industries (finance, healthcare, life sciences)
-
Familiarity with Python/Scala and orchestration tools like Airflow
-
Exposure to data governance, data cataloging (e.g., Collibra, Alation), and Snowpipe
What’s in it for you?
-
High-impact architecture role supporting cloud data transformation
-
Onsite collaboration with a fast-paced data engineering team
-
Access to Snowflake’s latest capabilities and AWS innovations
-
Long-term contract opportunity with industry-leading partners
-
Collaborative culture with strong technical mentorship
