Apolis
Role: Snowflake Data Architect
Work location: Atlanta, GA - onsite.
Rate: $100/hr
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.
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.