Senior Data Engineer (dbt, Snowflake, Fivetran)

Onebright Ltd; York and North Yorkshire; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading mental health solutions provider in York is seeking an experienced Senior Data Engineer. The role involves maintaining a Snowflake-based data platform, supporting production pipelines, and mentoring junior engineers. Ideal candidates will have 5+ years of data engineering experience and strong SQL and Snowflake skills. Our company offers a competitive salary, a range of benefits, and the possibility of hybrid working arrangements.

Benefits

26 days holiday plus bank holidays

Employee assistance program

Private company pension

Continuous Professional Development access

Cash plan for health issues

Rewards gateway for savings

Hybrid working technology package

Access to learning and development platform

Referral cash rewards

Qualifications

• Minimum 5 years in data engineering roles, ideally with mentoring responsibilities.
• Deep, hands-on experience with Snowflake, performance tuning, and RBAC.
• Advanced SQL and data modelling expertise for large-scale environments.

Responsibilities

• Maintain and evolve Snowflake-based data platform.
• Support and stabilise production pipelines while driving improvements.
• Mentor less experienced engineers in best practices.

Skills

Snowflake

SQL

dbt Core or Cloud

Git-based workflows

Education

Bachelor's degree in STEM

Job description

Are you an experienced hands-on Senior Data Engineer ? Do you have a critical eye for detail? Onebright are seeking an experienced Senior Data Engineer to add to our growing data team.

About Our Opportunity

As a Senior Data Engineer you will play a leading role in the maintenance and evolution of our Snowflake-based data platform. This role blends BAU responsibility, technical ownership. and architectural oversight. You will support and stabilise production pipelines while driving structural improvements, ensuring alignment with scalable design, and mentoring less experienced engineers.

You’ll work across a layered medallion architecture (Bronze - Silver - Gold), owning core pipelines and models that feed our reporting, operational tooling and client-facing outputs. The platform is functional and actively used across the business, but we are continually enhancing quality, governance and modularity.

What we need from you

• Bachelor’s degree or higher in a STEM field (e.g. Computer Science, Data Engineering, Mathematics, Physics or other highly analytical field) or equivalent practical experience.
• Minimum 5 years in data engineering roles, ideally with some mentoring or technical leadership responsibilities.

• Deep, hands‑on experience with:
  • Snowflake (performance tuning, multi‑schema environments, RBAC, warehouse optimisation)
  • dbt Core or Cloud, including incremental logic, macros, YAML structure, and documentation
  • Git-based workflows (e.g. Bitbucket, GitHub)

• Advanced SQL and data modelling expertise, for large‑scale, layered warehouse environments (including medallion or modular layering).
• Excellent understanding of data modelling patterns, including SCD, dimensional and third normal form.
• Working knowledge of:

• Experience working in Agile data teams and delivering to deadlines in sprint‑based environments.

About Onebright

At Onebright we help individuals and organisations with mental health and wellbeing solutions, providing every person with the best mental healthcare, offering hope for a better future. We work across the mental health continuum from performance optimisation, early intervention, prevention, and treatment.

Onebright has been providing clinical excellence in mental health across the UK for 30 years. It is a pioneer in clinical assessments and treatment for children through to adults, delivering services through more than 3,000 clinicians in 49 languages to more than 55,000 people per year.

Our deep understanding of mental health and unrivalled clinical expertise enables us to support businesses from the first interaction with us through to recovery. We have a breadth of existing relationships with the UK’s leading service providers of EAP, PMI and OH which gives us a unique ability to deliver consistent care to employees from whichever channel they reach us.

At Onebright, we lead with integrity and compassion and are here to help our clients every step of the way.

How we say thank you

An exciting career is much more than just a salary. We also understand that everyone, regardless of culture, gender identity, religion, ethnicity, age, neurodiversity, or disability status, can contribute to our goal to make our work better for all. Our strength is in our people. At Onebright we have a range of benefits that include:

• 26 days holiday with an option to purchase more through our holiday purchase scheme. Plus bank holidays on top.
• When you need support, we rely on our excellent Employee assistance program to help you with your wellbeing.
• A private company pension with Royal London enabling you to keep one eye on the future.
• Your development is critical to our success so giving you access to Continuous Professional Development is always available to you.
• A very useful cash plan to help with those unexpected health issues such as dentist, eye wear or prescriptions and much more.
• Rewards gateway giving you access to an endless list of little perks and savings with retailers.
• Many of our teams are happy to work in a hybrid working pattern so we provide a technology package to keep you connected to your Onebright Team.
• Learning new skills is important so accessing our Onebright L&D platform will engage your enquiring mind.
• We encourage and reward our staff to “Refer Friends & Colleagues” with cash reward when they successfully join us.

Onebright we like to go further. So we want to ensure that once you get here, you’ll still be going places

PLEASE NOTE THIS POSITION IS BASED IN YORK.

Information to help you in your application.

• Onebright is committed to delivering in line with 'safer recruitment' principals and therefore the successful candidate will be required to undertake a credit check and a DBS check (Enhanced or Standard) with the Disclosure and Barring Service (DBS), the cost of which will be met by Onebright.
  • Onebright is committed to adhering to the Equality Act 2010 and provides equal opportunities to all applicants, staff and clients. Should you wish to discuss any adjustment or assistance you might need in the application or interview process, please contact our Recruitment Team and we will organise appropriate support.
  • Please note, all applicants must be legally entitled to accept and perform work in the UK and we will seek to complete a Right To Work check for all candidates.
  • For further information please email [e-mail] or call the Onebright Recruitment Team on 01904 933519 for more information.