Snowflake Data Engineer

Appit LLC; Seattle (WA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive salary

Flexible work arrangements

Opportunities for career growth

Job summary

Appit LLC is seeking a Snowflake Data Engineer to join their Seattle team. The role involves building and optimizing cloud data warehouse solutions on Snowflake, focusing on high-performance analytics infrastructure.

Applicants should have 4-6 years of data engineering experience and proficiency in SQL, as well as familiarity with Snowflake's advanced features. The company offers competitive salaries and flexible work arrangements.

Qualifications

• 4-6 years of data engineering experience with at least 2 years working with Snowflake.
• Expert-level SQL skills including complex window functions, CTEs, and performance tuning.
• Experience with Snowflake features such as Time Travel, Zero-Copy Cloning, and Snowpipe.

Responsibilities

• Design and implement data models, schemas, and transformation layers within Snowflake.
• Develop and maintain ELT pipelines using Snowpipe, Tasks, and Streams for continuous data loading.
• Optimize Snowflake warehouse sizing, clustering keys, and materialized views for cost and performance.

Skills

Data engineering experience

Expert-level SQL skills

Snowflake features experience

ETL/ELT tool proficiency

Understanding of data governance

Education

4-6 years of experience in data engineering

Tools

Snowflake

dbt

Fivetran

Matillion

Informatica

Job description

APPIT Software Solutions is hiring a Snowflake Data Engineer in Seattle, USA. Build and optimize cloud data warehouse solutions on Snowflake, delivering high-performance analytics infrastructure at APPIT Software in Seattle.

Responsibilities

• Design and implement data models, schemas, and transformation layers within Snowflake
• Develop and maintain ELT pipelines using Snowpipe, Tasks, and Streams for continuous data loading
• Optimize Snowflake warehouse sizing, clustering keys, and materialized views for cost and performance
• Implement role-based access control, data masking, and row-level security policies in Snowflake
• Build data sharing solutions for internal teams and external partners using Snowflake Secure Data Sharing
• Create monitoring dashboards for credit consumption, query performance, and data freshness metrics

Requirements

• 4-6 years of data engineering experience with at least 2 years working with Snowflake
• Expert-level SQL skills including complex window functions, CTEs, and performance tuning
• Experience with Snowflake features such as Time Travel, Zero-Copy Cloning, and Snowpipe
• Proficiency with at least one ETL/ELT tool (dbt, Fivetran, Matillion, or Informatica)
• Familiarity with cloud storage integration (AWS S3, Azure Blob) and external stages
• Understanding of data governance concepts including data cataloging and lineage tracking

Nice to Have

• Snowflake SnowPro Core or Advanced certification
• Experience with dbt for transformation orchestration
• Knowledge of Snowpark for Python-based transformations

About APPIT Software Solutions

APPIT Software Solutions is a leading technology company building AI-powered enterprise products. Join 150+ professionals working on cutting-edge solutions in AI/ML, cloud computing, and digital transformation. We offer competitive salaries, flexible work arrangements, and opportunities for career growth across our global offices.