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 an analytics 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 analytics engineer who is ready to step into that future with us.

The Principal Analytics Engineer 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 remotely in the US.

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 an analytics 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-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.

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

Pay Range

$181,120—$226,400 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.