Senior Data Engineer, Fivetran

• Mastery of advanced SQL in a modern data warehouse environment (Snowflake, BigQuery, Redshift, etc)
• Applied knowledge of a scripting language, preferably Python, in a data engineering context
• A deep understanding of ERDs, DAGs, and ETL/ELT
• An informed, opinionated stance on SQL style, normalization, Kimball, etc
• Experience with CI/CD implementations for the modern data stack
• You want to solve problems the RIGHT way, and you can clearly articulate why to a technical audience

Desirable

• Fivetran is building data pipelines to power the modern data stack for thousands of companies
• We believe that in the future, with the work of writing and maintaining ELT pipelines offloaded to Fivetran, the role of a data engineer opens up into a wider problem space focused on performance, reliability, and making data teams and data consumers more efficient
• Fivetran’s internal Analytics team are happy Fivetran customers, and we are looking for an experienced data engineer who is ready to step into that future with us
• This person will be the standard-bearer for data quality and efficiency on a high-performance, industry-leading Analytics team
• Responsibilities include transformation layer optimization, data observability monitoring and response, and the selection, implementation and maintenance of all the tools and systems used across the department
• You’ll also be responsible for ensuring the technical excellence of your team by reviewing code, contributing to architectural designs, and enabling and mentoring your junior colleagues
• Ensure that our analytics warehouse and codebase is designed to support our growing enterprise business reliably, accurately and affordably
• Work closely with our fantastic Data Analysts, bringing an informed, opinionated viewpoint to frameworks; patterns and anti-patterns; templates; and code reviews in order to elevate code quality teamwide
• Identify opportunities for refactoring existing code; implement the refactoring; and lay the guardrails for fewer refactors in the future
• Assess new tools and technologies to support Fivetran Analytics, and lead the implementation and rollout of those tools
• Optimize our transformation layer for efficient and effective delivery of business intelligence to stakeholders throughout the organization
• Take end-to-end ownership of data product delivery, from design through implementation
• Technologies You’ll Use:
• Snowflake, GCP, BigQuery, SQLMesh, dbt, Looker, Sigma... and of course, Fivetran!