Analytics Engineer

Who we are: Passenger is driven by a passion for escapism, connection, and the wellbeing of both people and the planet. As a fast growing brand in the outdoor sector, we create products that are 'made to roam' and embody a culture that embraces inclusivity and fosters a collaborative team environment. We’re looking for someone who shares our passion for protecting the planet while building something unique and authentic.

Overview: An opportunity has arisen for an Analytics Engineer to join our data team. You'll be responsible for building and maintaining the data transformation layer that powers analytics across Passenger, while creating compelling visualisations and insights that drive business decisions. Working closely with our Head of BI and Data, you'll translate business logic into robust dbt models and bring data to life through self-service dashboards and data storytelling in Lightdash. This role uniquely blends technical data engineering with business intelligence; you'll need to be as comfortable writing SQL and building dbt models as you are crafting dashboards and presenting insights to stakeholders. Your role will bridge the gap between raw data and business impact, building scalable data models that enable teams across the business to make data driven decisions, while also being the person who helps them understand what the data is telling them. We are always looking for the next edge, and we want someone who brings a genuine appetite for innovation and AI, so we can keep punching above our weight as a lean data team.

What you’ll be doing day to day:

• Build the transformation layer: Create and maintain dbt models that transform raw e-commerce data into analytics-ready datasets across customer, product, marketing, finance and operations domains.
• Tell data stories: Design and build intuitive dashboards and visualisations in BI that answer business questions and surface insights proactively.
• Partner with the business: Collaborate with teams across trade, marketing, finance, product, and operations to understand their needs and deliver analytical solutions that drive decisions.
• Write production-quality SQL: Build clean, well-tested, documented queries in dbt that adhere to data quality standards.
• Communicate insights: Present complex data findings in clear, compelling ways to both technical and non-technical audiences.
• Maintain documentation: Keep data models, metrics, and dashboards well-documented within dbt and our BI platform.
• Experiment and Innovate: Actively experiment with new AI tools and techniques, sharing learnings with the wider team to raise the bar on how we work with data.
• Support ad-hoc analysis and exploratory work on business projects.
• Leverage AI to support relevant research and analysis tasks.

What you will bring:

• Strong foundation and experience using BI and visualisation tools such as Lightdash/Looker or similar (Power BI, Tableau etc).
• Strong foundation and experience using dbt and knowledge of its core concepts and best practices.
• Well versed in database management tools and data structures, understanding of SQL & JSON.
• Familiar with data warehouse technologies such as Big Query, Snowflake.
• Familiar with ELT and ETL processes and data pipeline orchestration.
• Familiarity with automation platforms like N8N or Make.
• Strong interest and a keen drive to proactively embrace the use of AI for co-working and co-pilot functionalities to enhance your role and productivity.
• Strong analytical and problem solving skills.
• Strong Excel/Google Sheets skills.
• Ability to manage multiple projects simultaneously.
• 2+ years of experience in an Analytics Engineer, Data Analyst or BI developer role.
• Understanding of key E-commerce data models and concepts is desirable.

What we offer: We nurture and empower the whole you – mind, body, and spirit. Our rewards package is designed to fuel your passions, support your ambitions, and cultivate an environment where you can thrive. In addition to a competitive salary it includes:

• A culture of empowerment, freedom, flexibility, and trust.
• Escapism is serious business for us. We practise what we preach and connect together for quarterly in person cabin sessions and getting outside. Our HQ is in the New Forest, 5 minutes from the sea.
• Typical Hours: 8.30am - 5.30pm 5 days a week.
• Annual Leave: 25 days plus bank holidays + a day for your birthday.
• Very generous staff discount and friends and family discount.
• Private Medical Insurance for you and your dependants.
• Enhanced pension contributions.
• Annual Volunteering Day to support causes that matter to you.

Equal Employment Opportunity: All qualified applicants will receive consideration for employment without discrimination on the basis of race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or any other factors. Any applicant that believes they need reasonable accommodations to perform the duties of this role is invited to discuss this with us and let us know in your application.