Snowflake Data Engineer (dbt, Fivetran & AWS Data Platform) | Cyberobotix | Washington, DC, USA

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

Job Title: Snowflake Data Engineer (dbt, Fivetran & AWS Data Platform) | Cyberobotix | Washington, DC, USA

Recruiting Company: Cyberobotix

Job Location: Washington, DC, USA (Hybrid)

Job Type: Contract

Position Summary

Cyberobotix is seeking an experienced Snowflake Data Engineer to support enterprise-scale cloud data modernization initiatives. This role focuses on designing, optimizing, and maintaining Snowflake-based data platforms while driving data migration, transformation, automation, and analytics enablement across mission-critical business environments.

Detailed Job Description

As a Snowflake Data Engineer, you will be responsible for building and optimizing modern cloud-native data platforms powered by Snowflake, dbt, Fivetran, and AWS technologies. You will work closely with data architects, analysts, BI teams, and business stakeholders to develop scalable data pipelines, implement robust data models, and ensure high levels of data quality and performance. The role involves migrating legacy SQL Server, SSIS, and SSAS workloads to Snowflake while implementing best practices for data governance, CI/CD, automation, and cloud architecture. Successful candidates will play a key role in delivering trusted, analytics-ready datasets that support enterprise reporting and decision-making.

Key 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, scalability, and reliability.
• Implement and manage Snowflake data architecture using Raw/Bronze, Staging, and Curated data layers.
• Perform data migration from SQL Server, SSIS, and SSAS environments to Snowflake.
• Design and implement Change Data Capture (CDC) and incremental data loading strategies.
• Develop source-to-target mappings and data transformation frameworks.
• Perform data validation, reconciliation, and quality assurance activities.
• Configure and manage AWS services including S3, IAM, KMS, VPC, and PrivateLink integrations.
• Support BI and analytics teams by delivering optimized datasets for reporting platforms such as Sigma.
• Implement CI/CD pipelines, Git-based version control, and automated deployment processes.
• Monitor platform performance, troubleshoot issues, and optimize Snowflake resource utilization.

Required Qualifications & Skills

• Strong hands-on experience with Snowflake in enterprise production environments.
• Advanced SQL expertise including query optimization, performance tuning, and complex data transformations.
• Extensive experience with dbt (data build tool) for data transformation and analytics engineering.
• Hands-on experience with Fivetran for cloud-based data ingestion and pipeline automation.
• Strong AWS experience including Amazon 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.
• Strong background in data validation, reconciliation, and data quality management.
• Experience designing modern Snowflake data architectures and layered data warehouse models.
• Knowledge of CI/CD pipelines, Git workflows, and data engineering automation best practices.
• Experience supporting reporting and analytics platforms.
• Strong analytical, troubleshooting, and stakeholder communication skills.

Nice-to-Have Skills

• Snowflake SnowPro Core Certification.
• Snowflake SnowPro Advanced Certification.
• Financial Services or Financial Data domain experience.
• Experience with Snowflake cost optimization and warehouse performance management.
• Expertise with dbt materializations, Dynamic Tables, and advanced transformation frameworks.
• Experience implementing data governance and cloud-native analytics architectures.

Recruitment Pro Tip

For Snowflake engineering roles, ensure your CV prominently highlights Snowflake, dbt, Fivetran, AWS, SQL Optimization, CDC, Data Validation, Data Reconciliation, SSIS Migration, Data Warehousing, CI/CD, Git, Sigma Analytics, Dynamic Tables, and Snowflake Performance Tuning. Quantifying data volumes managed, migration projects completed, pipeline performance improvements, or cloud cost optimization achievements can significantly improve your chances of shortlisting.