Data Architect

Sainsbury's; Greater London; Hybrid; GBP 90,000 - 130,000; Full time

Benefits offered by this job

Colleague discounts

Pensions and life cover

Performance-related bonus up to 10% of

Holiday allowance

Discounts from various retailers

Employee assistance programme

Job summary

Sainsbury's is seeking a Data Architect to design and build leading-edge data solutions across multi-brand platforms. You will collaborate with Product Owners and the Engineering community to deliver scalable data models that meet business needs.

This role requires expertise in data warehousing, canonical modelling and data modelling standards (3NF, Dimensional, Data Vault), with a focus on ELT pipelines and analytics at scale.

Qualifications

• Experience with semi-structured, high-volume data, ideally in Digital tagging or Analytics.
• Strong skills in stakeholder management.
• Hands-on DV 2.0 and Kimball dimensional data modelling.
• Experience in a Matrix reporting structure.
• Ability to serve as the Architecture custodian for the squad.
• Technical expertise in designing ELT pipelines.

Responsibilities

• Design and build leading-edge data solutions and models.
• Collaborate with Product Owners and Engineering to align data with business requirements.
• Define and own modelling within delivery teams, ensuring standards and principles.

Skills

Data modelling

Stakeholder management

DV 2.0

Kimball dimensional

Matrix reporting

ELT pipeline design

Job description

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 to feed the nation. The level of data, transactions and variety involved. Then you'll realise this is a modern software engineering environment, because it has to be. We've made significant investment in the standards and principles that shape how we work. We iterate, learn, experiment and champion ways of working such as Agile, Scrum and XP. So you can look forward to exciting opportunities across everything from AI to reusable tech.

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.

Why join us

Joining our team at Sainsbury's means becoming part of a multi-channel, multi-brand business that serves millions of customers daily, providing a vast and diverse dataset that is truly exciting. With over 1.2 billion transactions each year, we have the opportunity to harness this data and build scalable, high-performance products using cutting-edge technology, such as our award-winning Smartshop app, to deliver an exceptional shopping experience for our customers. As a Data Architect, you will play a crucial role in designing and building advanced data solutions and models, working closely with cross-functional teams to shape innovative products and services. In our inclusive and agile environment, you will have the freedom to explore, experiment, and tackle real-world challenges, witnessing the impact of your creations on millions of people across the UK. Additionally, you will benefit from a supportive culture that fosters innovation, collaboration, continuous learning, and personal ownership. Together, we strive to create a work-life balance that enables you to excel in your professional and personal aspirations.

What You'll Do

• As a Data Architect within our multi-channel, multi-brand business, you will play a pivotal role in designing and building leading-edge data solutions and models.
• Working closely with colleagues such as Product Owners and the Engineering community, you will ensure the delivery of optimal data solutions that align with business requirements.
• Your responsibilities will include triaging new requirements, assessing their impact, and providing estimates for modifying data models accordingly.
• You will also be responsible for developing and enhancing business physical data models to meet evolving needs while driving alignment as necessary.
• Acting as the custodian of data models, you will define and own modelling within delivery teams, ensuring adherence to standards and principles.
• It will be your duty to create solutions that fulfil business needs and align with the end state architecture, while simultaneously documenting, communicating, and centrally managing data models in an appropriate manner.
• Collaborating with the broader architecture community, you will share your expertise to promote alignment and innovation across Sainsbury's Tech.
• As an experienced Data Modeller or Architect, you will bring your passion for creating order within reporting structures, along with a comprehensive understanding of Data Warehousing/Analytic end-to-end architecture.
• Your proficiency with various modelling methodologies, such as 3NF, Dimensional, and Data Vault, will be essential, and your expertise in staying up to date with industry advancements, including machine learning and modern algorithmic techniques at scale, will be valuable in driving data design best practices.
• Strong communication and influencing skills will enable you to advocate for and implement these best practises at the Engineering and Product Manager levels.
• A curious and driven mindset will empower you to comprehend business processes and the data they generate, leveraging opportunities to structure and utilise this data for driving business value.
• In addition to abundant training and growth opportunities, you will enjoy benefits such as colleague discounts, holiday allowance, bonus schemes, pension plans, and special offers on various lifestyle perks.
• We prioritise work-life balance and offer flexibility in terms of remote and collaborative working, empowering our colleagues to find their own ideal balance while delivering exceptional results.

Who You Are

• As a Data Architect for our multi-channel, multi-brand business, you are a skilled and experienced professional who thrives in working with vast and complex data sets.
• With a passion for creating order within reporting structures, you possess expertise in data warehousing, analytic end-to-end architecture, and various modelling methodologies such as 3NF, Dimensional, and Data Vault.
• Your knowledge of the latest industry developments, including machine learning and modern algorithmic techniques at scale, enables you to design and build leading-edge data solutions that deliver valuable insights and enhance the overall customer experience.
• You've got experience in canonical modelling, publication service/microservice based schematic design.
• Your strong communication and influencing skills, combined with your curiosity and drive to understand business processes and leverage data for driving business value, make you a valuable asset in shaping and designing new products and services within the overall data architecture of our organisation.

Essential Criteria

• Experience working with semi-structured, high-volume data, ideally in Digital tagging or Analytics area.
• Strong skills in stakeholder management.
• Hands on experience in DV 2.0 and Kimball dimensional data modelling.
• Experience in a Matrix reporting structure.
• Ability to serve as the Architecture custodian for the squad, ensuring standards and principles are followed.
• Technical expertise in designing ELT pipelines.

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