About us
SMS Plc are amongst the leaders in the smart energy revolution, fitting over a million properties with smart meters and counting. We have been at the heart of the UK energy market for over two decades and are playing a critical role in transforming and decarbonising the UK energy system. Being a real living wage employer, we look out for our customers and our focus is ‘putting our people first’. We have 5 core values that our employees live and breathe which are: safety, customer excellence, sustainability, innovation and pride.
The role
Within the Data division, you will be responsible for the collation, analysis and reporting of data in SQL Reporting, for and on behalf of internal staff and management.
The role includes identifying gaps, communicating improvement programs and implementing cleansing mechanisms. The results of this will feed in to process improvement plans.
You may also be required to perform internal & external presentations, and liaise with software developers & end-users, whilst identifying and resolving current & historic data issues.
Typical Duties
- Creation and development of reports
- Gathering data from multiple systems and automating reports
- Analysing data for gaps and anomalies and creating cleansing regimes
- Working with key staff members to understand the reporting requirements
- Working with IT as required to understand database structures and working on process improvements
- Any other duties required by the Management team
Skills
- Proficient in Microsoft Office package
- Use of SQL queries to analyse and report on data
- Advanced user of Microsoft Office Excel
- Use of Cognos reporting system
- Ability to organise and prioritise deadlines
- Excellent written and verbal communication with all levels of staff
- Excellent problem solving skills
- Developing and maintaining business reports
- Attention to detail
In return we offer our employees -
- 28 days holiday (including bank holidays) as of 1st January 2020, standard holiday entitlement will increase to 25 personal days per year, with an additional allocation of 8 public holidays
- After 5 years of service you will be rewarded with an additional 5 days annual leave taking it to 30 personal days and 8 public holidays.
- Refer a friend bonus (£500)
- Cycle to work scheme
- Corporate season ticket travel
- Automatic enrolment into the Company Stakeholder Pension Scheme (will commence following 3 months employment)
- Eligibility to join the Share Incentive Plan following 6 months employment
- We also have you covered with Life Insurance where your next of kin will receive 4 times your annual salary