Key Responsibilities

• Review existing domain data mart models/architecture to ensure that they meet the needs of our data strategy and are optimised to support our key analytical use cases.
• Design and develop remediated designs/models and work with engineering and analytical stakeholders across the different domains to create backlogs for model standardisation and improvements.
• Ensure storage and consumption approaches/designs deliver maximum efficiency, with a focus on balancing storage and compute costs optimally.
• Produce and maintain modelling and design guardrails, standards and processes and integrate these with wider data management and engineering governance, for example:

• Data query performance
• Data table structures
• Partitioning of data across S3 and other object stores
• Data Lifecycle Management - especially in AWS S3 and other cloud object file systems where storage costs are key
• Where and how business logic is developed, tested, approved and Embedded
• Who can create permanent or semi-permanent data, where it can be created and how it is managed
• How data is presented and accessed
• Review data modelling and technical approaches to ensure that they are consistent and of high quality.

Skills

• An experienced, driven expert in a broad set of data capabilities such as:

• Data design patterns and optimisation across disparate mediums within a Cloud-based environment (preferably AWS) such as large object file systems (AWS S3), RDBMS and columnar databases
• A strategic thinker who can define modelling patterns for various layers of a data environment balancing storage vs. compute costs, optimised for as broad a set of use cases as possible
• Extensive data modelling experience, from conceptual to physical
• Expertise in different modelling methodologies such as 3NF, Dimensional, Data Vault
• Expertise in building cloud data warehouses using Kimball, preferably using AWS Redshift
• Knowledge/experience of building queries and MI outcomes utilising data visualisation technologies (eg, Tableau)

Qualifications in RDMBS design and/or administration and in AWS architecture (at least one of these)

Awareness of data governance and data ethics in the production of automated modelling

Proven track record of delivery of modelling designs/approaches in large scale data environments

Evidence of broad stakeholder management from senior business level down to analyst

Experience in, or extensive exposure to MI/BI use cases, data exploration and analysis. Experience within predictive modelling/Data Science would be an advantage

Experience in defining and delivering data monitoring across a large platform as well as establishing governance forums, processes and guardrails to ensure compliance with standards