Data Analyst (MHHS)

Apply now

Overview

Choosing to work for SMS means choosing to make a difference. We are changing how businesses and consumers use energy for the better, helping achieve a greener, sustainable, and more affordable energy system for everyone. Through our range of innovative energy solutions, we are delivering the future of smart energy - working closely with private and public sector partners we are playing a critical role in transforming and decarbonising the UK economy by 2050.

What's in it for you?

• 25 personal holiday days per year (with additional 8 public holidays) increasing to 30 personal days after 5 years of service (includes options to buy and sell)
• Hybrid working options.
• Automatic enrolment onto our Employee Participation Scheme.
• Enhanced Maternity leave. Paternity and Adoption leave.
• 24/7 free and confidential employee assistance service.
• Medicash health plan offers a wide variety of benefits from cashback on everyday healthcare treatments like optical, dental and physio treatments. Discounted gym memberships and free 24/7 online GP.
• Life Insurance (4 x annual salary)
• Pension matching scheme (up to 5% of salary)
• Developing our people is important to us - we support and encourage development by offering internal and external accredited courses, secondments and study support.

Visit Our People page

What’s the role?

SMS are looking for a Data Analyst to join the business at a very exciting and fast-paced time. This role is centred on delivering accurate, timely, and insightful data analysis to support strategic decision-making across the Electric Settlement Services department. You’ll be responsible for designing, developing, and maintaining a suite of recurring and ad hoc reports that provide clear visibility into performance, trends, and business opportunities.

The working hours for this role are Monday to Friday, 8:30-5:00, 40 hours per week. Hybrid working is on offer, consisting of 2 days in office and 3 days at home.

Key Responsibilities

• Locate, examine, clean, and analyse large datasets related to the SMS and out customer's portfolios.
• Support data quality assurance processes to ensure compliance with industry regulations and standards.
• Support regulatory and compliance audits by providing required data extracts and analyses.
• Deliver a mix of BAU reporting, project-based analysis, and one-off data requests with a high level of accuracy and reliability for internal teams and external stakeholders.
• Develop, enhance, and maintain interactive dashboards and reports using Power BI to support day-to-day operations and strategic initiatives.
• Working with internal stakeholders to gather requirements and develop reporting.
• Take ownership of recurring reporting processes, ensuring timely distribution and continuous improvement of reporting workflows.
• Identify opportunities to streamline and automate data processes to improve efficiency and reduce manual effort.
• Maintain clear documentation of reporting logic, data sources, and processes to ensure transparency and continuity.
• Collaborate across departments to ensure consistent use of data and reporting standards.

To be considered for this role, we would love you to have/be:

• Demonstratable experience as a Data Analyst or experience in a similar role.
• Energy industry knowledge and a degree in a STEM subject.
• Advanced Excel skills including PivotTables, VLOOKUP/XLOOKUP, Power Query, and macros.
• Strong proficiency in data manipulation tools and languages such as Python or similar.
• Experience with data visualisation tools like Power BI, Tableau, or equivalent.
• Strong analytical, problem-solving, and critical thinking skills.
• Excellent organisational skills and a methodical, logical approach to work.
• Ability to manage multiple projects and deadlines simultaneously.
• Excellent written and verbal communication skills.
• Understanding of data warehousing concepts and data governance.