Data Modeller

Store Support Centre - London

Competitive plus benefits

Permanent - Full Time

26 November 2017

Related Positions

Software Engineer .Net

Competitive with Benefits

Store Support Centre - Coventry Walsgrave

26 November 2017

Software Engineer - Front End

Competitive plus benefits

Store Support Centre - Manchester

09 December 2017

Software Engineer - Big Data

Competitive plus benefits

Store Support Centre - London

19 November 2017

Quality Technologist - multiple vacancies (Reading, Oldbury and Washington store hubs)

Competitive plus benefits

Store Support Centre - Field Based

30 November 2017

Data Modeller

In a nutshell

Sainsbury’s is a data rich business – with information collected from consumers, suppliers and colleagues.  We believe that there is huge value in these data in driving value for our customers and, in turn, value for our shareholders.

This role will, in a nutshell, develop, update and improve data models in line with agreed ontology, artefacts, processes, standards and principles, ultimately to make great quality, well understood data available for reporting, analysis and insights.

The fundamental principle is that data is a corporate asset and, as such, we need to manage and govern it in a way which creates value from that asset.

What I need to do 

  • Triage new requirements, provide impact assessments and appropriate estimates for amending data models in line with solution designs and requirements
  • Develop and enhance business physical data models in line with new requirements for the Data and Analytics Centre of Excellence (DACE)
  • Work with Information Architects to enhance appropriate ontology (TOGAF or other), artefacts, toolsets, processes, principles and standards
  • Enhance the DACE data models and be their custodian, driving alignment as appropriate
  • Work with data management teams on the implementation of a new Data Dictionary
  • Balance resources between core strategic capability development and commercial solutions
  • Where appropriate, enable the de-commissioning of legacy data environments and associated data models
  • Create a great working relationship with all those involved in end to end solution design, development, test and release
  • Provide support throughout development and test making changes and amendments as appropriate
  • Define and own modelling from a physical perspective on a day to day basis
  • Ensure data models developed within DACE meet appropriate standards and principles
  • Creation of solutions that meet business needs and move towards end state architecture
  • Prioritise and manage team workload and time to deliver tasks to agreed deadlines
  • Ensure data models are documented, communicated, updated and centrally managed in an appropriate manner

How I will succeed

  • Work as a pro-active team member
  • Developing a great relationship with D&T (IT), peers, architects and the end user community
  • Help create great, practical, cost effective and flexible solutions
  • Understand the benefits of iterative solutions and minimum viable products
  • Being focussed on driving value back into the business and an enabler for the user community
  • Be a subject matter expert of all things data modeling
  • Develop and utilise your existing network within and outside of the open source community to share, learn, develop new and enhance existing capabilities.

What I need to know

  • Clearly a detailed knowledge of the frameworks, tools, technologies, skills and processes required for best practice data modelling
  • Use of canonical data models, data lineage, data dictionaries and user metric guides
  • How information flows around a business, ideally with previous retail and digital experience
  • Detailed understanding of design, development and modelling of data stores, digital data layers and data warehouses and associated toolsets.
  • Experience using and developing the Teradata Retail Data Model and using Erwin a bonus
  • How to optimise solutions for best performance in line with end user needs and use cases
  • Strong knowledge of conceptual, logical and of physical, data modelling, ontology and solution design toolsets, methodologies and processes
  • Knowledge and experience working with of big-data, digital and open source capabilities technologies as well as more traditional solutions
  • An understanding of data modelling in the cloud/open source and the services available. Experience in a hybrid of on-prem and cloud is a plus
  • A detailed understanding of how to turn business requirements into information and data models
  • A broad understanding of the applications of data from operational use, reporting through to data science 

What I need to show

  • Exemplary data modelling skills
  • A strong understanding what data, metrics, derivation is appropriate and what they really mean both in business and technology speak
  • That you can create data models for the requirements (both functional and non-functional) including the logical and physical modelling of target structures (normalised and dimensional), the transformation logic and the high level data movement
  • That the physical data models meet the requirements, the data solution is well understood, support its translation into development tasks, and provide support to the development and test teams as required.
  • Strong documentation and artefact management
  • Desire to mentor, coach and develop less experienced colleagues
  • Good communication and stakeholder management skills
  • The passion, drive and commitment to succeed in a fast-moving environment
  • A proven track record of designing and implementing data models in a complex company

Resources available to me

  • People – an appropriately sized and skilled team working in a matrix model and a manager to help drive your personal and career development
  • Toolsets – A mix of existing capabilities that can be enhanced and new toolsets being implemented such as an entreprise data dictionary
  • Data Models – An existing retail industry standard data model
  • A wholly engaged business – keen to have ‘data sorted’ and equally keen to help
  • The access to appropriate third party resources  

What decisions I can make

  • Data model design
  • Which frameworks, principles and processes to implement
  • How to drive personal and career development
  • How to prioritise and effectively manage time and deliveries


Apply now