27 applicants

Company

Fivetran · 2 days ago

Principal Analytics Engineer

Remote, Oregon, United States, AMER

Full-time

Remote

Lead/Staff

$181K/yr - $226K/yr

Maximize your interview chances

AnalyticsCloud Data Services

H1B Sponsor Likely

Insider Connection @Fivetran

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Advanced SQLBigQueryETL/ELTPythonData governanceData securityCI/CDDAGsERDsNormalizationKimballAnalytics engineeringProduction codeCode debugging

Required

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

Preferred

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

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.

Company

Fivetran

Glassdoor

3.5

Fivetran is a technology company that automates replicating data into a cloud data platforms.

Founded in 2012

Oakland, California, USA

1001-5000 employees

https://fivetran.com

H1B Sponsorship

Fivetran has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (7)

2022 (29)

2021 (14)

2020 (13)