Data Modeler

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 performanceData table structuresPartitioning of data across S3 and other object storesData Lifecycle Management – especially in AWS S3 and other cloud object file systems where storage costs are keyWhere and how business logic is developed, tested, approved and embeddedWho can create permanent or semi-permanent data, where it can be created and how it is managedHow data is presented and accessedReview data modelling and technical approaches to ensure that they are consistent and of high quality.SkillsAn 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 databasesA 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 possibleExtensive 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 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.