Snowflake Data Engineer

Snowflake Data Engineer 

Location: USA – Remote
Duration:- 6-12 Months+

Job Summary

We are seeking an experienced Data Engineer – Snowflake to design, build, and maintain scalable data pipelines and cloud data solutions. The ideal candidate will have strong hands-on experience with Snowflake, SQL, Python, ETL/ELT, data modelling, and cloud data platforms.

The Data Engineer will work closely with data analysts, data scientists, software engineers, and business stakeholders to build reliable data products and transform raw data into high-quality, analytics-ready datasets.

Snowflake supports modern data engineering workflows using SQL, Python/Snowpark, dbt, tasks, streams, and other capabilities for building and orchestrating data pipelines.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake.
• Build robust ETL/ELT processes for batch and near-real-time data ingestion.
• Develop complex SQL queries, stored procedures, views, and data transformations.
• Use Snowpark Python to build scalable data processing and transformation workflows.
• Develop and maintain data models for analytics, reporting, and downstream applications.
• Implement incremental data processing using Snowflake Streams, Tasks, Dynamic Tables, or equivalent technologies.
• Integrate data from APIs, databases, cloud storage, SaaS applications, and enterprise systems.
• Develop data ingestion pipelines from platforms such as AWS S3, Azure Data Lake, or other cloud storage systems.
• Optimize Snowflake queries, warehouses, tables, and pipelines for performance and cost.
• Implement data quality checks, validation, monitoring, and error handling.
• Support data governance, security, access controls, and data lifecycle management.
• Work with dbt to develop modular, tested, and maintainable transformation pipelines.
• Build CI/CD processes for data engineering code and Snowflake deployments.
• Troubleshoot production data pipelines and resolve data quality or performance issues.
• Collaborate with analysts and business stakeholders to understand data requirements.
• Document data architecture, pipeline workflows, data models, and technical processes.
• Participate in Agile ceremonies, code reviews, technical design discussions, and sprint planning.

Required Qualifications

• 4+ years of experience in data engineering or a related technical role.
• 2+ years of hands-on experience with Snowflake.
• Strong proficiency in SQL.
• Strong programming experience with Python.
• Experience developing enterprise-scale ETL/ELT data pipelines.
• Strong understanding of data warehousing concepts and dimensional data modeling.
• Experience with Snowflake objects including databases, schemas, tables, views, stages, warehouses, tasks, and streams.
• Experience working with structured and semi-structured data such as JSON, Parquet, and CSV.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Experience with Git and software development best practices.
• Strong problem-solving and troubleshooting skills.
• Excellent communication and collaboration skills.

Preferred Qualifications

• Experience with Snowpark Python.
• Experience with dbt and dbt Cloud.
• Experience with Apache Airflow or another workflow orchestration platform.
• Experience with Kafka, Kinesis, or other streaming technologies.
• Experience with AWS S3, Azure Data Lake Storage, or Google Cloud Storage.
• Experience with Terraform or Infrastructure as Code.
• Familiarity with CI/CD tools such as GitHub Actions, GitLab CI, Jenkins, or Azure DevOps.
• Experience with data quality and observability platforms.
• Knowledge of cloud security, encryption, IAM, and data governance.
• Experience working with large-scale enterprise data environments.

Snowflake''s current data engineering capabilities include Snowpark for Python, SQL-based transformations, dbt Projects, Tasks, Streams, and CI/CD-oriented development workflows.

Technical Skills

Required:

• Snowflake
• Advanced SQL
• Python
• ETL / ELT
• Data Warehousing
• Data Modeling
• Cloud Data Engineering
• Git

Preferred:

• Snowpark Python
• dbt
• Apache Airflow
• AWS / Azure / Google Cloud Platform
• Kafka / Kinesis
• Terraform
• CI/CD
• Docker
• REST APIs
• Data Quality & Observability

Key Deliverables

• Scalable Snowflake data pipelines
• Enterprise data warehouse models
• Automated ETL/ELT workflows
• Data ingestion and transformation frameworks
• High-quality analytics datasets
• Data quality and validation frameworks
• Pipeline monitoring and operational documentation
• Performance and cost optimization initiatives
• CI/CD-enabled data engineering workflows

Success in This Role

The successful candidate will be able to take ownership of data engineering projects from requirements and architecture through development, testing, deployment, and production support. They should be comfortable working with large datasets, solving complex data problems, and building reliable pipelines that support analytics and business-critical applications.

Snowflake''s platform is designed to support reliable data pipelines across SQL and Python while reducing infrastructure-management overhead, making strong pipeline engineering and cloud data skills particularly valuable for this position.

Education

Bachelor''s degree in Computer Science, Information Technology, Data Engineering, Engineering, Mathematics, or a related field preferred. Equivalent professional experience may be considered.