Play a key role in the Analytics Engineering function and dbt environment. You will build and maintain scalable data models from the staging layer through to the "Golden Layer," with a focus on performance and reliability on AWS Redshift.
Serve as a technical data partner for Product, Operations, Commercial, and other business functions. You will translate business requirements into robust data models and ensure cross-functional teams have the reliable data foundations they need.
Work closely with the Lead Data Engineer and Analytics Lead to contribute to the overall data strategy. Support the growth of more junior team members through code reviews, knowledge sharing, and day-to-day guidance.
Contribute to the code-based backend of our BI environment (Lightdash & Count), supporting the development and maintenance of the Semantic Layer and assisting in the integration of AI capabilities (e.g., text-to-SQL) to advance self-serve analytics.
Actively champion software engineering best practices within the data team, including Gitlab/GitHub workflows, CI/CD pipelines, testing frameworks, and documentation-as-code. Contribute to the development of automations and AI capabilities within the Analytics Engineering function.
Requirements
3+ years of highly technical experience with dbt and SQL. You write DRY, optimised code, build macros, manage dbt packages, and can troubleshoot performance bottlenecks.
Strong hands-on experience with AWS Redshift (or a similar cloud warehouse like Snowflake/BigQuery), including solid understanding of query optimisation and warehouse architecture. You are familiar with DAG structures and how the transformation layer interfaces with orchestration tools like Apache Airflow or similar.
Some experience mentoring or supporting more junior data team members, whether through code reviews, pairing, or informal guidance. You enjoy sharing knowledge and contributing to a collaborative, inclusive engineering culture.
You're comfortable partnering with non-technical stakeholders across Product, Commercial, and Ops to understand data needs and translate them into well-structured solutions. You can proactively flag data quality or architectural issues and suggest improvements.
Solid experience working with the code-first backend of modern BI tools (ideally Lightdash & Count, or similar). You have a good understanding of Semantic Layer concepts and are keen to develop further in this area.
A genuine interest in engineering efficiency. You have some experience — or a strong appetite to build it — using AI and automation tools, scripting, and workflows to reduce repetitive manual work within a data function.
Tech Stack
Airflow
Amazon Redshift
Apache
AWS
BigQuery
Cloud
SQL
Benefits
💰 Competitive salary.
🌴 30 days annual leave, plus bank holidays.
🏆 Accredited 'Great Place To Work’ company in three categories.
🧠 Commitment to personal development and career growth, coaching workshops and progression plans.
👩🏽💻Remote-first working environment. This means you’re not obligated to come into the office, you can choose the environment you think you excel best in with up to 180 days working from abroad (subject to approval — sadly, we can’t say yes to every beach).
📅Flexible working hours (start between 8-10am and finish between 4:30-6:30pm).
❤️ Focus on welfare. We offer a monthly wellness allowance, gym memberships, access to mental health first aiders, a health cash plan and more.
🛍️ Access to incredible partnership discounts for the biggest brands in the world. Think Google, Apple, GymShark, Domino's, Uber and loads more.
💻 £200 work from home set up allowance to put towards your at-home working space.