Analytical Data Engineer

We are seeking an Analytical Data Engineer to join a leading Analytics as a Service (AaaS) provider, supporting clients across energy management, predictive maintenance, HR, and finance. You will transform complex data from multiple sources into actionable insights, creating user-friendly data models and dashboards that empower clients to explore their data independently.

This client-facing role blends data analyst and data engineer skills, including requirement gathering, stakeholder communication, and delivering robust data solutions. Hands-on experience with Power BI, Sisense, Quicksight, and AWS (Sagemaker Unified Studio preferred) is highly desirable.

Offering a competitive salary, performance-based bonuses, and fully flexible remote working, this is a fantastic opportunity to shape and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment.

Analytical Data Engineer Job Overview

Cleanse and transform data sets to create one-to-many star schema models from multiple sources.
Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently.
Proactively search for and review data sources, locating missing data, applying filters, and defining optimal formats for efficient querying.
Collaborate with business analysts to align data models with client processes, ensuring solutions are well maintained and supported.
Validate and test data models, incorporating formulas and business rules to ensure accurate outcomes.
Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs.
Provide technical guidance on data structures from APIs to ensure alignment with star schema models.
Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments.
Work directly with clients during onboarding, running workshops, gathering requirements, clarifying data queries, and communicating deliverables and timelines.
Partner with the data team to deliver, test, and deploy solutions into production. Analytical Data Engineer Job Requirements

Essential

2-5 years' experience in data modelling.
Advanced level in application-based data modelling and ETL.
Strong background in data analysis, cleansing, enrichment, metadata management, and data innovation.
Proficiency in SQL and MySQL.
Experience with business intelligence tools: Power BI, Sisense, Quicksight.
Hands-on experience with ETL tools, ideally Sagemaker Unified Studio.
Ability to validate, test, and build data engineering solutions.
Strong communication skills with ability to translate between technical and non-technical stakeholders. Desirable

2-5 years' client-facing experience, including requirements gathering and stakeholder management.
Ability to embed dashboards and develop client-facing portals.
Familiarity with Python and R.
Experience with AWS Glue (extraction). Analytical Data Engineer Salary & Benefits

Salary: £40,000 - £50,000 (depending on experience)
Working hours: 9am-5pm flexible
Remote working (after onboarding & probation)
Holiday Package: 20 days +8BH
Bonuses based on performance
PensionBennett and Game Recruitment are a multi-disciplined technical recruitment agency based in Chichester, West Sussex operating across the UK with specialist teams covering a range of industries.

We are acting as a Recruitment Agency in relation to this vacancy, and in accordance with GDPR by applying you are granting us consent to process your data, contact you about the services we offer, and submit your CV for the role you have applied for