Senior Data Modeller - AWSKey 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.Data query performance and Data table structures Partitioning of data across S3 and other object storesData Lifecycle Management especially in AWS S3 and other cloud object file systems where storage costs are keyData 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 databasesExtensive data modelling experience, from conceptual to physicalExpertise in different modelling methodologies such as 3NF, Dimensional, Data VaultExpertise in building cloud data warehouses using Kimball, preferably using AWS RedshiftKnowledge/experience of building queries and MI outcomes utilising data visualisation technologies (e.g., Tableau) Qualifications in RDMBS design and/or administration and in AWS architecture (at least one of these)