Snowflake Data Engineer: dbt, Fivetran & AWS

Tech Junction Ltd; Washington, Northern (District of Columbia, KY); Hybrid; USD 130,000 - 190,000; Part time

Job summary

Cyberobotix in Washington, DC, is seeking a Snowflake Data Engineer to design, optimize, and maintain Snowflake-based data platforms using dbt, Fivetran, and AWS. The role will migrate legacy workloads and build scalable ELT/ETL pipelines to deliver analytics-ready datasets for enterprise reporting.

The position requires strong SQL, Snowflake, and CI/CD skills, plus experience in data governance, CDC, data quality, and modern data architectures.

Qualifications

• Strong hands-on experience with Snowflake in enterprise production environments.
• Advanced SQL expertise including optimization and complex transformations.
• Extensive experience with dbt for data transformation and analytics engineering.
• Hands-on experience with Fivetran for cloud-based data ingestion and pipeline automation.
• Strong AWS experience including S3, IAM, KMS, VPC, and PrivateLink.
• Experience migrating SQL Server, SSIS, and SSAS workloads to Snowflake.
• Deep understanding of Change Data Capture (CDC) methodologies.
• Experience implementing incremental loading frameworks and source-to-target mapping processes.
• Data validation, reconciliation, and data quality management expertise.
• Experience designing modern Snowflake data architectures and CI/CD pipelines.
• Experience supporting reporting/analytics platforms and stakeholder communication.

Responsibilities

• Design, develop, and maintain enterprise Snowflake data warehouse environments.
• Build scalable ELT/ETL pipelines using Fivetran, dbt, and Snowflake technologies.
• Develop and optimize advanced SQL queries for performance and scalability.
• Implement and manage Snowflake data architecture using layered data zones.
• Migrate legacy SQL Server/SSIS/SSAS workloads to Snowflake.
• Design and implement CDC and incremental loading strategies.
• Develop source-to-target mappings and data transformation frameworks.
• Perform data validation and quality assurance activities.
• Configure and manage AWS services and integrations.
• Support BI teams by delivering optimized datasets for reporting platforms.
• Implement CI/CD pipelines, Git-based version control, and automated deployment processes.
• Monitor platform performance and optimize resources.

Skills

Snowflake

SQL

dbt

Fivetran

AWS

CDC

Data governance

CI/CD

Git

Data modeling

Job description

Cyberobotix in Washington, DC, is seeking a Snowflake Data Engineer to design, optimize, and maintain Snowflake-based data platforms using dbt, Fivetran, and AWS. The role will migrate legacy workloads and build scalable ELT/ETL pipelines to deliver analytics-ready datasets for enterprise reporting.

The position requires strong SQL, Snowflake, and CI/CD skills, plus experience in data governance, CDC, data quality, and modern data architectures.