Job Closed

This listing is no longer active.

Senior Analytics Engineer

Location

United Kingdom

Posted

66 days ago

Salary

0

Seniority

Senior

Job Description

Senior Analytics Engineer

Pion

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. Life at Pion Where People Thrive 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. Check out our SHARP values to find out more about our culture. 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.  Need any adjustments to support you with your application? Just drop us an email at talent@wearepion.com. 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.

Job Requirements

  • A little bit about you.
  • We’d really like to hear from you, if you have
  • 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.

Benefits

  • 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 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.
  • 📅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.
  • Want to know more?
  • Check out our career site for everything you need to know about starting a career with Pion.
  • Due to the high volume of applicants, we can only respond to shortlisted applicants. By submitting your application, you agree that Pion may collect your personal data for recruiting, global organisation planning, and related purposes. Our Applicant Privacy Notice explains what personal information and where we may process, our purposes for processing, and the rights you can exercise over Pion’s' use of your personal information.
  • #LI-JS1
  • #LI-Remote

Related Categories

Related Job Pages

More Engineer Jobs

Full TimeRemoteTeam 11-50H1B No Sponsor

• Design, build, and maintain mobile applications for iOS and Android using frameworks such as Swift, Kotlin, Flutter, or React Native • Ensure mobile apps meet government requirements for security, privacy, accessibility, and reliability • Collaborate with backend engineers to integrate APIs and services into robust mobile experiences • Translate customer and policy requirements into mobile-first product designs and implementations • Work closely with UX designers to deliver intuitive and inclusive user experiences for public sector audiences • Partner with customer delivery leads to ensure successful deployments, testing, and operations in production environments • Contribute to standards adoption by ensuring mobile implementations align with global digital identity protocols • Provide technical guidance to public sector partners on mobile app deployment, security, and operations

United States
$150K - $175K / year
Job Closed
Engineer66 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

• Define technical strategy and architecture for public sector deployments, ensuring both technical excellence and alignment with policy and operational needs • Act as the senior technical representative in executive-level customer meetings, bridging the gap between technical details and business or policy outcomes • Lead multiple end-to-end multi-year projects from rapid prototyping to development to operations and maintenance • Architect and build backend systems, full-stack web applications, and mobile solutions with a focus on security, privacy, and accessibility • Translate government requirements into robust, standards-based solutions that integrate with both modern and legacy systems • Mentor and guide forward deployed engineers and delivery teams, setting standards for high-quality engineering and customer collaboration • Identify and drive efficiencies across projects, ensuring knowledge and tooling are shared across teams • Collaborate with platform teams to feed customer insights into SpruceID’s roadmap and contributions to global identity standards.

United States
$200K - $225K / year
Job Closed
Engineer66 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

• Lead the design and development of products and solutions for state governments and enterprise customers • Work side-by-side with customer delivery leads, engineers, and UX designers to ensure successful projects delivery and deployments • Translate customer requirements into technical architectures and working implementations • Act as a trusted technical advisor to public sector partners, guiding them through standards adoption and best practices • Build backend software and full-stack web and mobile applications that meet public sector security, privacy, and accessibility standards • Contribute to new and existing Rust codebases that run on backend services, mobile devices, and in the browser • Manage customer deployments and support operations

United States
$150K - $175K / year
Job Closed
The College Board logo

Senior Engineer, Platform Threat Intelligence

The College Board

Clearing a path for all students to own their future

Engineer66 days ago
Full TimeRemoteTeam 1,001-5,000Since 1900H1B No Sponsor

• Collect, curate, and analyze intelligence relevant to College Board products and adjacent services • Assess adversary behaviors and trends to identify defensive and investigative opportunities and inform stakeholder priorities • Maintain structured tracking of relevant threats and produce written assessments and briefings for technical and non-technical audiences • Partner with engineering teams to translate findings into security requirements and hardening priorities • Support operational stakeholders with analysis that informs investigations and related decision-making • Operate as a cross-functional partner across engineering, data, and operational teams, maintaining strong working relationships • Communicate clearly through written outputs and collaborative discussions to drive aligned action • Contribute to repeatable workflows, documentation standards, and quality improvements that increase consistency and reliability • Uphold safe handling expectations for sensitive information, including compliant storage, access, and sharing practices • Contribute to improving the quality and usefulness of security-relevant signals and analytic outputs that support detection and measurement efforts • When appropriate, support technical validation of hypotheses to reduce ambiguity and accelerate remediation, using policy-aligned approaches.

United States
$153K - $166K / year