Senior Data Engineer (Snowflake, dbt, Fivetran)

Role

Senior Data Engineer (Snowflake, dbt, Fivetran)

Duration

6 months

Location

McLean, VA- 100% onsite FROM DAY 1

Type

Contract

Rate

$60 to $70/hr

Required Qualifications

• 7+ years of experience in data engineering / analytics engineering roles.
• Strong hands-on experience with dbt in production, including:
• Model development and dependency management
• Macro development and reusable frameworks
• Testing strategies (schema tests, custom tests)
• Deployment and environment management
• Strong Snowflake expertise, including:
• Data modeling and warehouse design
• Performance tuning and cost Eligible to workimization
• Deep understanding of virtual warehouses, micro-partitions, clustering, and query pruning
• Role-based access control (RBAC) and secure data access
• Advanced SQL expertise with ability to build and Eligible to workimize complex transformations.
• Strong Python programming skills for data engineering use cases.
• Proven experience with Git integration, including collaborative development workflows.
• Strong experience implementing CI/CD pipelines for data platforms and dbt deployments.
• Experience building and maintaining production-grade data pipelines with SLAs, monitoring, and reliability standards.
• Mandatory requirement: direct, hands-on experience with Fivetran, dbt, and Snowflake in production, including Fivetran connector setup and troubleshooting, dbt model development and testing, and Snowflake data engineering, performance tuning, and secure access patterns. This is a strict screening criterion.