Analytical Engineer

We’re On the Beach! Since 2003, we've been rewriting the rules of how people discover, book, and experience their perfect getaway. What started as connecting people to short-haul beach holidays has evolved into something much bigger - premium beach destinations, long-haul adventures, and vibrant city breaks – and that’s just the beginning of our story.We send around two million holidaymakers on their dream breaks every year. And we're still growing.Powered by our deep-rooted entrepreneurial spirit, proprietary tech, curiosity and our incredible people, we’re accelerating - delivering best in class technology, the ultimate holiday app, and experiences that keep our customers coming back for more.Ready to build the future of travel with us About the RoleWe’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 dayAs 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 domainsCreating clear, reusable metric definitions that help ensure teams are working from a consistent source of truthWorking closely with Data Engineers to define requirements between refined data layers and business-ready analytical productsBuilding and improving dbt models, tests and documentation to support reliable, well-governed analyticsHelping shape semantic layers that support BI tools, modern analytical workbenches and emerging AI use cases such as natural language analytics and text-to-SQLImproving data quality through testing, monitoring, validation and clear ownership of analytical modelsPartnering with stakeholders to understand reporting and insight needs, then translating them into scalable, maintainable data productsSupporting self-service analytics by making data easier to discover, understand and use across the businessExploring how AI-assisted tools can improve analytical engineering workflows, including SQL review, test generation, documentation and quality checksYou’ll be a great addition to our team if you have the following skills, knowledge and experienceStrong SQL skills and experience building analytical data models in a production environmentData modelling approaches such as dimensional modelling, star schemas, metric layers or similarWorking with dbt or similar transformation and orchestration toolsBuilding semantic models or reusable business logic for BI, analytics or self-service reportingWorking in cloud data environments such as Databricks, BigQuery, Snowflake or similarApplying engineering practices to analytics, including Git, pull requests, testing, documentation and CI/CDImproving data quality, lineage, governance and trust across analytical datasetsWorking closely with analysts, engineers, product teams and business stakeholders to turn complex requirements into practical data solutionsCommunicating clearly with both technical and non-technical audiencesMaking pragmatic decisions in fast-moving environments, balancing quality, usability and deliveryNice to haveExperience with enterprise semantic layers or tools such as Hex, Looker, Cube, dbt Semantic Layer or similarExposure to AI-enabled analytics, text-to-SQL, natural language interfaces or agentic data workflowsExperience using AI tools such as Claude, Gemini or similar to improve SQL development, testing or documentationUnderstanding of how AI agents consume structured data, metric definitions and business contextExperience working with data contracts, medallion-style architecture or silver-to-gold data modelling patternsWhat success looks likeSuccess 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 processWe’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 workingOur 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 benefitsWe 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 offGenerous 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 holidayAccess to Learnerbly learning platform, plus workshops, courses and professional qualificationsEnhanced maternity, paternity, shared parental leave and adoption pay, plus other family friendly supportEmployee Assistance Programme and free access to counsellingSimplyhealth Optimise Health PlanCompany Sick Pay schemeRegular wellbeing eventsGym discountShare Incentive Plan (SIP)Death in Service coverOnsite subsidised coffee shopThe Sandbox (our very own bar)Food and drink discounts across a number of venues in Manchester City CentreRegular social eventsCycle to Work scheme