Data and BI Analyst

Broughton Group; United Kingdom; On-site; GBP 40,000 - 55,000; Full time

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.

Skills

Advanced SQL

Power BI

Excel (Power Query/Pivot)

Data modelling

Data transformation

Power Automate

Data governance

CRM/ERP/LIMS experience

Analytical thinking

Job description

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

Key tasks

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.

Data Management and Governance

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

Automation

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

Database and Systems Development

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

Continuous Improvement

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

Qualifications and Education Requirements

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.

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