Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Build and maintain scalable data models, translating business needs into robust solutions.
- Company: Join Pion, a leader in tech innovation for major retailers, fostering a diverse and inclusive culture.
- Benefits: Enjoy a competitive salary, 30 days annual leave, and opportunities for professional growth.
- Other info: Collaborative environment focused on innovation, learning, and career advancement.
- Why this job: Make a real impact by shaping data strategies and empowering teams with reliable insights.
- Qualifications: 3+ years of experience with dbt, SQL, and AWS Redshift; mentoring skills are a plus.
The predicted salary is between 60000 - 75000 £ per year.
A little bit about us… Pion produces award-winning technology for the biggest retailers on the planet, connecting them with the youth market. We’re constantly innovating to offer new solutions that satisfy our consumers, drive ROI for our clients, and create an empowering workplace for our employees.
At Pion, we’re driven by big ideas and bold thinkers. Our purpose is clear: We make it possible to reward those who shape our world, from Students to Healthcare workers and more. That mission demands diverse perspectives and a culture where everyone belongs. Our people power everything we do from innovation to collaboration. We’re here to break down barriers and build a space where everyone can grow, learn, and thrive—because affordability starts with empowered people.
Research shows that while men apply to jobs when they meet 60% of the requirements, women and those in underrepresented groups tend to only apply when they tick every box. We don’t think you should have to tick every box. We value your uniqueness, and it goes without saying that all applications are welcome, even if you don’t think you fit the criteria.
About the role. As a result of our incredible success and growth, we are looking for a Lead Analytics Engineer to join us.
Responsibilities include:
- 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.
A little bit about you:
- 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.
Life at Pion. Let’s take a look at a few things that make Pion an amazing place to work… Competitive salary. 30 days annual leave, plus
Senior Analytics Engineer in London employer: Wearepion
Contact Detail:
Wearepion Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Analytics Engineer in London
✨Tip Number 1
Network like a pro! Reach out to current employees at Pion on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for your application process. Personal connections can make a huge difference!
✨Tip Number 2
Prepare for the interview by diving deep into Pion's products and values. Understand how your skills as a Senior Analytics Engineer can contribute to their mission. Show them you’re not just another candidate, but someone who truly gets what they’re about.
✨Tip Number 3
Practice your technical skills! Brush up on dbt, SQL, and AWS Redshift. Be ready to showcase your problem-solving abilities during technical interviews. We want to see how you think and approach challenges, so don’t hold back!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in being part of the Pion team. Let’s get you that dream job!
We think you need these skills to ace Senior Analytics Engineer in London
Some tips for your application 🫡
Show Your Unique Self: Don’t stress about ticking every box in the job description. We value your uniqueness, so let your personality shine through in your application. Share your experiences and how they relate to the role!
Tailor Your Application: Make sure to customise your CV and cover letter for the Senior Analytics Engineer position. Highlight your experience with dbt, SQL, and AWS Redshift, and explain how you can contribute to our team at Pion.
Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to see your key skills and achievements. We love a well-structured application!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Wearepion
✨Know Your Tech Inside Out
Make sure you brush up on your dbt and SQL skills before the interview. Be ready to discuss how you've used these tools in past projects, especially focusing on performance optimisation and troubleshooting. Pion values technical expertise, so showcasing your hands-on experience with AWS Redshift will definitely give you an edge.
✨Understand Their Business Needs
Familiarise yourself with Pion's mission and how they connect retailers with the youth market. Think about how your role as a Senior Analytics Engineer can support their goals. Prepare examples of how you've translated business requirements into data solutions in previous roles, as this will demonstrate your ability to partner with non-technical stakeholders.
✨Showcase Your Mentorship Skills
Pion is looking for someone who can support junior team members. Be prepared to share specific instances where you've mentored others, whether through code reviews or informal guidance. This will highlight your collaborative spirit and commitment to fostering an inclusive engineering culture.
✨Emphasise Your Interest in Innovation
Since Pion is all about innovation, express your genuine interest in engineering efficiency and automation. Discuss any experience you have with AI tools or scripting that can reduce manual work. This will show that you're not just technically skilled but also forward-thinking and aligned with their values.