Senior Analytics Engineer

Pion produces award-winning technology for the biggest retailers on the planet, connecting them with the youth market. We are constantly innovating to offer new solutions that satisfy our consumers, drive ROI for our clients, and create an empowering workplace for our employees. Life at Pion 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, and we’re here to break down barriers and build a space where everyone can grow, learn, and thrive because affordability starts with empowered people. Check out our SHARP values to learn more about our culture. Research shows that while men apply to jobs when they meet 60% of the requirements, women and those in under‑represented 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 * Play a key role in the Analytics Engineering function and dbt environment, building and maintaining 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, translating business requirements into robust data models and ensuring cross‑functional teams have reliable data foundations. * Work closely with the Lead Data Engineer and Analytics Lead to contribute to the overall data strategy, supporting 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 troubleshoot performance bottlenecks. * Strong hands‑on experience with AWS Redshift (or a similar cloud warehouse such as Snowflake/BigQuery), with 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. * Some experience mentoring or supporting more junior data team members through code reviews, pairing, or informal guidance. * 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 understand Semantic Layer concepts and are keen to develop further in this area. * 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. 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 – you can choose the environment you think best suits you. * Flexible working hours (start between 8‑10 am and finish between 4:30‑6:30 pm). * Focus on welfare: monthly wellness allowance, gym memberships, access to mental‑health first aiders, a health cash plan and more. * Access to partnership discounts for major brands (e.g., Google, Apple, GymShark, Domino’s, Uber). * 200 USD work‑from‑home set‑up allowance for your at‑home workspace. Participants should be aware that due to the high volume of applicants, we can only respond to shortlisted candidates. By submitting your application, you agree that Pion may collect and process your personal data for recruiting and related purposes in accordance with our Applicant Privacy Notice. J-18808-Ljbffr