Data Analytics Specialist - Power BI & KPI Dashboards

Paterson Simons & Co.; Brighton; Hybrid; GBP 32,000 - 38,000; Full time

Benefits offered by this job

Life insurance

Company pension

Cycle to work scheme

Free flu jabs

Company events

Job summary

Paterson Simons & Co. (Africa) Ltd in Brighton is seeking a Data Analyst to shape data-driven decision-making. You will develop KPI frameworks, build Power BI dashboards and analytical tools to improve performance, customer support and growth.

You will work with operational, engineering and commercial teams to deliver insights across CRM/ERP, telematics and operations, helping to optimise asset use, service delivery and revenue opportunities.

Qualifications

• Degree in Data Science, Statistics, Computer Science, or related field is preferred.
• Experience in data analysis or a similar role is advantageous.

Responsibilities

• Design, maintain and improve KPI frameworks for visibility of performance.
• Develop interactive Power BI dashboards for multiple departments.
• Create management reports translating data into actionable recommendations.
• Ensure timely, accurate performance information for stakeholders.
• Analyze operational and service data to identify trends and improvements.
• Leverage telematics and asset data to identify revenue opportunities.
• Support maintenance and asset utilisation strategies through data analysis.
• Maintain Power BI reporting for CRM, telematics and operations.
• Ensure data integrity and consistency of outputs.
• Translate findings for both technical and non-technical audiences.
• Investigate anomalies and provide recommendations.
• Demonstrate experience in Data Analyst/BI roles.
• Advanced expertise in Power BI modelling, DAX, Power Query.
• Experience with data warehousing principles.
• Experience extracting data from ERP, CRM, telematics and others.
• Proficiency in SQL for extraction and analysis.
• Advanced Excel capabilities with Power Query.
• Experience developing automated reporting and data pipelines.
• Strong stakeholder management with senior leadership.
• Ability to manage multiple projects in a fast-paced environment.
• Experience with Microsoft Fabric including dataflows, lakehouse, warehouses.
• Proficiency in Python for data tasks.
• Experience integrating data via REST APIs and external platforms.
• Experience with telematics, IoT and machine-generated data.

Skills

Power BI

SQL

Excel

Python

DAX

Data analysis

Stakeholder management

Project management

REST APIs

ETL/ELT

Education

Degree in Data Science, Statistics, Computer Science, or related field

Tools

Microsoft Fabric

ERP/CRM data sources

Job description

Paterson Simons & Co. (Africa) Ltd in Brighton is seeking a Data Analyst to shape data-driven decision-making. You will develop KPI frameworks, build Power BI dashboards and analytical tools to improve performance, customer support and growth.

You will work with operational, engineering and commercial teams to deliver insights across CRM/ERP, telematics and operations, helping to optimise asset use, service delivery and revenue opportunities.