Analytics Engineer - Architecture
From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.
Overview
As an Analytics Engineer on Fivetran’s internal Analytics team, you will be the standard-bearer for data quality and efficiency on a high-performance, industry-leading team. You will ensure that our analytics warehouse and codebase is designed to support our growing enterprise business reliably, accurately and affordably. You will work closely with our fantastic Data Analysts, bringing an informed, opinionated viewpoint to frameworks, tools, templates and code reviews in order to elevate code quality teamwide. You will identify opportunities for refactoring existing code, you will implement the refactoring, and you will lay the guardrails for fewer refactors in the future.
What You'll Do
- Champion our core values of #one-team-one-dream, #get-stuck-in, #do-the-right-thing.
- Be the standard-bearer for data quality and efficiency on a high-performance, industry-leading team.
- 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, tools, templates and code reviews in order to elevate code quality teamwide.
- Identify opportunities for refactoring existing code Implement the refactoring
- Lay the guardrails for fewer refactors in the future.
What You'll Bring
- A mastery of SQL
- An informed, opinionated stance on SQL style, normalization, Kimball, etc.
- A deep understanding of ERDs, DAGs and ETL/ELT
- An ability to take end-to-end ownership of data product delivery, from design through implementation
- You want to solve problems the RIGHT way, and you can clearly articulate why to a technical audience
Bonus Skills
- Deep experience working with dbt Core, including macro development and maintenance
- Experience scaling an ETL or other analytics codebase across several years and 10+ collaborators
- Good understanding of data governance and data security