[Hiring] Sales Enablement Lead @Pion

Role Description

As a result of our incredible success and growth, we are looking for a Lead Analytics Engineer to join us.

• Play a key role in the Analytics Engineering function and dbt environment.
• 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.
• Translate business requirements into robust data models and ensure cross-functional teams have reliable data foundations.
• 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).
• Support the development and maintenance of the Semantic Layer and assist in the integration of AI capabilities (e.g., text-to-SQL).
• Actively champion software engineering best practices within the data team.
• Contribute to the development of automations and AI capabilities within the Analytics Engineering function.

Qualifications

• 3+ years of highly technical experience with dbt and SQL.
• Strong hands-on experience with AWS Redshift (or a similar cloud warehouse like Snowflake/BigQuery).
• Familiarity with DAG structures and orchestration tools like Apache Airflow.
• Some experience mentoring or supporting more junior data team members.
• Comfortable partnering with non-technical stakeholders across Product, Commercial, and Ops.
• Solid experience working with the code-first backend of modern BI tools (ideally Lightdash & Count, or similar).
• A genuine interest in engineering efficiency.

Requirements

• Write DRY, optimised code, build macros, manage dbt packages, and troubleshoot performance bottlenecks.
• Solid understanding of query optimisation and warehouse architecture.
• Enjoy sharing knowledge and contributing to a collaborative, inclusive engineering culture.
• Proactively flag data quality or architectural issues and suggest improvements.
• Have a good understanding of Semantic Layer concepts and a keen interest in developing further in this area.
• Experience or strong appetite to build using AI and automation tools, scripting, and workflows.

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 with up to 180 days working from abroad (subject to approval).
• Flexible working hours (start between 8-10am and finish between 4:30-6:30pm).
• Focus on welfare with a monthly wellness allowance, gym memberships, access to mental health first aiders, and a health cash plan.
• Access to incredible partnership discounts for major brands.
• £200 work from home setup allowance.