Job Description:

Trainee Data Analyst

Smart Metering Programme

Location: Brentwood, Essex

Position Type: Permanent, Full-Time (Monday to Friday, 08:00–17:00)

Role Overview

The Trainee Data Analyst will support the Data & Performance team in collecting, analysing, and maintaining data for the Smart Metering Programme across the region. This role is designed for someone early in their data career, offering structured learning and hands-on experience with operational, commercial, and compliance data.

Working closely with operational teams, compliance, planning, and commercial, the Trainee Data Analyst will help ensure accurate reporting, support performance tracking, improve data quality, and contribute to key insights that drive programme delivery.

Data Management & Quality

• Assist in collecting and validating data from field teams, subcontractors, and internal systems.
• Maintain accurate records relating to meter installations, replacements, aborts, and exceptions.
• Support reconciliation of operational data to ensure alignment with planning, commercial reporting, and client requirements.
• Identify data inconsistencies and work with relevant teams to resolve issues promptly.

Reporting & Performance Tracking

• Support the preparation of daily, weekly, and monthly KPI reports.
• Assist in building dashboards and visuals using Excel and/or Power BI.
• Monitor programme trends such as productivity, success rates, compliance, and turnaround times.
• Help prepare information for internal reviews, client meetings, and commercial submissions.

Systems & Digital Tools

• Work with internal systems, apps, and databases used across the Smart Metering Programme.
• Develop skills in data extraction.
• Assist with process improvements and automation of routine reporting tasks where possible.

Compliance & Operational Support

• Collaborate with Compliance teams to ensure all job records, photos, and evidence are captured and auditable.
• Support in analysing failed jobs, exceptions, and non-compliance trends.
• Work with operational teams to ensure accurate data is captured at source.

Stakeholder & Team Collaboration

• Engage with Delivery Managers, Supervisors, Planners, and Subcontractors regarding data accuracy.
• Support internal teams with ad hoc data requests or analysis tasks.
• Contribute to team meetings, sharing findings or insights when required.

Personal Attributes

• Strong attention to detail with a methodical and accurate approach.
• Enthusiastic, eager to learn, and motivated to build a career in data.
• Confident communicator, able to engage with both field and office-based teams.
• Proactive, with a willingness to investigate issues and suggest solutions.
• Able to organise and prioritise tasks effectively.
• Positive attitude and a collaborative team player.

Essential Requirements

• Good working knowledge of Microsoft Excel (basic formulas essential; advanced skills beneficial).
• Strong numerical and analytical mindset.
• Willingness to undertake training in SQL, Power BI, and other analytical tools.
• Comfortable working with technology, digital systems, and datasets.
• Full UK driving license.

Key Relationships

Works closely with: Compliance Team, Planning Team, Delivery Teams, Commercial, and Subcontractor Partners