Snowflake Data Engineer

Job Title: Snowflake DBT Data Engineer

Location: Irvine, CA

Job Type: Contract

Mandatory Skills :
Snowflake, ANSI-SQL,DBT

Key Responsibilities:

• Design develop and maintain ELT pipelines using Snowflake and DBT
• Build and optimize data models in Snowflake to support analytics and reporting
• Implement modular testable SQL transformations using DBT
• Integrate DBT workflows into CICD pipelines and manage infrastructure as code using Terraform
• Collaborate with data scientists analysts and business stakeholders to translate requirements into technical solutions
• Optimize Snowflake performance through clustering partitioning indexing and materialized views
• Automate data ingestion and transformation workflows using Airflow or similar orchestration tools
• Ensure data quality governance and security across pipelines
• Troubleshoot and resolve performance bottlenecks and data issues
• Maintain documentation for data architecture pipelines and operational procedures

Required Skills Qualifications:

• Bachelors or Masters degree in Computer Science Data Engineering or related field
• 7 years of experience in data engineering with at least 2 years focused on Snowflake and DBT
• Strong proficiency in SQL and Python
• Experience with cloud platforms AWS GCP or Azure
• Familiarity with Git CICD and Infrastructure as Code tools Terraform CloudFormation
• Knowledge of data modelling star schema normalization and ELT best practices