Data Quality Analyst – SQL, Metadata and Data Cataloguing
Job Description
Hybrid Working - London/Home
To drive and deliver the operational management of ‘assured data’ across the organisation, by progressing data quality improvements/controls and the Group Data Catalogue content and ownership, to ensure analytics, insights and decisions are based on validated data.
The role will involve working across multiple teams, a mix of systems with a range of tools and technologies.
What you need to do
- Manage the day-to-day operational management of the Group Data Catalogue, and fully exploit the features of the Catalogue, appreciating the technical set up and landscape.
- Improve the data quality within the organisation through profiling and rule implementation, whilst being able to measure improvements in quality and identify the value that delivers
- Develop and implement data quality triage processes to address quality issues, providing proposals for prioritisation by supplying impact statements and supporting key performance indicators
- Create and implement data catalogue processes to allow users to work with data and artefacts in a standard approach as well as supporting rapid discovery, prototyping and data science, which can subsequently be turned into production solutions
- Manage the day-to-day operational management of the Group Data Catalogue, and fully exploit the features of the Catalogue.
- Identify appropriate artefacts for ingestion and ensure these are communicated, understood and used by the Data Community
- Maintain the Group Data Catalogue up to date and removing unused/dormant/outdated articles and data sources. any instances of non-compliance are quickly and properly addressed
- Ensure familiarisation with the Data Catalogue software supplier(s), reviewing and recommending usage of functionality available within the latest versions ensuring you are always conversant with the latest versions,
- Facilitate source system data quality remediation, working with the relevant owners and subject matter experts to drive through necessary actions
- Coordinate with the data ownership and stewardship community to drive appropriate data quality improvements, by surfacing this through a data cataloguing capability.
- Prioritise work (3 to 6 months forward planning) , manage time effectively and complete tasks within agreed timeframes
- Identify, undertake root cause analysis, addressing real and perceived issues with data quality providing appropriate recommendations
What you need to know and show
Mandatory Skills:
- Advanced SQL skills
- Strong knowledge of the tools, technologies, skills and processes required to deliver a great data quality capability
- Well versed and able to demonstrate the concepts of metadata, stewardship, ownership, cataloguing and data quality
- Experienced with working with or being the consumer of a Data Cataloguing capability, such as Alation, Collibra or other
Desirable Skills:
- GitHub working knowledge
- Previous experience of creating reporting and visualisations, using Tableau, Microstrategy, Power BI or other
- Awareness of Data Vault Modelling
- Understanding of design and development of data stores, digital solutions and data warehouses and associated toolsets.
- Data and information management lifecycles
- Knowledge and use of data quality methodologies, approaches, and processes
- Degree in a Mathematics and/or a Science discipline
- How to undertake triage, root cause analysis and resolution- Desirable
- Understanding of JIRA- Desirable
- Understanding of Agile principles- Desirable
Skills and Behaviours
- Own it - takes full accountability for data quality issues through to resolution.
- Make it better - identifies opportunities to improve data availability that is trusted.
- Be human – Engaging with Senior Engineers and Architects to create standardised processes; builds great working relationships with colleagues (technical and non-technical) and shows care and respect to everyone.
How we work
We work flexibly at Sainsburys. This is a full-time role (37 hours/week), but for the right candidate, we are happy to flex the time commitment. We can also offer a full flexibility around when you work, allowing you to fit your working hours around your life.
We are proud supporters of Women in Data®. Connect, engage and belong to the largest free female data community in the UK – visit: www.womenindata.co.uk to join our community.
APPLY HERE: Data Quality Analyst - SQL, Metadata and Data Cataloguing