Snowflake Data Engineer

External job listingat Zodiachrc

Snowflake Data Engineer in Washington DC or surrounding VA/MD. Hybrid role building a cloud data lake with Snowflake, Fivetran, and dbt.

External source - not verified5 weeks agoOpen until: Jan 13, 2027

Salary

Not provided

Location

Washington, United States

Employment type

Full time

Workplace

Not provided

Snowflake Data Engineer

Washington, United States

Job description

About the role

Help build a modern cloud data lake using Snowflake, Fivetran, and dbt while delivering clean, high‐performance analytics-ready data for enterprise reporting.

Tasks

  • Design, configure, and maintain the Snowflake environment, including databases, schemas, warehouses, roles, and security policies across development, test, and production.
  • Implement and manage cloud‐based ingestion with Fivetran for legacy, operational, and SaaS source systems, handling full‐load, incremental, and CDC patterns.
  • Build and optimize the target data architecture across raw, staging, curated, and reporting layers following medallionundur modular patterns.
  • Develop, test, and maintain dbt models that replace legacy SSIS logic and deliver business‐ready data assets for reporting, reconciliation, and analytics.
  • Translate legacy constructs (SCD Type 2, lookup logic, conditional branching, etc.) into modern Snowflake and dbt implementations.
  • Configure necessary AWS integrations: S3 stages, IAM roles, storage integrations, encryption, and secure connectivity patterns.
  • Establish and document source‐to‐target mappings, metadata consistency, schema evolution handling, and field‐level lineage.
  • Implement automated data quality checks, freshness checks, reconciliation controls, and exception handling.
  • Monitor pipelines, connector health, transformation runs, and Snowflake workloads; troubleshoot failures, performance issues, and data incidents.
  • Optimize Snowflake cost and performance through workload isolation, warehouse sizing, clustering, and query tuning.
  • Support analytics and reporting teams by delivering well documented, analytics‐ready data structures compatible with Sigma and other governed BI tools.
  • Contribute to CI/CD, release automation, and Git‐based engineering workflows for dbt, Snowflake, and data pipeline changes.
  • Produce operati

Schedule

  • Hybrid

Location

  • Washington DC or surrounding VA/MD

Similar jobs