Lead Data Modeller

12 Sep 2017
10 Oct 2017
Contract Type

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, lead a data modeling team to 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 provide appropriate estimates for amending data models in line with solution designs and requirements
  • Make difficult trade-off decisions between commercial pace and architectural debt
  • Understand the complexity of the business and ensure the appropriate models are implemented by the team to create clarity and alignment
  • Provide strong leadership, direction and support for the data modeling team, including coaching and mentoring colleagues, developing capability within the team, managing workload and ensuring deliverables are met
  • Define and implement the framework, standards and principles for data modelling within the team
  • Provide technical expertise to the team
  • Develop and enhance business physical data models in line with new requirements
  • Develop and enhance data models 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 and development
  • 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
  • Acts as the escalation route for Data Modellers to help resolve issues
How I will succeed
  • Communicate clearly what the appropriate solutions are and why certain approaches must be taken
  • Influence the solution design process to ensure that the data modeling team has a strong and respected voice
  • Work as a pro-active team member
  • Lead, develop and recruit a strong team
  • 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
  • How to lead and influence a development and solution design community to deliver appropriate and high performance solutions
  • Clearly a very detailed knowledge of the frameworks, tools, technologies, skills and processes required for best practice data modelling
  • Detailed knowledge of the 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 and development of data stores 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
  • Very 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
  • Strong understanding of the applications of data from operational use, reporting through to data science
What I need to show
  • Exemplary and inspiring data modelling and leadership skills
  • Great influencing skills to ensure the data modeling team truly has a voice with push back as appropriate
  • A deep understanding what data, metrics, derivation 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 teams as required
  • Strong documentation and artefact management
  • Desire to mentor, coach and develop team members
  • Good communication and stakeholder management skills
  • The passion, drive and commitment to succeed in a fast-moving, highly pressured environment
  • A proven track record of designing and implementing frameworks in a large scale, complex business
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 enterprise 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
  • Who to recruit
  • Data model design
  • Which frameworks, principles and processes to implement
  • How to drive personal and career development
  • How to prioritise and effectively manage team time and deliveries