Snowflake with DBT Developer

Zoho; United States; Remote; USD 140,000 - 180,000; Full time

Job summary

infini-tek is seeking an experienced Data Engineer to design, build, and optimize Snowflake-based data pipelines for enterprise analytics. You will develop high-performance SQL, implement ingestion/orchestration with tools like dbt and Airflow, and ensure secure, scalable data delivery across cloud platforms.

The role involves collaborating with data modelers to implement dimensional or Data Vault models, tuning for cost and performance, and mentoring junior developers as needed.

Qualifications

• 7+ years of data engineering experience with 4+ years hands-on Snowflake expertise.
• Strong SQL and Snowflake features (Time Travel, Zero-Copy Cloning, Streams & Tasks).
• Experience with cloud platforms (AWS/Azure/GCP) and storage services.
• Proficiency in ETL/orchestration tools (dbt, Informatica, Talend, Airflow, ADF, Matillion).
• Python or Shell scripting for automation and reproducible pipelines.
• Understanding of data warehousing concepts, dimensional modeling, and CDC patterns.

Responsibilities

• Design, build, and optimize Snowflake-based data pipelines for analytics needs.
• Develop SQL queries, views, and UDFs for data transformation and reporting.
• Integrate Snowflake with tools for ingestion/orchestration (dbt, Airflow, etc.).
• Implement loading strategies (COPY INTO, Snowpipe, external stages) for real-time data.
• Tune warehouse sizing, performance, and cost controls with proper clustering.
• Enforce RBAC, data masking, and privacy policies across datasets.
• Handle semi-structured data (JSON, Parquet, Avro) using VARIANT and related ops.
• Collaborate with modelers/architects on physical data models (Dimensional/Data Vault).
• Troubleshoot production pipelines, monitor health, and support CI/CD deployments.
• Document designs, data flows, and coding standards; mentor juniors if applicable.

Skills

Snowflake

SQL

ETL/ELT design

Cloud platforms

Python/Shell

CI/CD

Data security concepts

Tools

dbt

Informatica

Talend

Airflow

ADF

Matillion

Job description

Role Summary

Design, build, and optimize data pipelines and Snowflake-based solutions supporting enterprise analytics and reporting needs.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, along with tools like Snowpipe, Streams, Tasks, and Snowflake Scripting/SQL Stored Procedures
  
• Write complex, high-performance SQL queries, views, and UDFs for data transformation and analytics
  
• Integrate Snowflake with tools such as Informatica, Talend, dbt, Matillion, Airflow, or ADF for data ingestion/orchestration
  
• Implement data loading strategies (bulk load, COPY INTO, external stages, Snowpipe for near real-time ingestion)
  
• Optimize warehouse sizing, query performance, clustering keys, and caching strategies to control cost and improve efficiency
  
• Implement role-based access control (RBAC), row-level/column-level security, and data masking policies
  
• Work with semi-structured data (JSON, Parquet, Avro) using VARIANT, FLATTEN, and related functions
  
• Collaborate with data modelers/architects to implement physical data models (dimensional/Data Vault) in Snowflake
  
• Troubleshoot production issues, monitor pipeline health, and support CI/CD deployment of Snowflake objects
  
• Document technical designs, data flows, and coding standards; mentor junior developers (for senior-level candidates)
  

Required Skills

• 7+ years overall data engineering experience, with 4+ years hands-on Snowflake experience
  
• Strong SQL and Snowflake-specific features (Time Travel, Zero-Copy Cloning, Streams & Tasks, Secure Views)
  
• Experience with cloud platforms (AWS/Azure/GCP) and associated storage services (S3, ADLS, GCS)
  
• Proficiency in at least one ETL/orchestration tool (dbt, Informatica, Talend, Airflow, ADF, Matillion)
  
• Scripting experience in Python or Shell for automation
  
• Understanding of data warehousing concepts, dimensional modeling, and CDC patterns
  
• Familiarity with version control (Git) and CI/CD pipelines (Jenkins, Azure DevOps, GitHub Actions)
  
• Snowflake certification (SnowPro Core, preferred)
  

Good to Have

• Exposure to data governance/catalog tools (Alation, Collibra)
  
• Experience with BI tools (Tableau, Power BI, Looker) connecting to Snowflake
  
• Knowledge of cost optimization and query profiling in Snowflake