Analytical Engineer

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

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