BI and Data Engineering Lead

Acomb, City of York
4 days ago
Create job alert

BI and Data Engineering Lead
Salary: £40,000–£45,000 per annum
Reporting to: Digital Delivery Manager
Location: Trust sites (with travel required)
Organisation: The Wilf Ward Family Trust

At The Wilf Ward Family Trust, we're on an ambitious digital transformation journey. A key part of this is changing how we use data — moving away from manual, spreadsheet-based reporting to modern, automated, and trusted
business intelligence.
We're looking for a BI and Data Engineering Lead to establish and lead our central reporting capability. This is a unique opportunity to assist in making a genuine impact in a values-driven organisation. You'll design and deliver robust BI solutions, integrate data from multiple systems, and create intuitive dashboards that help colleagues across the Trust make better, data-informed decisions — ultimately supporting our mission of enabling extraordinary lives through outstanding support.

What you'll be doing
As our BI and Data Engineering Lead, you will:

Design, build, and maintain cost effective, automated reporting solutions.
Develop data models integrating multiple data sources including data from APIs, Excel, CSV, and JSON.
Work with the organisation to identify data quality issues and improve quality, integrity, and consistency of data.
Establish and document data flows, reporting processes, and technical solutions.
Champion a data-driven culture and promote best practice in reporting and analysis.
Contribute to data governance, standards, and the development of a trusted 'single source of truth'.What we're looking for
We're looking for a specialist who combines strong technical capability with a collaborative and curious mindset.

Essential experience and skills:

Proven experience building BI solutions using Power BI, including data modelling, DAX, and dashboards
Understanding of dimensional data modelling
Experience integrating data from multiple sources (APIs, Excel, CSV, JSON)
Ability to translate business needs into effective technical solutions
Strong data analysis and problem-solving skills
Experience designing user-friendly dashboards for non-technical audiences
Ability to work independently and manage your own priorities
Excellent communication skills — able to explain technical concepts clearly
Experience documenting data processes and delivering user guidance or training
Confidence using Microsoft 365 tools including SharePoint, Teams, and OneDrive
Full UK driving licence and willingness to travel between Trust sitesDesirable:

Knowledge of data governance and data quality frameworks
Familiarity with modern data platforms (e.g., Microsoft Fabric, Data Factory, Databricks)
Experience supporting digital transformation initiatives
Experience with Python or R for data analysis or transformation
Experience building deployment pipelines in Microsoft 365 environmentWe recognise the importance of recruiting skilled, compassionate, and reliable staff, whilst demonstrating in practice our commitment to inclusion, safeguarding and promoting the welfare of adults at risk. Please be aware it's a criminal offence for people who are barred from working in Regulated Activity (under the Safeguarding and Vulnerable Groups Act 2006) to apply for roles that require them to work unsupervised with that particular group such as adults or children. Please note any successful job offer will be conditional based on pre-employment checks such as DBS and referencing prior to a start date agreed. The Wilf Ward Family Trust has a clear commitment to safeguarding within all practices, for more information on criminal discloses you can visit

Founded in 1986, The Wilf Ward Family Trust is dedicated to enhancing the lives of individuals with disabilities. We empower them to lead fulfilling lives and embrace innovation to stay at the forefront of social care. Join us on our journey towards equality and a brighter future. Welcome to the Wilf Ward Family Trust

Related Jobs

View all jobs

Lead Data Engineering Consultant CGEMJP00330718

CGEMJP00330718 Lead Data Engineer

Lead Data Engineer - Hadoop - Spark - Python

Lead Data Engineer

Lead Data Engineer

Azure Data Engineer

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.

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.

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.

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.