Analytical Engineer

Salary: £61,000 - 93,000 per year

Requirements:

• 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
• Experience working with dbt or similar transformation and orchestration tools
• Experience building semantic models or reusable business logic for BI, analytics or self-service reporting
• Experience 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
• Experience improving data quality, lineage, governance and trust across analytical datasets
• Experience working closely with analysts, engineers, product teams and business stakeholders to turn complex requirements into practical data solutions
• Strong communication skills with both technical and non-technical audiences
• Ability to make 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
• Nice to have: Exposure to AI-enabled analytics, text-to-SQL, natural language interfaces or agentic data workflows
• Nice to have: Experience using AI tools such as Claude, Gemini or similar to improve SQL development, testing or documentation
• Nice to have: Understanding of how AI agents consume structured data, metric definitions and business context
• Nice to have: Experience working with data contracts, medallion-style architecture or silver-to-gold data modelling patterns

Responsibilities:

• Design, build and maintain trusted analytical models, transformations and semantic definitions across key business domains
• Create clear, reusable metric definitions that help ensure teams are working from a consistent source of truth
• Work closely with Data Engineers to define requirements between refined data layers and business-ready analytical products
• Build and improve dbt models, tests and documentation to support reliable, well-governed analytics
• Help shape semantic layers that support BI tools, modern analytical workbenches and emerging AI use cases such as natural language analytics and text-to-SQL
• Improve data quality through testing, monitoring, validation and clear ownership of analytical models
• Partner with stakeholders to understand reporting and insight needs, then translate them into scalable, maintainable data products
• Support self-service analytics by making data easier to discover, understand and use across the business
• Explore how AI-assisted tools can improve analytical engineering workflows, including SQL review, test generation, documentation and quality checks

Technologies:

• AI
• AI Agents
• BigQuery
• Business Intelligence
• CI/CD
• Cloud
• Databricks
• Git
• Support
• Looker
• SQL
• Snowflake
• dbt

More:

Were On the Beach, a travel business that has been rewriting how people discover, book and experience holidays since 2003. We send around two million holidaymakers on their dream breaks every year and continue to grow, powered by our entrepreneurial spirit, proprietary tech, curiosity and great people. This Analytical Engineer role sits at the intersection of data engineering, business intelligence and emerging AI capabilities, based from our Aeroworks office in Manchester City Centre with hybrid working: full time hours are 37.5 per week, core hours are 10am to 4pm, and we work from home plus the office one day every two weeks, with the option to come in more often. Our benefits package, Beach Perks, includes 25 days holiday plus your birthday off, holiday discounts, extra leave when using an On the Beach package holiday, learning and development support, enhanced family leave, wellbeing support, health cover, company sick pay, gym discount, a share incentive plan, onsite coffee shop, our bar The Sandbox, Manchester food and drink discounts, regular social events and cycle to work.

last updated 34 week of 2026