Job Title: Sr. Data Engineer
Reports To: VP of Product and App Development
Classification: 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