Analytical Data Engineer

City of Westminster
7 months ago
Applications closed

Related Jobs

View all jobs

Senior Data Engineer

Data Engineer

Senior Data Engineer

Data Engineer (Automation)

BIM DATA Engineer

AWS Data Engineer (contract)

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

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Jobs

New Data Engineering Employers to Watch in 2026: UK and Global Companies Driving the Data Revolution

Data engineering is at the heart of the digital economy, transforming raw data into actionable insights, powering analytics, AI systems, and cloud infrastructure. As the UK and global markets continue to invest heavily in data platforms, pipelines, and real-time analytics, demand for skilled data engineers is growing rapidly. For professionals exploring opportunities on www.DataEngineeringJobs.co.uk , the critical question is: which companies are expanding, hiring, and shaping the future of data-driven business? This article highlights new data engineering employers to watch in 2026, including UK startups, scale-ups, and international firms expanding in the UK.

Careers

How Many Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

Jobs

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.