Senior Analytics Engineer, ProblemShared

• 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

Desirable

• 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
• 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
• Reporting to: Head of Analytics
• 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
• 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
• Work pattern: This is a permanent role, working 40 hours per week Monday to Friday

• 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
• Once we review your CV a member of our recruitment team will be in touch to learn more about your experience and motivations
• 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
• We would love to hear from you!