BI and Data Engineering Lead in York, Yorkshire

BI and Data Engineering Lead in York, Yorkshire

York +1 Full-Time 40000 - 45000 £ / year (est.) No home office possible
The Wilf Ward Family Trust

At a Glance

  • Tasks: Lead the design and delivery of automated BI solutions to enhance data-driven decision-making.
  • Company: Join The Wilf Ward Family Trust, a values-driven organisation on a digital transformation journey.
  • Benefits: Competitive salary, travel opportunities, and a chance to make a real impact.
  • Why this job: Be at the forefront of transforming data usage in a supportive environment.
  • Qualifications: Experience with Power BI, data integration, and strong communication skills required.
  • Other info: Opportunity for career growth while promoting inclusion and safeguarding.

The predicted salary is between 40000 - 45000 £ per year.

At The Wilf Ward Family Trust, we are 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 are 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 will 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 will be doing:

  • 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 are looking for:

We are 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 risk.

Please be aware it is 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.

Locations

York Yorkshire

BI and Data Engineering Lead in York, Yorkshire employer: The Wilf Ward Family Trust

At The Wilf Ward Family Trust, we pride ourselves on being an exceptional employer dedicated to fostering a collaborative and inclusive work culture. As a BI and Data Engineering Lead, you will not only have the opportunity to drive meaningful change through innovative data solutions but also benefit from a supportive environment that prioritises employee growth and development. With a focus on values-driven work, our Trust offers a unique chance to make a genuine impact while enjoying the flexibility of working across various Trust sites.
The Wilf Ward Family Trust

Contact Detail:

The Wilf Ward Family Trust Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land BI and Data Engineering Lead in York, Yorkshire

✨Network Like a Pro

Get out there and connect with people in the industry! Attend meetups, webinars, or even local events related to BI and data engineering. You never know who might have a lead on your dream job!

✨Show Off Your Skills

Create a portfolio showcasing your BI solutions and dashboards. Use platforms like GitHub or personal websites to display your work. This gives potential employers a taste of what you can do and sets you apart from the crowd.

✨Ace the Interview

Prepare for interviews by practising common questions and scenarios related to BI and data engineering. Be ready to discuss your past projects and how you've tackled challenges. Confidence is key, so show them you mean business!

✨Apply Through Our Website

Don't forget to apply directly through our website! It not only streamlines the process but also shows your genuine interest in joining The Wilf Ward Family Trust. Plus, we love seeing candidates who take that extra step!

We think you need these skills to ace BI and Data Engineering Lead in York, Yorkshire

Power BI
Data Modelling
DAX
Dashboard Design
API Integration
Excel
CSV
JSON
Data Quality Improvement
Data Governance
Technical Documentation
User Guidance
Microsoft 365 Tools
Python
R

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the BI and Data Engineering Lead role. Highlight your experience with Power BI, data modelling, and any relevant projects that showcase your skills in building automated reporting solutions.

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data and how your skills align with our mission at The Wilf Ward Family Trust. Don’t forget to mention your collaborative mindset and problem-solving abilities!

Showcase Your Technical Skills: Be specific about your technical skills in your application. Mention your experience with APIs, Excel, and any modern data platforms you’ve worked with. This will help us see how you can contribute to our digital transformation journey.

Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from us!

How to prepare for a job interview at The Wilf Ward Family Trust

✨Know Your BI Tools Inside Out

Make sure you’re well-versed in Power BI, especially in data modelling and DAX. Prepare to discuss specific projects where you've built dashboards or reporting solutions, as this will show your hands-on experience and technical capability.

✨Showcase Your Data Integration Skills

Be ready to talk about how you've integrated data from various sources like APIs, Excel, and JSON. Bring examples of challenges you faced and how you overcame them, as this demonstrates your problem-solving skills and understanding of data quality issues.

✨Communicate Clearly and Effectively

Since you'll be working with non-technical audiences, practice explaining complex concepts in simple terms. Think of ways to illustrate your points, perhaps through past experiences where you successfully trained others or documented processes.

✨Emphasise Your Collaborative Mindset

The role requires a team player who can work independently but also engage with others. Share examples of how you've collaborated on projects or contributed to a data-driven culture in previous roles, highlighting your ability to champion best practices.

BI and Data Engineering Lead in York, Yorkshire
The Wilf Ward Family Trust
Location: York

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>