Snowflake Data Engineer – Cortex, ELT Pipelines & Cloud

Dovel Technologies, Inc; McLean (VA); Hybrid; USD 98,000 - 163,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Paid Holidays and Parental Leave

Job summary

Guidehouse is seeking an experienced Snowflake Engineer to design, build, and optimize enterprise data solutions. You will develop scalable ingestion pipelines, complex SQL, and Snowflake-native features to support analytics and AI initiatives.

Collaboration with architects, analysts, and product owners is essential, with strong focus on security, governance, and cost optimization. The role offers remote flexibility and requires holding a public trust with DoD eligibility, with salary ranging

Qualifications

• Bachelor's degree required.
• 5+ years data engineering with 2+ years Snowflake experience.
• Strong SQL development and performance tuning.
• Experience with Snowflake-native features (Snowpipe/Streams/Tasks).
• Knowledge of RBAC and data governance in cloud environments.

Responsibilities

• Design, build, and optimize Snowflake data solutions for analytics.
• Develop batch and near real‑time ingestion pipelines with Snowpipe/Streams/Tasks.
• Create and optimize SQL queries, stored procedures, UDFs, and data transformations.
• Design and support ELT/ETL pipelines and metadata automation frameworks.
• Assist with RBAC, governance, data sharing, and security in Snowflake environments.
• Collaborate with architects, analysts, and stakeholders; provide production support.

Skills

Snowflake

SQL development

ELT/ETL

RBAC & governance

Snowflake Cortex

Snowpipe/Streams/Tasks

Snowflake architecture

Python

CI/CD

dbt

Education

Bachelor's Degree

Tools

Snowpark

Git

Terraform / IaC

UDFs/Stored Procedures

Change Data Capture (CDC) patterns

Job description

Guidehouse is seeking an experienced Snowflake Engineer to design, build, and optimize enterprise data solutions. You will develop scalable ingestion pipelines, complex SQL, and Snowflake-native features to support analytics and AI initiatives.

Collaboration with architects, analysts, and product owners is essential, with strong focus on security, governance, and cost optimization. The role offers remote flexibility and requires holding a public trust with DoD eligibility, with salary ranging