BI and Data Engineering Lead

BI and Data Engineering Lead
Salary: 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 were 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.
Were 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. Youll 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 youll 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 were looking for
Were 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 sites

Desirable:

• 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 environment

We 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 be aware its 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 visitCheck if you need to tell someone about your criminal record: When you need to tell someone about your criminal record

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.