data analyst Colchester, England
Job description
Reference Number 77289
This Data Quality Data Analyst will report to the Asset Systems Manager and will work within the Asset Management directorate based in our Colchester office. You will be a permanent employee..
You will attract a salary of £48,326.00 and a bonus of 3%
Close Date: 31/07/2023 .
All applications will be reviewed after the close date.
We also provide the following additional benefits
Annual Leave
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
Tax efficient benefits: cycle to work scheme
Season ticket loan
Occupational Health support
Switched On – scheme providing discount on hundreds of retailers products.
Supplier discounts, such as O2, EE, Vauxhall cars, Universal tyres
Discounted access to sports and social clubs
Employee Assistance Programme.
JOB PURPOSE:
You will be responsible for analysing and improving the Data Quality, across a range of data sets which the Asset Systems Data Quality reports monitor. Data extraction, analysis and updating of records form the central function of the role. This will include collaborating with other departments to ensure data across systems is aligned.
PRINCIPAL ACCOUNTABILITIES:
Review Data Quality reports / dashboards to implement opportunities for improvement.
Use engineering knowledge to improve data quality, both completeness and accuracy.
Data extraction and manipulation using advanced Sequel Query Language (SQL) / Visual Basic Techniques.
Maintain the data quality and integrity by auditing, process, and use of data manipulation and modelling techniques.
Undertake data cleansing exercises to improve data quality.
Develop the business processes and associated documentation for management of issues identified in the Data Quality reports.
Communicate with asset engineers and other business system owners to establish rules and extract data held in other systems to inform and address data quality issues.
Contribute to the continued development of the data quality activities and the future development of the associated rules, logic, reports and dashboards.
Maintain the Data Quality Issue Log with a commentary of investigation findings and the action required / taken.
Support and deputise for the Senior Asset Systems Analysts.
Represent UK Power Networks during external audits for matters relating to asset information and associated process compliance.
Identify and guide the implementation of control measures which prevent / limit the input of poor-quality data.
NATURE AND SCOPE:
The role of the Data Quality Data Analyst is of strategic importance within the Asset Management directorate and reports to the Assets Systems Manager.
Whilst Data Quality analysis is focused predominantly on the data in SAP Plant Maintenance it is expected that this will evolve to other data sources within the company. There are over 3 million equipment records in SAP PM, each of which have numerous data points, against which data quality is assessed. Complete and accurate data is important to UKPN to make informed decisions and provide accurate reporting. This reduces our risk and builds confidence for all parties utilising the data.
You will identify and analyse data quality issues. This will involve consultation to identify solutions and the actual update of the records and implementation of appropriate control measure to eliminate / reduce future occurrences.
SKILLS, QUALIFICATIONS AND EXPEREINCE:
Degree level or equivalent experience in engineering, science, or numerical subject
Previous experience analysing data, developing improvement plans and communicating the output.
Experience of complex data extraction and manipulation using SQL.
Knowledge of SAP Plant Maintenance to include the bulk uploading of data.
Comprehensive knowledge of UK Power Networks network data assets and asset management activities.
Question people and tease out relevant information.
Excellent analytical and numerical skills.
Experience analysing and reporting on complex datasets.
Advanced MS Excel Skills and accomplished in the production and editing of spreadsheets and their manipulation.
Advanced IT skills in the Microsoft Office suite – particularly in SQL MS Access and Visual Basic.
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 fully 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 particularly 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, color, 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.
