Data Engineer with Fivetran, Snowflake and dbt
About the Position
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.
About the Project
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.
About the Team
You will collaborate with application, infrastructure, security, analytics, and business teams. The work involves cross functional cooperation focused on onboarding new data sources, supporting production pipelines, and maintaining reliable data delivery.
Responsibilities
- 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
Requirements
- 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
Nice to Have
- 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
Technologies
Fivetran, dbt, dbt Cloud, Snowflake, SQL, Python, Git, Apache Airflow, AWS services (MWAA, S3, IAM, Lambda, Secrets Manager, FSx), Salesforce, Marketo, REST API, SFTP, Snowpark, Snowpark Container Services, Databricks, Terraform
