Senior Analytics Engineer

Please be aware although we are a remote organisation we do require candidates to reside in the UK.

Salary: Competitive

Work pattern: This is a permanent role, working 40 hours per week Monday to Friday.

Reporting to: Head of Analytics

About the Job

ProblemShared has a newly formed Data Office, and we’re looking for a Senior Data Analytics Engineer to shape our data platform and turn raw data into insights that drive better care and growth.

We believe in “data for good” - using insights to help neurodivergent people better understand themselves, enable practitioners to deliver more effective care, and guide teams in improving support. We're building a modern data platform (Fivetran → Databricks + DBT → PowerBI) that integrates data from clinical, operational and corporate systems into a safe, accessible, and reliable model, enabling real-time insight and continuous improvement.

At ProblemShared, we blend people, data and technology to support individuals on their mental health or neurodevelopmental journey - and we believe you can do the most meaningful work of your career here.

About Us

We are a practitioner-led, CQC-regulated, digital mind health provider, working with a community of expert practitioners to broaden access to the highest quality care for people across the UK. By leveraging technology, we aim to provide scalable and personalized solutions that enhance mental well-being and bridge gaps in mental healthcare delivery.

We work in partnership with institutions such as the NHS, insurance companies and universities to deliver therapy, psychiatry, neurodevelopmental assessments and post diagnostic care for adults, children and young people, mainly around Autism and ADHD. Key to our mission is the innovative and effective use of data analytics and resulting insights.

The Role

You’re the glue between raw data and self-service insights. As Senior Analytics Engineer, you’ll define and own our Gold-layer dimensional models (star schemas) in Databricks + DBT, and act as the product owner for our lakehouse platform. You’ll set the roadmap, prioritise transformation work, and ensure the pipeline meets both business and technical SLAs. Though modelling is your domain, you’ll stay fluent in ingestion patterns—able to advise the Data Engineer, jointly troubleshoot issues, and cover key Bronze/Silver tasks when needed.

What you'll do

• Shape the Medallion architecture: author and maintain DBT models (Bronze→Silver→Gold), tests and docs.
• Define the dimensional schemas (Client, Pathway, Partner, Time, etc.) and optimise them for performance and clarity.
• Act as product owner for the Data Platform: own backlog, prioritise work, and liaise with clinical/ops stakeholders.
• Partner with the Data Engineer to ensure upstream feeds align with model requirements, and with Analysts in the data team and beyond to help them answer their business questions.
• Lead platform-level CI/CD (dbt Cloud or GitHub Actions), automated testing (dbt test), and dbt docs.
• Mentor junior engineers in both transformation and ingestion best practices, ensuring mutual coverage and resilience.

What you will bring to the role

Must have

• 4+ years in analytics engineering or equivalent, with leadership of transformation pipelines, backed by CI/CD and version control in an established data team.
• Experienced DBT user, plus deep SQL fluency across ≥2 platforms (e.g. Databricks, Snowflake, Redshift, DuckDB).
• Clear understanding of dimensional modelling (star schemas) and medallion architecture.
• Hands-on with automated testing (dbt test) and documentation (dbt docs).
• Strong Python or R skills for custom macros and advanced transformations.
• Comfortable managing backlogs and prioritisation against stakeholder asks and SLAs.
• History of cross-training and documentation to ease team hand-offs.

Nice to have

• STEM degree (Computer Science, Engineering, Maths, Stats, Physics or equivalent).
• Experience with BI tools (PowerBI, Looker, Tableau, R/Shiny, Python/Dash).
• Delta Lake tuning (Z-order, partitioning) or ML feature pipelines.
• Familiarity with metadata/catalogue tools (Amundsen, DataHub).

What makes us different

• Fully remote, flexible: Work where you do your best thinking.
• Neurodiversity-welcoming: We encourage applications from autistic, ADHD and other neurodivergent candidates.
• Tool-agnostic, outcome-driven: We value mental agility and diverse tool experience (Snowflake, Redshift, DuckDB, Databricks, Python, R…) over narrow specialism.
• Inclusive by design: We focus on potential over pedigree, and adapt our process to support your needs. We also know that everyone has a life outside work, so we’re happy to discuss flexible working. We embrace difference and individuality and are proud to be equal opportunity employer.

What else do we offer you

• 30 days annual leave + public holidays + the option to buy and sell additional leave & extended leave options such as sabbatical leave
• Private health insurance and pension scheme
• Enhanced family friendly policies
• Flexible working with the option of free co-working
• All company and team in person meet ups
• Access to a range of wellbeing activities
• Access to development / training opportunities to support your career ambitions
• One volunteering day a year
• Our Recruitment Process and Next Steps

At ProblemShared, we see beyond just your CV. We're genuinely excited about who you are, your potential, and the unique qualities you bring to our team. We also recognise that life outside of work is important, which is why we prioritise being a flexible employer.

We're proud to be an equal opportunity and Disability Confident Committed employer and celebrate diversity and are ambitious in creating a recruitment process that allows everyone to shine and showcase their unique qualities. We offer tailored opportunities and adjustments to help each individual reach their full potential.

Screening

Once we review your CV a member of our recruitment team will be in touch to learn more about your experience and motivations.

Technical Interview

The next step is to meet with our hiring team who will take you through an interview to allow you to demonstrate your ability and suitability for the role. If successful we will move to an offer of employment and pre-employment checks.

We know that applying for a new role and considering a new team to join can be a daunting process. If you have never worked remotely before, this can also generate a lot of questions regarding the environment and ways of working. We aim to make your experience with us as informative and enjoyable as possible.

Please don't hesitate to apply - we would love to hear from you!