Z
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