Key Responsibilities-
* Review existing domain data mart models/architecture to ensure that they meet the needs of our data strategy and are optimized 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 standardization 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 optimization 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, optimized 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 utilizing data visualization technologies (e.g., 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.