Senior Data Engineer - Analytics

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.

  About the Role   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 a 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 design and implementation of new tools and systems. You’ll also be responsible for ensuring the technical excellence of your team by reviewing code, contributing to architectural designs, and mentoring your junior colleagues.    This is a full-time position based out of our Oakland office (Hybrid/Remote).   Technologies You’ll Use We emphasize using no-nonsense tools, and take great pride in the simplicity and effectiveness of the systems we build. Our Modern Data Stack is made up primarily of Python, BigQuery, dbt, Looker, Slack, Google Cloud Functions, and of course, Fivetran!   What You’ll Do

• 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; and lay the guardrails for fewer refactors in the future.
• Lead the development and enablement of new tools and technologies to support Fivetran Analytics.
• Optimize our transformation layer for efficient and effective delivery of business intelligence to stakeholders throughout the organization.

Skills We’re Looking For

• Deep familiarity with advanced SQL in a modern data warehouse environment (BigQuery, Redshift, Snowflake, etc)
• 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
• A desire to solve problems the RIGHT way, and the ability to clearly articulate WHY to a technical audience
• Experience writing production code, and debugging and deciphering code written by others

Bonus Skills​

• Applied knowledge of a scripting language, preferably Python, in a data engineering context
• Experience scaling an ETL or other analytics codebase across several years and 10+ collaborators
• Good understanding of data governance and data security
• Experience with CI/CD implementations for the modern data stack

#LI-HYBRID #LI-RS1

The pay range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the target position and level. Our pay ranges are determined by role, level, and location. Our job titles may span more than one career level. Within the range, individual pay is determined by additional factors, including job-related skills, experience, relevant education or training, business need, market demands. The pay range is subject to change and may be modified in the future. Your recruiter can share more about the specific pay range for your location during the hiring process.

This range represents base salary only and does not include incentive for sales roles, equity, or  benefits, if applicable. 

Pay Range$154,560—$193,200 USD

Perks and Benefits

• 100% employer-paid medical insurance*
• Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off
• RSU stock grants*
• Professional development and training opportunities
• Company virtual happy hours, free food, and fun team-building activities
• Monthly cel