Analytical Engineer
Role Overview
We’re looking for an Analytical Engineer to help shape the trusted data models, metrics and semantic layers that power decision-making across On the Beach.
This role sits at the intersection of data engineering, business intelligence and emerging AI capabilities. You’ll help turn refined data into reliable, reusable and well-documented analytical products that can be trusted by teams across the business.
You’ll play a key role in making sure our data is not only accurate and well-modelled, but also easy to understand, easy to use and ready to support future AI-enabled analytics.
Key Skills for This Role
Full Job Posting
About the Role
We’re looking for an Analytical Engineer to help shape the trusted data models, metrics and semantic layers that power decision-making across On the Beach.
This role sits at the intersection of data engineering, business intelligence and emerging AI capabilities. You’ll help turn refined data into reliable, reusable and well-documented analytical products that can be trusted by teams across the business.
You’ll play a key role in making sure our data is not only accurate and well-modelled, but also easy to understand, easy to use and ready to support future AI-enabled analytics.
What you’ll be doing day to day
As an Analytical Engineer, you’ll work closely with Data Engineering, Analytics, Product, Commercial and Technology teams to create high-quality analytical data products.
You’ll help define and maintain the business logic, metrics and semantic structures that sit between our data platform and the teams using data every day.
You’ll be responsible for:
Designing, building and maintaining trusted analytical models, transformations and semantic definitions across key business domains
Creating clear, reusable metric definitions that help ensure teams are working from a consistent source of truth
Working closely with Data Engineers to define requirements between refined data layers and business-ready analytical products
Building and improving dbt models, tests and documentation to support reliable, well-governed analytics
Helping shape semantic layers that support BI tools, modern analytical workbenches and emerging AI use cases such as natural language analytics and text-to-SQL
Improving data quality through testing, monitoring, validation and clear ownership of analytical models
Partnering with stakeholders to understand reporting and insight needs, then translating them into scalable, maintainable data products
Supporting self-service analytics by making data easier to discover, understand and use across the business
Exploring how AI-assisted tools can improve analytical engineering workflows, including SQL review, test generation, documentation and quality checks
You’ll be a great addition to our team if you have the following skills, knowledge and experience
- Strong SQL skills and experience building analytical data models in a production environment
- Data modelling approaches such as dimensional modelling, star schemas, metric layers or similar
- Working with dbt or similar transformation and orchestration tools
- Building semantic models or reusable business logic for BI, analytics or self-service reporting
- Working in cloud data environments such as Databricks, BigQuery, Snowflake or similar
- Applying engineering practices to analytics, including Git, pull requests, testing, documentation and CI/CD
- Improving data quality, lineage, governance and trust across analytical datasets
- Working closely with analysts, engineers, product teams and business stakeholders to turn complex requirements into practical data solutions
- Communicating clearly with both technical and non-technical audiences
- Making pragmatic decisions in fast-moving environments, balancing quality, usability and delivery
- Nice to have
- Experience with enterprise semantic layers or tools such as Hex, Looker, Cube, dbt Semantic Layer or similar
- Exposure to AI-enabled analytics, text-to-SQL, natural language interfaces or agentic data workflows
- Experience using AI tools such as Claude, Gemini or similar to improve SQL development, testing or documentation
- Understanding of how AI agents consume structured data, metric definitions and business context
- Experience working with data contracts, medallion-style architecture or silver-to-gold data modelling patterns
- What success looks like
- Success in this role is about helping the business trust and use data with confidence.
- You’ll create reliable analytical models, clear metric definitions and reusable semantic layers that support better decisions across the business. You’ll help reduce ambiguity in reporting, improve the quality of business-ready data, and make our analytical products easier to find, understand and reuse.
- You’ll also help us prepare for the next generation of data consumption, where AI tools and natural language interfaces rely on well-structured, well-documented and trusted data foundations.
What to expect from our interview process
We’ll run a multiple stage interview process, on Teams/ Google meets which will consist of a Hiring Manager meet & Greet, Behavioural and Technical.
We want to make sure everybody has the opportunity to perform at their best. If you require any reasonable adjustments during the interview process please let the Talent Acquisition team know and they will be happy to assist.
Ways of working Our full time hours are 37.5 per week, but we don't have rigid working hours so you can find the working pattern that's right for you. We have core working hours between 10am - 4pm, so we can collaborate and enjoy the social side of work.
We also have hybrid working so we all work from home and from our Aeroworks office in Manchester City Centre. You’ll be in the office one day every two weeks, and you’re more than welcome to come in more if you’d like.
Our benefits
- We might be biased but we think our colleagues are pretty great. They're the people that have made On the Beach what it is today and continue to make it vibrant and successful tomorrow. That's why we offer a competitive benefits package, known as our Beach Perks, to all On the Beach colleagues.
- These include:
- 25 days holiday plus your birthday off
- Generous discount on holidays, plus you will receive 2 extra days annual leave on top of your holiday allowance to use whilst you're away on your On the Beach package holiday
- Access to Learnerbly learning platform, plus workshops, courses and professional qualifications
- Enhanced maternity, paternity, shared parental leave and adoption pay, plus other family friendly support
- Employee Assistance Programme and free access to counselling
- Simplyhealth Optimise Health Plan
- Company Sick Pay scheme
- Regular wellbeing events
- Gym discount
- Share Incentive Plan (SIP)
- Death in Service cover
- Onsite subsidised coffee shop
- The Sandbox (our very own bar)
- Food and drink discounts across a number of venues in Manchester City Centre
- Regular social events
- Cycle to Work scheme
About On the Beach
UK online package-holiday specialist serving holidaymakers with short- and long-haul beach holidays, city breaks, and cruises.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at On the Beach
CRM and Social Media Executive
Manchester, GBR
On the Beach is seeking a customer engagement executive to deliver trading email, push and organic social content. The role combines campaign coordination, copywriting, customer insight and performance testing; experienc
SEO & GEO Assistant
Manchester, GBR
CRM and Social Media Executive
Manchester, GBR
CRM and Social Media Executive
Manchester, GBR
Senior Platform Engineer (DevEx and Cloud Ops)
Manchester, GBR
Platform Operations Specialist
Manchester, GBR
Customer Insights Specialist
Manchester, GBR
Senior Software Engineer - Backend
Manchester, GBR
Principal Engineer
Manchester, GBR