Senior Data Analytics Engineer

Ronald James Group; Newcastle upon Tyne; On-site; GBP 70,000 - 110,000; Full time

Job summary

Ronald James Group is seeking a Senior Data Analytics Engineer to own the analytics layer and be the main data contact across the business. You will model data, build reliable metrics, and communicate insights to senior leadership while supporting the Data Analyst and improving reporting and cost efficiency.

You will design data schemas for entities like members, subscriptions and payments, optimize the reporting layer with Snowflake, Omni/Looker/Tableau, and help drive data-driven decisions

Qualifications

• 3+ years' experience in Analytics Engineering or related data role.
• Strong experience building tested, version-controlled SQL transformations using dbt, SQLMesh or similar.
• Advanced SQL skills.
• Experience with a cloud data warehouse, ideally Snowflake.
• Experience with a modern BI or semantic-layer platform such as Omni, Looker, Tableau or similar.

Responsibilities

• Own the design of data schemas and modelling layers for core entities (members, subscriptions, payments).
• Develop presentation models powering reporting and BI; decide when to address requirements via queries vs new models.
• Own usability, performance and cost of the reporting layer; optimise reporting performance and costs.

Skills

Data modelling

Advanced SQL

dbt

Snowflake

BI/semantic layer

Python

Looker/Tableau

AWS

Tools

dbt

SQLMesh

Snowflake

Looker/Tableau

Job description

We’re looking for a Senior Data Analytics Engineer to own the analytics layer and become the main point of contact for data across the business. You’ll work closely with Product, Marketing, Finance and Operations to understand their data requirements, turn them into reliable models and metrics, agree priorities and clearly communicate what the numbers mean, including to senior leaders. You’ll also support the Data Analyst in working confidently with the data. You’ll be joining an established data platform with the ingestion layer already in place. Your focus will be on the modelling, analytics and reporting layer built on top of it.

What You’ll Own

• Data Modelling Own the design of data schemas and modelling layers. Build core entity models covering areas such as members, subscriptions and payments. Develop presentation models that power reporting and business intelligence. Determine when a requirement can be addressed through a query and when a new model is required.
• Reporting & Cost Own the usability, performance and cost of the reporting layer. Work with Omni and Snowflake to ensure the analytics platform remains efficient and scalable. Identify opportunities to improve reporting performance and optimise costs.

What We’re Looking For

• 3+ years' experience in Analytics Engineering or a closely related data role.
• Strong experience building tested, version-controlled SQL transformations using dbt, SQLMesh or similar.
• Advanced SQL skills.
• Experience working with a cloud data warehouse, ideally Snowflake.
• Experience with a modern BI or semantic-layer platform such as Omni, Looker, Tableau or similar.

Nice to Have

• Working knowledge of Python for data workflows, analysis or automation.
• Familiarity with AWS and cloud-based data pipelines.
• Hands‑on experience with Omni, including reporting and cost optimisation.