Data Quality Analyst / Metadata - Advanced SQL skills - 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
1. 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.
2. 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
3. Develop and implement data quality triage processes to address quality issues, providing proposals for prioritisation by supplying impact statements and supporting key performance indicators
4. 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
5. Manage the day-to-day operational management of the Group Data Catalogue, and fully exploit the features of the Catalogue.
6. Identify appropriate artefacts for ingestion and ensure these are communicated, understood and used by the Data Community
7. 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
8. 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,
9. Facilitate source system data quality remediation, working with the relevant owners and subject matter experts to drive through necessary actions
10. Coordinate with the data ownership and stewardship community to drive appropriate data quality improvements, by surfacing this through a data cataloguing capability.
11. Prioritise work (3 to 6 months forward planning), manage time effectively and complete tasks within agreed timeframes
12. 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:
13. Advanced SQL skills
14. Strong knowledge of the tools, technologies, skills and processes required to deliver a great data quality capability
15. Well versed and able to demonstrate the concepts of metadata, stewardship, ownership, cataloguing and data quality
16. Experienced with working with or being the consumer of a Data Cataloguing capability, such as Alation, Collibra or other
Desirable Skills:
17. GitHub working knowledge
18. Previous experience of creating reporting and visualisations, using Tableau, Microstrategy, Power BI or other
19. Awareness of Data Vault Modelling
20. Understanding of design and development of data stores, digital solutions and data warehouses and associated toolsets.
21. Data and information management lifecycles
22. Knowledge and use of data quality methodologies, approaches, and processes
23. Degree in a Mathematics and/or a Science discipline
24. How to undertake triage, root cause analysis and resolution- Desirable
25. Understanding of JIRA- Desirable
26. Understanding of Agile principles- Desirable
Skills and Behaviours
27. Own it - takes full accountability for data quality issues through to resolution.
28. Make it better - identifies opportunities to improve data availability that is trusted.
29. 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.
We’d all like amazing work to do, and real work-life balance. That’s waiting for you at Sainsbury’s. Think about the scale it takes for us to feed the nation. The level of data, transactions and variety it involves. Then you’ll realise that ours is a modern software engineering environment because it has to be. We’ve made serious investment into a Tech Academy and into setting standards and principles. We iterate, learn, experiment and push ways of working such as Agile, Scrum and XP. So you can look forward to awesome opportunities in everything from AI to reusable tech.
We are committed to being a truly inclusive retailer, so you’ll be welcomed whoever you are and wherever you work. Around here, there’s always the chance to try something new - whether that’s as part of an evolving team or somewhere else across the business - and we take development seriously and promise to support you. We also recognise and celebrate colleagues when they go the extra mile and, where possible, offer flexible working. When you join our team, we’ll also offer you an amazing range of benefits. Here are some of them:
Starting off with colleague discount, you'll be able to get 10% off at Sainsbury's, Argos, TU and Habitat after 4 weeks. This increases to 15% off at Sainsbury’s every Friday and Saturday and 15% off at Argos every pay day. We've also got you covered for your future with our pensions scheme and life cover. You'll also be able to share in our success as you may be eligible for a performance-related bonus of up to 10% of salary, depending on how we perform.
Your wellbeing is important to us too. You'll receive an annual holiday allowance, and you can buy additional holiday. We also offer other benefits that will help your money go further such as season ticket loans, cycle to work scheme, health cash plans, pay advance (where you can access some of your pay before pay day) as well access to a great range of discounts from hundreds of other retailers. And if you ever need it there is also an employee assistance programme.
Moments that matter are as important to us as they are to you which is why we give up to 26 weeks’ pay for maternity or adoption leave and up to 4 weeks’ pay for paternity leave.
Please see for a range of our benefits (note, length of service and eligibility criteria may apply).