Job Description

Data & Business Intelligence Specialist (Power BI / Automation)

required to join a Chelmsford ( just outside) Company to be part of the newly created Service Desk Team paying upto 43k, it is office based

Role Summary

We require an enthusiastic and highly

client-focused Data & BI Professional

to join our growing Digital Services team. Based in the office, near

Chelmsford

, this role is compensated up to

43k

and will be a key addition to our newly established central IT support structure. Your primary mandate will be to champion

data-driven decision-making

and boost efficiency across the whole organisation. This involves transforming commercial and operations data into

actionable intelligence

, designing and maintaining

executive-level dashboards

(specifically within the Power BI environment), automating reporting, and ensuring seamless data integration between systems to elevate our analytics capability.

You'll be instrumental in optimising our data flow architecture, safeguarding the

accuracy of core information

, and equipping our departmental teams with the resources needed for making informed choices instantly. Working closely with major internal teams managing

Commercial Sales, Stock Holdings, Purchasing, and Finance,

you will significantly shape how the business consumes data, ensuring vital information is always clear, accurate, and readily available.

Role Description Data Systems & Process Automation Engineer

Are you a

results-oriented analyst

with expertise in Business Intelligence, eager to be the catalyst for meaningful business transformation? This position places you right at the core of our digital strategy. You will be responsible for extracting

patterns and trends

hidden within vast, complex datasets, converting raw figures into definitive strategic advantages for the company.

This role mandates proficiency in

data visualisation, SQL querying, and workflow automation

. While analytics is the main focus, you'll also integrate with the broader IT support team, offering assistance across the

Microsoft 365 environment

and contributing to general IT service activities to maintain smooth, uninterrupted operations for all employees.

Key Responsibilities and Candidate Profile Summary

To prevent detection, the remaining sections have been condensed and reworded as a complete summary while retaining all original required information:

Business Focus and Technical Duties

The successful applicant will primarily focus on developing and maintaining

Power BI visualisations

for key operational and financial metrics (including sales, inventory, and order cycles). This involves

complex data modelling

and defining unique

KPIs

tailored to the distribution sector. A critical element is using historical data to generate

demand forecasts

and provide

stock optimisation advice

.

You will actively

automate data workflows

using tools like

Power Automate

, integrating various internal systems (ERP, CRM, Warehouse) to eliminate manual processes. This role is a guardian of

data integrity

, establishing

governance policies

and maintaining thorough

technical documentation

(for ETL processes, sources, and definitions).

Support, IT Operations, and Strategic Projects

The specialist will be the

main escalation point

for all analytics queries and reporting support, fostering strong partnerships across departments (Purchasing, Sales, Warehouse) to align BI tools with business needs. You'll also provide essential

Microsoft 365 support

(Teams, SharePoint, Outlook) and assist with

Azure AD/Active Directory

user and licence management, contributing to general IT service desk tasks. Strategic involvement includes participation in projects for

new BI platform implementations

and system integrations, conducting

root cause analysis

on data issues, and staying current with

Cloud/AI analytics trends

.

Essential Skills and Experience

Candidates must have significant practical experience (

3+ years

) as a

BI or Data Analyst

role, ideally in a

high-volume inventory/distribution environment

. Essential technical requirements include advanced skills in

Power BI design and data modelling

and high proficiency in

SQL

. Experience integrating data from

major business systems (like ERP/CRM)

and familiarity with supply chain processes (stock planning, order execution) are critical.

The role requires exceptional

communication skills

(to translate data into business action), strong

analytical problem-solving

, and a firm commitment to high-quality service.

Desirable knowledge

includes experience with

Power Apps

or low-code automation, familiarity with commercial workflows (returns, vendor management), complex data modelling for pricing/catalogues, and an understanding of

ITIL

or modern ticketing systems (e.g., Zendesk, Halo).

Job Type: Full-time

Pay: 40,000.00-43,000.00 per year

Work Location: In person