
- Junior
- Ufficio in London
We’re looking for a mid-level Data Engineer to join us for a 6-month contract to help develop and improve the way we collect, transform, and visualise data about the Mental Health Act patient pathway. You’ll play a key role in supporting internal teams and external stakeholders by building tools, pipelines, and dashboards that turn complex data into actionable insight.
Key Responsibilities
- Build and maintain robust PostgreSQL queries and data pipelines to support analytics and reporting on the MHA patient journey.
- Ensure data quality and pipeline resilience in production environments.
- Work closely with backend engineers to align on architecture and data schema design.
Visualisation & Reporting
- Configure, manage, and evolve our Apache Superset dashboards to surface insights to internal teams and partner organisations (e.g. NHS Mental Health Trusts).
- Build flexible visualisation and report templates that meet the needs of clinical, operational, and compliance stakeholders.
- Support internal users (product, client, delivery teams) in interpreting and using the data effectively.
Collaboration & Delivery
- Work with product managers, the client team, and external partners (e.g., NHS, Police) to clarify dashboard/report requirements and iterate on delivery.
- Collaborate in our existing Jira + GitHub development process and contribute to a transparent, well-documented workflow.
- Operate within a TypeScript / AWS backend environment and bring experience that complements this stack.
Data Governance & Best Practice
- Uphold and improve data engineering best practices: version control, testing, documentation, and review processes.
- Help define and maintain consistent naming conventions, metric definitions, and access controls.
Skills, Knowledge and Expertise
Essential
- Strong SQL skills, especially PostgreSQL, and experience writing complex queries.
- Experience building and managing data pipelines in production.
- Working knowledge of Apache Superset (or similar BI tools like PowerBI, Tableau, Metabase or Looker).
- Excellent communication and stakeholder engagement skills.
- Strong analytical and problem-solving mindset with high attention to detail.
- A pragmatic approach to designing data solutions in a startup environment.
Nice to Have
- Familiarity with TypeScript and cloud-based infrastructure, particularly AWS (e.g., Aurora / Lambda).
- Experience working with Jira and GitHub as part of agile software development.
- Understanding of data privacy, security, and compliance—especially in healthcare or public sector contexts.
- Knowledge of or interest in mental health services or NHS operational structures.
Benefits
- 22 days holiday, plus bank holidays, plus your birthday and 3 days between Christmas & New Year (Pro Rata for term of contract)
- Free lunch twice a week
- Regular Socials