Severn Trent Water

Role Objective:

The main objective of the Information Production Team is to transform data into valuable information, by producing quality, easy to use, predominantly Microsoft Office based outputs that enable users to understand and interpret the information contained, and take action to drive business change. This project role is to support the team in reviewing and updating their existing reporting outputs and redesigning these to build into a new workflow management system (Microsoft Dynamics)

Key Accountabilities:

- Working to a prioritised list, review and understand existing reporting processes and protocols. - Assess these reporting processes in line with current business practice to identify potential conflicts. - Develop and design reporting process changes to ensure reports are stable and fit for purpose. - Working with colleagues, seek to streamline and systemise reporting processes using VBA and SQL coding to automate where appropriate. - Work with colleagues to standardise reporting outputs across business. - Create standard output designs that are intuitive, fit for purpose and easy for the user to consume. - Create and update Standard Operating Procedures. - Collaborate with Translation and Report Development teams to reduce the volume of manually produced business information.


Essential: - Substantial experience of transforming data into valuable information. - Significant experience of designing and building reporting solutions. - Experience of understanding and evaluating business data flows. - Experience of working with Business Analyst in creating business information reports from documented business requirements. - Data warehouse / Data mart knowledge in relation to optimising report development Desirable: - Experience / understanding of the Water Industry - Advanced data query tools user.


- High level skills with Microsoft Visual Basics Editor to develop reporting solutions in Excel. - Ability to use SQL programming to interrogate data systems - Passionate about, and motivated to transform data into valuable information that business information users find easy to use and interpret (i.e. they tell the story) - Eye for detail and completeness - An ability to communicate with other team members and colleagues raising questions - The ability to work with Translators and Report Developers to automate reporting, and specify need - Ability to manage own queue of work and deliver to production schedule. - Logical and structured approach

The Role

Using skills in Microsoft Excel and SQL I covered the holiday period, fulfilling a role in BI Production during the absence of one of the senior employees. The reporting covered daily contact centre reporting both inbound and outbound in addition to daily regulatory reporting. - Using skills in Microsft Excel VBA I rewrote and redesigned reporting for water quality BI and for training evaluation for the External Relationships Team. The first using mainly Excel Pivot Tables with Excel VBA and the second exclusively in Excel VBA.