Your mission
This is a short-term contract to reset the foundations of our data warehouse and pipelines, so we can measure the success of our work and make data-driven decisions. You’ll build on our existing Azure warehouse (Data Factory, Azure SQL Database) to make sure data loads are regular and accurate. You’ll also set up separate dev and prod environments with dbt and Azure DevOps so the analytics team can keep developing after you leave. Clear, complete documentation and a handover to the team are the exit requirements.
Responsibilities- Build automated loads in Azure Data Factory from our source systems (APIs and file-based sources) into Azure SQL Database
- Set up dev and prod environments for our dbt project, with Azure DevOps pipelines for CI and deployment
- Trigger dbt runs from Data Factory when loads complete, with monitoring and alerts on failure
- Fix failing pipelines
- Document everything you build and hand it over to the analytics team
- Recommend pipeline improvements
Your profile
Competencies- Building and running production pipelines in Azure Data Factory
- Deploying dbt Core with CI/CD
- Clear communication and written documentation
- Working independently with minimal supervision
Experience- 5+ years on Azure data platforms, including Data Factory and Azure SQL, ideally with certification
- dbt Core in production
- REST API ingestion (authentication, pagination, incremental loads), ideally in Python
- Azure DevOps pipelines and git
- Working with a range of stakeholders, from analysts to non-technical teams
- Non-profit experience preferred but not required
Why us?
Reports to: Head of Data Analytics
Contract: 3-month Freelance contract
Ways of working: Fully remote, or London Waterloo twice a week (Wednesdays and Thursdays). We work a nine day fortnight.
Salary: £40-£60 per hour (for freelancers)
A work environment that values creativity, personal growth and collaboration.
Applications will close on Sunday 22nd November.
Right to work in the UK
To apply, you will need to have a valid right to work in the UK (such as a British/Irish passport, Settled Status, or Indefinite Leave to Remain).
