[Hiring] Senior Analytics Engineer @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) to advance self-serve analytics.
• 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 and experience with AI and automation tools.

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