Metadata and Quality Analyst & SQL

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

• 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

• 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.
• 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.

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 seewww.sainsburys.jobsfor a range of our benefits (note, length of service and eligibility criteria may apply).

2024-08-27 16:32:39