Principal Data Engineer

Summary

Join Fivetran's Analytics team as a Principal Data Engineer and become a leader in data quality and efficiency. You will optimize the transformation layer, monitor data observability, and design new tools and systems. This role requires deep SQL expertise, a strong understanding of data warehousing concepts, and experience with production code. You will collaborate with data analysts and mentor junior colleagues. This full-time, remote US-based position offers a competitive salary and comprehensive benefits, including 100% employer-paid medical insurance, generous PTO, RSU stock grants, and professional development opportunities.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• 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

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