Job Title: Sr. Data Engineer

Reports To: VP of Product and App DevelopmentClassification: Exempt

About us:

We are an innovative fitness brand making at-home, connected fitness more accessible. We offer a line of connected products – bikes, rowers, treadmills, fitness mirrors – and an app experience that empowers members to participate in live and on-demand fitness classes. 

We’re looking for a Sr. Data Engineer to maintain and improve upon our existing data pipeline. An excellent Sr. Data Engineer will extract and load data in a way that will ensure that our analysts have the resources to build and maintain clear reporting at the highest level of accuracy possible. 

What you’ll do:

• Own and manage extract/load tool responsible for data warehouse connections 

• Develop solutions for automated data extraction when a premade connector is not available

• Work together with the data team, project management, and internal stakeholders to understand the purpose and context of the data being brought into the warehouse 

• Fulfill vetted requests to extract or transform data to meet reporting requirements as appropriate 

• Audit existing data as necessary, working with the greater team to make and document changes. 

• Maintain comprehensive technical documentation 

Requirements:

• GCP Experience preferred - AWS or Azure also acceptable cloud-based experience. 

• Expert knowledge of Python and familiarity with software libraries such as PANDAS. 

• Apache Airflow 2.x experience 

• Functional knowledge of various Extract/Load tools such as Fivetran

• Working knowledge of DBT 

• Experience working in an agile environment and comfortable with project management tools such as JIRA

• Capable of writing clear and concise technical documentation and organizing it for use within a shared repository such as Confluence 

• A clear vision for purposeful data warehouse design

Nice-to-haves:

• CI/CD experience, such as with Github Actions

• Strong experience extracting data from SaaS platforms directly, such as Shopify or Stripe 

• Subscription domain expertise 

• Working knowledge of javascript/typescript in the context of writing functions 

• Can implement and maintain webhook connections