jobapplier

Azure Data Engineer (3-month contract)

CALM (Campaign Against Living Miserably)

Skills

Required

  • Data
  • Azure SQL
  • Azure Data Factory
  • Azure DevOps pipelines
  • CI/CD
  • Azure data platforms
  • authentication
  • pagination
  • incremental
  • Python
  • git

Preferred

  • Azure DevOps
  • Azure SQL Database
  • CI
  • APIs
  • file-based sources
  • deployment

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.

About CALM (Campaign Against Living Miserably)

We’re Campaign Against Living Miserably (CALM), and we’re united against suicide.

We’re a suicide prevention charity, on a mission to help people end their misery, not their lives. We run stigma-smashing campaigns, offer loads of digital tools and resources, and run a life-saving helpline - all designed to help people find hope and a way forward. We are - united against suicide.

Don't meet every requirement? We’re still interested.

If you're passionate about our mission but your experience doesn't tick every box, we'd still love to hear from you. You could be exactly who we're looking for.

We are committed to safeguarding and promoting the welfare of children, young people, and adults at risk, both offline and online. We recognise that harm can occur in physical, digital, and virtual environments, and we take our safeguarding responsibilities seriously across all areas of our work.

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

Requirements

  • 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

  • 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
  • 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).

Pay

£40-£60 per hour (for freelancers)

Benefits

  • A work environment that values creativity, personal growth and collaboration.

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.

Applications will close on

Sunday 22nd November.

Research shows that people from marginalised groups – including women, LGBTQ+ people, people from global majority backgrounds, disabled people, and those from lower socioeconomic backgrounds – are less likely to apply for a role unless they meet the full criteria. At CALM, we know that skills and potential come in many forms, and that diverse perspectives and lived experience of mental health or suicide can be just as valuable as formal qualifications.

Safeguarding

Apply with Jobapplier