Main tasks
- Build and maintain pipelines that load source data into a cloud data warehouse
- Write SQL and dbt models that turn raw tables into reporting tables
- Handle first loads, later changes and resent files so that no record is counted twice
- Add tests that compare model output with the source records
- Document what each table holds and where its data comes from
- A degree in computer science, data science, mathematics or a related field, or equivalent training
- SQL with joins, GROUP BY and window functions
- Python for scripts or data processing
- At least one data project, at university, in an internship or at work
- dbt, Airflow or a similar tool
- Snowflake, BigQuery, Databricks or Azure Synapse
- Git
- 30 vacation days
- Employer-funded company pension
- Training budget for courses and certifications
- Laptop and home office setup
- Flexible hours with a daily overlap with Boston
