Data & Process Business Analyst - Power BI, SQL

Wilson Power Solutions Ltd; Leeds; On-site; GBP 42,000 - 65,000; Full time

Benefits offered by this job

25 days holiday per year

Healthcare cash plan

On-site parking with EV chargers

EV salary sacrifice scheme

Job summary

Wilson Power Solutions Ltd is seeking a Data Business Analyst to bridge business processes, data quality, and reporting, sitting between users, leadership and technology teams in the IT transformation program. You will map L1-L3 processes, build dashboards in Power BI, use SQL and Excel, and help adopt D365 and Office 365 across functions at Leeds.

In this hybrid role you will collaborate with stakeholders across departments and locations to turn operational data into actionable insights for

Qualifications

• Experience in a Business Analyst, Data Analyst, or hybrid business systems and reporting role.
• Strong process mapping and documentation capability, including L1 to L3 process modelling.
• Strong Power BI capability for dashboard and reporting development.
• Good SQL skills, including writing queries to extract, analyse, and validate data.
• Advanced Excel skills, including data manipulation, reconciliation, reporting, and VB/VBA-based automation or improvement work.
• Experience producing MI and dashboard reporting for senior leaders or operational management.
• Working understanding of D365 and Office 365 environments.
• Strong communication skills, with the ability to work across technical and non-technical audiences.
• Desirable: manufacturing or engineering sector experience and exposure to cross-cultural or multi-region working environments.

Responsibilities

• Capture, map, and maintain business processes using tools such as Miro, including L1, L2, and L3 process documentation, procedures, and work instructions.
• Work with departments to identify process gaps, inefficiencies, risks, and improvement opportunities, and document agreed changes clearly and accurately.
• Support the business in using systems correctly and consistently, helping users follow agreed processes and improve data quality across key platforms.
• Use SQL to query and interrogate data from business systems and operational sources to support reporting, analysis, and decision-making.
• Use advanced Excel and VB/VBA capability to manipulate, cleanse, reconcile, and structure data for reporting and process insight.
• Build and maintain Power BI dashboards, reports, and visualisations that provide clear operational and leadership insight.
• Produce regular MI, KPI reporting, and ad hoc analysis for leadership teams, converting raw data into meaningful and actionable information.
• Support understanding and adoption of D365, Office 365, and related business applications by translating requirements, issues, and changes into clear business language.
• Work effectively with stakeholders across functions, levels, and locations, including cross-cultural collaboration where required.
• Support manufacturing and operational teams by developing a practical understanding of business processes across areas such as planning, production, supply chain, and commercial operations.
• Remain open to learning new tools, systems, reporting methods, and process improvement approaches as business needs evolve.

Skills

Business Analysis

Data Analysis

Process Mapping

Power BI

SQL

Excel VBA

MI Reporting

D365/Office 365

Communication Skills

Cross-cultural / Multi-region

Tools

D365

Office 365

Job description

Wilson Power Solutions Ltd is seeking a Data Business Analyst to bridge business processes, data quality, and reporting, sitting between users, leadership and technology teams in the IT transformation program. You will map L1-L3 processes, build dashboards in Power BI, use SQL and Excel, and help adopt D365 and Office 365 across functions at Leeds.

In this hybrid role you will collaborate with stakeholders across departments and locations to turn operational data into actionable insights for