Snowflake Data Architect
eTeam - Atlanta, Georgia, United States, 30383
Work at eTeam
Overview
- View job
Overview
JOB DESCRIPTION:
Key Responsibilities: • Architect and implement scalable data solutions using Snowflake. • Design and optimize data models (star, snowflake, normalized) to support analytics and reporting. • Lead the migration of legacy data warehouses to Snowflake. • Define and enforce best practices for data ingestion, transformation, and storage. • Collaborate with data engineers, analysts, and business stakeholders to align data architecture with business goals. • Implement security, data governance, and compliance standards. • Monitor and optimize Snowflake performance and cost efficiency. • Stay current with Snowflake features and industry trends to drive innovation.
Must-Have Skills: • 5+ years of experience in data architecture or engineering roles. • 3+ years of hands-on experience with Snowflake. • Strong expertise in SQL and data modeling (dimensional and normalized). • Experience with ETL/ELT tools (e.g., dbt, Matillion, Informatica). • Strong understanding of building ETL / ELT workloads using snowproc and snowflake SQL • Proficiency in cloud platforms (AWS). • Knowledge of data security, role-based access control, and data masking in Snowflake. • Experience with performance tuning and cost optimization in Snowflake.
Nice-to-Have Skills: • Experience in the life • Snowflake certification (SnowPro Core or Advanced Architect). • Experience with CI/CD pipelines for data workflows. • Familiarity with Python or Scala for data processing. • Experience with orchestration tools (e.g., Airflow, Prefect). • Knowledge of data cataloging tools (e.g., Alation, Collibra). • Exposure to real-time data streaming (e.g., Snowpipe). • Experience in Agile/Scrum environments.