{"schemaVersion":"jobsearcher.job.v1","id":"56daab7ee14eb756d040116f","url":"https://jobsearcher.com/jobs/56daab7ee14eb756d040116f","canonicalUrl":"https://jobsearcher.com/jobs/56daab7ee14eb756d040116f","title":"Snowflake Data Engineer","description":"Key ResponsibilitiesDesign and develop scalable data pipelines and data warehouse solutions using Snowflake.Develop complex SQL queries, stored procedures, transformations, and data models.Build and maintain dbt models, tests, and workflows.Implement CDC (Change Data Capture) and SCD Type 2 data processing.Design and manage Snowflake Dynamic Tables and optimize data processing workloads.Perform Snowflake performance tuning, including query optimization, warehouse sizing, and cost optimization.Develop and maintain data pipelines using Airflow and Kafka.Use Snowpark for advanced data processing and transformation requirements.Implement automated CI/CD processes for data engineering workflows.Establish and maintain data quality, data lineage, governance, and security standards.Work with AWS cloud services and integrate cloud-based data solutions.Troubleshoot production issues and ensure reliability, scalability, and performance of data platforms.Lead technical discussions, provide design guidance, and mentor junior/mid-level data engineers.Collaborate with business analysts, data architects, application teams, and other stakeholders.Required Skills6+ years of experience in Data Engineering, with strong hands-on experience in Snowflake.Strong expertise in Snowflake and advanced SQL.Hands-on experience with dbt, Dynamic Tables, CDC, and SCD Type 2.Experience with Airflow and Kafka.Good knowledge of Snowpark.Strong understanding of data warehousing and ETL/ELT concepts.Experience with AWS cloud services.Experience with CI/CD tools and practices.Knowledge of data quality, lineage, governance, and security.Strong problem-solving and communication skills.Experience leading technical projects or mentoring team members is preferred.Preferred QualificationsExperience with large-scale enterprise data platforms.Experience in Snowflake cost and performance optimization.Familiarity with Git-based development and DevOps practices.Experience working in Agile/Scrum environments.","company":"Smart IT Frame","rawCompany":"smart it frame","city":"Phoenix","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-08-27T09:02:21.315Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Snowflake Data Engineer","description":"Key ResponsibilitiesDesign and develop scalable data pipelines and data warehouse solutions using Snowflake.Develop complex SQL queries, stored procedures, transformations, and data models.Build and maintain dbt models, tests, and workflows.Implement CDC (Change Data Capture) and SCD Type 2 data processing.Design and manage Snowflake Dynamic Tables and optimize data processing workloads.Perform Snowflake performance tuning, including query optimization, warehouse sizing, and cost optimization.Develop and maintain data pipelines using Airflow and Kafka.Use Snowpark for advanced data processing and transformation requirements.Implement automated CI/CD processes for data engineering workflows.Establish and maintain data quality, data lineage, governance, and security standards.Work with AWS cloud services and integrate cloud-based data solutions.Troubleshoot production issues and ensure reliability, scalability, and performance of data platforms.Lead technical discussions, provide design guidance, and mentor junior/mid-level data engineers.Collaborate with business analysts, data architects, application teams, and other stakeholders.Required Skills6+ years of experience in Data Engineering, with strong hands-on experience in Snowflake.Strong expertise in Snowflake and advanced SQL.Hands-on experience with dbt, Dynamic Tables, CDC, and SCD Type 2.Experience with Airflow and Kafka.Good knowledge of Snowpark.Strong understanding of data warehousing and ETL/ELT concepts.Experience with AWS cloud services.Experience with CI/CD tools and practices.Knowledge of data quality, lineage, governance, and security.Strong problem-solving and communication skills.Experience leading technical projects or mentoring team members is preferred.Preferred QualificationsExperience with large-scale enterprise data platforms.Experience in Snowflake cost and performance optimization.Familiarity with Git-based development and DevOps practices.Experience working in Agile/Scrum environments.","datePosted":"2026-08-27T09:02:21.315Z","dateModified":"2026-08-27T09:02:21.315Z","hiringOrganization":{"@type":"Organization","name":"Smart IT Frame","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Phoenix","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"56daab7ee14eb756d040116f"},"url":"https://jobsearcher.com/jobs/56daab7ee14eb756d040116f"}}