Analytics Engineer
Oakland, California, United States, AMER
Full Time Senior-level / Expert USD 131K - 158K
Fivetran
Effortlessly centralize all the data you need so your team can deliver better insights, faster. Start for free.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’re looking for an Analytics Engineer to join our team focused on the Quickstart data model product—a suite of open-source dbt packages that help customers jumpstart their analytics by providing high-quality, opinionated data models out of the box.
In this role, you’ll contribute to the development of new features for our existing Quickstart data models, help maintain and improve them through bug triage and resolution, and support the creation of new models that expand our coverage. You’ll collaborate closely with other analytics engineers, data analysts, and stakeholders to understand common analytics use cases and translate them into clean, well-documented dbt code. This is a great opportunity to deepen your experience with dbt, data modeling, and open-source development, while working on a product that directly helps other analytics teams move faster.
This is a full-time, hybrid position based out of our Oakland, CA office. Our hybrid work model offers a blend of remote flexibility and in-person collaboration, including two days in the office each week to connect and build as a team.
Technologies You’ll Use
- Fivetran
- dbt
- Git
- Snowflake, BigQuery, Redshift, Postgres, Databricks
- Looker
- Sigma
What You’ll Do
- Participate in the triage, investigation, and resolution of bugs or issues reported by users of our dbt packages.
- Collaborate with other Analytics Engineers and cross-functional partners to share learnings, align on technical patterns, and improve our products over time.
- Develop a deep understanding of Fivetran source schemas, table relationships, and how they map to common analytics use cases.
- Build and maintain external-facing dbt packages and analytics models that help customers get immediate value from their Fivetran data pipelines.
- Collaborate with customers through feedback sessions to better understand their goals, pain points, and how our data models can help them move faster.
- Write clean, well-documented, and reliable SQL queries, and BI templates that meet our standards for quality and maintainability.
- Conduct independent research to understand source systems, industry use cases, and best practices when working on new or unfamiliar projects.
Skills We’re Looking For
- Strong verbal and written communication skills, with the ability to clearly explain technical concepts to both technical and non-technical stakeholders.
- Collaborative mindset and eagerness to work cross-functionally with product managers, data analysts, engineers, and customers.
- Highly resourceful and self-motivated. You’re comfortable navigating ambiguity, proactively unblocking yourself, and managing multiple priorities in a fast-paced environment.
- A genuine passion for data and analytics, with curiosity about how data is used to drive business decisions.
- Hands-on experience using dbt.
- Proficiency in writing intermediate SQL. You can confidently write joins, CTEs, window functions, and optimize queries for readability and performance.
- Familiarity with BI tools (e.g., Looker, Tableau, Sigma) and/or cloud data warehouses like BigQuery, Snowflake, or Redshift.
Bonus Skills
- Experience contributing to or consuming open-source dbt packages.
- Familiarity with Python.
#LI-HYBRID #LI-MD1
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.
Oakland Pay Range$131,664.05—$158,003.18 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 cell phone stipend
- Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.
*May vary by country and worker type - please reach out to your recruiter for more information
Click here to learn more about Fivetran's Benefits by Region.
We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.
Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.
To learn more about Fivetran’s culture and what it’s like to be part of the team, click here and enjoy our video.
To learn more about our candidate privacy policy, you can read our statement here.
We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.
Tags: BigQuery Databricks Data pipelines dbt Engineering FiveTran Git Looker Open Source Pipelines PostgreSQL Privacy Python Redshift Research Snowflake SQL Tableau
Perks/benefits: Career development Cell phone stipend Equity / stock options Flex vacation Health care Home office stipend Insurance Medical leave Parental leave Salary bonus Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.