Why choose us?
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.
#LI-Hybrid