Data Engineer with Fivetran, Snowflake and dbt

We are looking for an experienced, hands-on Data Engineer with strong expertise in Fivetran, dbt, Snowflake, and modern cloud data engineering practices. The candidate should also have experience with Python, and familiarity with AI-assisted development tools such as Claude, Cursor, or VS Code-based AI assistants.

The role will focus on building scalable ingestion and transformation pipelines, implementing data quality and orchestration patterns, and supporting enterprise data products consumed by analytics and business teams.

This project is centered on a modern cloud data platform built with Fivetran, dbt, and Snowflake. You will help enable reliable and scalable data flows for enterprise use cases while supporting development practices such as CI/CD, code review, and controlled deployments.

• Design end to end data pipelines using Fivetran, dbt, and Snowflake
• Build and support ingestion and transformation pipelines for enterprise data products
• Configure and manage Fivetran connectors across SaaS applications, databases, APIs, and file-based sources
• Develop and maintain dbt models across staging, intermediate, mart, and publish layers
• Implement dbt tests, source freshness checks, incremental processing, documentation, and reusable macros
• Develop optimized Snowflake SQL and scalable analytical data models
• Support Snowflake objects, security and RBAC, stages, data sharing, and data loading patterns
• Implement data quality, reconciliation, monitoring, and operational alerting
• Troubleshoot production pipelines and perform root cause analysis across ingestion and transformation layers
• Participate in Git based development, CI/CD, code reviews, and DEV, QA, and PROD deployments
• Collaborate with application, infrastructure, security, analytics, and business teams to onboard new data sources
• Use AI-assisted development tools to support coding, troubleshooting, documentation, and code quality

• 5+ years of Data Engineering or related experience
• 2+ years of hands-on experience with Snowflake and dbt
• Production experience implementing and supporting Fivetran pipelines
• Experience designing reusable ingestion and transformation patterns
• Strong SQL skills including complex joins, CTEs, window functions, reconciliation, and query optimization
• Experience with Git and CI/CD including branching, pull requests, code reviews, and automated deployment workflows
• Working knowledge of Python for data processing, automation, API integrations, file processing, data validation, and operational scripting
• Experience operating within enterprise DEV, QA, and PROD SDLC and change management processes
• Strong production troubleshooting and root cause analysis skills
• Comfort using Claude, Cursor, or VS Code with AI-assisted development capabilities

• Experience with Apache Airflow or AWS MWAA for orchestration
• Experience with AWS services including S3, IAM, Lambda, Secrets Manager, and FSx
• Experience with Salesforce, Marketo, and other SaaS integrations
• Experience with REST API and SFTP or file based ingestion
• Experience with Snowflake Secure Data Sharing
• Experience with Snowpark or Snowpark Container Services
• Experience with Databricks
• Experience with Terraform or Infrastructure as Code
• Experience with data quality and observability frameworks
• Experience modernizing or migrating legacy ETL or integration platforms