Data and BI Analyst

The Data and Business Information Analyst is responsible for developing, maintaining and enhancing Broughton’s reporting, business intelligence and data automation capabilities. The role will transform data from multiple business systems into accurate, actionable insights, automate reporting processes, delivering a ‘single source of truth’ approach to reporting and decision‑making.

Working closely with stakeholders across all functions, the Data and Business Information Analyst will design and maintain reporting frameworks, automate manual processes, improve data quality, and develop dashboards that provide meaningful business intelligence. The role will act as a subject matter expert for data management, reporting systems and analytics, supporting Broughton’s continued growth through reliable, accessible and well‑governed data.

Responsibilities / Objectives

• 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

The tasks for this role are expected to flex over time as data management principles are established and we adapt our ways of working.

Reporting and Business Intelligence

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

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 with in a regulated environment such as pharmaceuticals, healthcare or laboratory services.

Option of a fixed day off every 2 or 3 weeks through salary sacrifice (full time only)

25 days per annum

Option to purchase up to 1 week’s additional holiday through salary sacrifice

Up to £1,200 based on company and personal performance.

2 x salary death in service

Cash plan health care cover