Regulatory Data Analyst

80649 - Regulatory Data Analyst

This Regulatory Data Analyst will report to the Asset Information Regulatory Reporting Manager and will work within the Information Systems directorate based in either our London, Crawley, Colchester or Bury St Edmunds office. You will be a permanent employee.

You will attract a salary of £61,723.00 and a bonus of 3%. This role can also offer blended working after probationary period (6 months) - 3 days in the office and 2 remote

Close Date: 13/04/2025.

We also provide the following additional benefits

• 25 Days Annual Leave plus bank holidays. 
• Reservist Leave – Additional 18 days full pay and 22 unpaid
• Personal Pension Plan – Personal contribution rates of 4% or 5% (UK Power Networks will make a corresponding contribution of 8% or 10%)
• Tenancy Loan Deposit Scheme, Season Ticket Loan
• Tax efficient benefits: Cycle to Work, Home & Tech, and Green Car Leasing Schemes
• Occupational Health support
• Switched On – scheme providing discount on hundreds of retailers’ products
• Discounted gym membership
• Employee Assistance Programme

Job Purpose:

Working within the Asset Information team you will be responsible for monitoring and tracking compliance of the asset replacement and refurbishment programme and Regulatory Output measures (Health Indices and Criticality Indices), including management reporting.

Also, you will support Asset Engineers and the Senior Data and Performance Analysts in analysing and improving data quality.

Dimensions:

This role has no financial or line management responsibility.

Principal Accountabilities:

• Monitor and tracking compliance of the Health and Criticality Indices Regulatory Output measures
• Responsible for reporting on, and maintaining, data quality associated with the Health and Criticality Indices and for creating forecasted Output Measures to model proposed investment scenarios.
• Undertake investigation and resolution of data quality and system issues
• Responsible for collation, production and assurance of the NARM information and commentary for defined asset categories
• Support the development and testing of CBRM models, including liaison with third parties for data exchange, input and quality issues
• Manage the needs and expectations of important partners whilst balancing these with the requirements of reporting to the Regulatory and the associated License Conditions
• Help communication between engineering and IT specialists, ensuring our needs are met whilst explaining the technology constraints to partners
• Help develop strategic risk models
• Data extraction, cleansing and manipulation using advanced SQL / Visual Basic techniques.
• Develop processes for the data extraction, transformation and loading of data into the CNAIM models. This includes data quality assurance at all stages of the process.

Qualifications:

• Degree level or equivalent experience in engineering, science or numerical subject
• Knowledge of UK Power Networks network assets
• Experience with data integration services. E.g ETL.
• Experience in building data pipelines using SQL Server Integration Services (SSIS).
• Understanding of relational databases, their structures and system administration of them
• Asset management / data management / data auditing skills
• Advanced IT skills in the Microsoft Office/ PowerPlatform suite – particularly in SQL, MS Access, Visual Studios and PowerBi.
• Gather requirements, convert them to specifications and develop solutions to customer needs and challenges and Identify opportunities for continuous improvement.
• Previous experience analysing performance, developing improvement plans and communicating the output
• Be able to structure problems or requirements in a deadline driven environment and produce well-reasoned and evidenced solutions.
• Manage partners at all levels
• Experience with strategic risk models
• Familiarity with Azure Cloud platform is desirable.

Should you not have the full range of essential skills, qualifications and competencies listed above, there may be an opportunity for further training to equip you. If you do not have all relevant competencies for the core grade, it will be appropriate to appoint at a lower grade until they have developed the required competencies.

Nature and Scope

The AI Regulatory Reporting team is responsible for the completion of UK Power Networks' RIIO-ED2 regulatory asset volume, achievement (RIGs) and Network Asset Risk Metrick (NARMs). The team is also responsible for maintaining a suite of leading asset modelling capabilities and assessing the condition, health, criticality and risk of electrical and civil assets (CNAIM). This informs our investment programmes to ensure asset health indices and criticality indices are maintained within regulatory targets.

Reporting the to AI Regulatory Reporting Manager, the Data and Performance Analyst fulfils a critical role in ensuring that UK Power Networks is both compliant with all aspects of Regulatory Reporting associated with HIs and CIs and is achieving its goals concerning delivery of the required outputs from the programme of work.

Health & Safety Responsibilities

Managers and supervisors carry both legal and company responsibilities for ensuring the health and safety of their employees, those under their control and those who might be affected by the work undertaken, i.e. public, visitors and employees of other organisations. This includes briefing individuals working for them and ensuring there is the necessary understanding, competence and application of requirements to work safely and without harming the environment.

Employees will ensure they understand the health and safety risks involved in their work activities and their responsibility to apply the controls needed to manage those risks to acceptable levels. Similarly where work activities can have an adverse impact upon the environment, and where there are legal requirements, employees will understand those impacts and the controls they must ensure are applied.

If in doubt ask!

We are committed to equal employment opportunity regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

If you have any queries in connection to this vacancy or your application, please contact us at careers@ukpowernetworks.co.uk quoting the vacancy reference number and a member of the team will get in touch with you as soon as possible.