Snowflake Engineer / Snowflake ETL Engineer / Snowflake Data Engineer
Posted 3 days ago by Apetan Consulting
Negotiable
Undetermined
Undetermined
Remote or New Jersey
Summary: The Snowflake Engineer role involves designing, implementing, and optimizing the organization's Snowflake data warehouse to ensure high performance, scalability, and security. The position requires expertise in Snowflake data engineering, SQL, and ETL processes. The engineer will collaborate with teams to support data analytics initiatives and ensure compliance with security standards. Strong communication skills and experience with cloud platforms are essential for success in this role.
Key Responsibilities:
- Administration: Manage Snowflake databases, schemas, roles, and warehouses; optimize compute resources; monitor performance; automate tasks using SQL/Python; enforce security policies.
- Data Integration: Support ETL/ELT pipelines (DBT/ADF), data ingestion from cloud/APIs/databases, and efficient transformation strategies.
- Performance Tuning: Optimize queries, implement clustering/partitioning, and manage warehouse sizing for cost/performance balance.
- Security & Compliance: Ensure encryption, masking, backups, disaster recovery, and compliance with standards.
- Collaboration: Partner with engineers/analysts, troubleshoot issues, provide best practices, and stay current with Snowflake updates.
Key Skills:
- Bachelor's in CS or related field
- 3-5+ years DBA/Data Engineering experience; 2+ years Snowflake
- Strong SQL, performance tuning, data modeling
- Experience with cloud platforms (Azure/AWS) and ETL tools (DBT, ADF)
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Title: Snowflake Engineer
Role Type: 12 Months
MUST HAVE:
Snowflake Data Engineering
SQL
Integration/ETL (DBT/ADF)
Good communication
-------
Snowflake Database Engineer
Responsible for designing, implementing, and optimizing the organization's Snowflake data warehouse to ensure high availability, performance, scalability, and security while supporting data engineering and analytics initiatives.
Key Responsibilities:
- Administration: Manage Snowflake databases, schemas, roles, and warehouses; optimize compute resources; monitor performance; automate tasks using SQL/Python; enforce security policies.
- Data Integration: Support ETL/ELT pipelines (DBT/ADF), data ingestion from cloud/APIs/databases, and efficient transformation strategies.
- Performance Tuning: Optimize queries, implement clustering/partitioning, and manage warehouse sizing for cost/performance balance.
- Security & Compliance: Ensure encryption, masking, backups, disaster recovery, and compliance with standards.
- Collaboration: Partner with engineers/analysts, troubleshoot issues, provide best practices, and stay current with Snowflake updates.
Requirements:
- Bachelor's in CS or related field
- 3 5+ years DBA/Data Engineering experience; 2+ years Snowflake
- Strong SQL, performance tuning, data modeling
- Experience with cloud platforms (Azure/AWS) and ETL tools (DBT, ADF)
Preferred: SnowPro certification, scripting (Python), CI/CD (Terraform), BI tools (Tableau, Power BI).