Data & BI Analyst: Dashboards, Automation & Insights

Broughton Group

United Kingdom

On-site

GBP 40,000 - 55,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

25 days per annum

Salary sacrifice benefits

Death in service (2x)

Job summary

Broughton Group in the United Kingdom is seeking a Data and Business Information Analyst to develop, maintain and enhance reporting, BI and data automation. You will transform data from multiple systems into actionable insights and deliver a single source of truth for decision‑making.

You will design reporting frameworks, automate processes, improve data quality, and build dashboards. The role requires SME knowledge of data management, analytics, and governance, supporting growth with reliable,

Qualifications

Proven experience in a Data Analyst, Business Analyst or similar analytical role.
Advanced SQL skills with experience querying and manipulating large datasets.
Strong experience with Power BI to build dashboards, reports and data visualisation.
Advanced Excel skills including Power Query, Pivot Tables and complex formulas.
Experience in data modelling, data transformation and reporting automation.
Strong analytical and problem-solving abilities.
Ability to interpret complex information and communicate findings effectively to a non-technical audience.
Excellent attention to detail and commitment to data accuracy.
Experience working with CRM, ERP or Laboratory Information Systems (LIMS).
Knowledge of Power Automate or other workflow automation tools.
Understanding of data governance and data quality frameworks.
Experience within a regulated environment such as pharmaceuticals, healthcare or laboratory services.

Responsibilities

Building, maintaining and improving data systems for both internal review and to support client delivery.
Become the SME for data management, reporting and automation.
Continuously improve current systems to strive towards best-in-class data management.
Utilise available systems to produce dashboards and reports across the business
Develop, maintain and improve business reports, dashboards and visualisations using Power BI and other reporting tools.
Build reporting frameworks that provide consistent and accurate business metrics.
Develop automated reporting solutions to reduce or eliminate manual data processing.
Develop and manage datasets that provide a centralised and trusted source of business information.
Integrate and consolidate data from multiple systems and databases.
Monitor data quality, accuracy and integrity across reporting platforms.
Establish data standards, validation rules and governance processes.
Collaborate with stakeholders to identify reporting requirements and translate business needs into technical solutions.
Identify opportunities to automate manual reporting and administrative processes
Design and implement automated workflows to improve efficiency, reduce errors and save time.
Continuously review and optimise existing reporting solutions and data processes.
Develop, maintain and optimise SQL queries, scripts and databases.
Integrate data from multiple sources to create meaningful business insights.
Support the implementation of continuous improvement of data systems and reporting platforms
Work with internal teams and external providers to resolve data and reporting issues.
Promote data-driven culture by helping colleagues understand and utilise business information effectively.
Recommend improvements to systems, reporting and analytical methods.
Stay informed of emerging technologies and best practices in analytics, reporting and business intelligence.
Other tasks as required.