Job Title

- Design and optimise dimensional models for reporting and analytics, including mini dimensional models in SQL - Migrate data transformation steps from PowerBI to data bricks and roll out DBT for scalable workflows. - Rebuild and maintain core datasets to ensure accuracy and performance across systems. - Producing Conceptual, Logical and Physical Data Models and related artefacts to specified standards - Producing Entity Relationship Diagrams and specifying and documenting the - relationships between entities, specifying and documenting the data attributes for each entity - Agreeing entity and attribute definitions with the respective stakeholders - Simultaneously being part of several project teams in order to allow multiple projects to proceed at pace concurrently - Contributing to data modelling framework design discussions regarding items such as - the design and use of Reference Data - Investigating and providing estimates for data modelling work and, reporting progress to-date - Working with Business SME and Technical staff to identify the data sources to be used - to meet the business requirements - Data mapping: The identification, specification and documentation of data mappings - and the associated transformations in order to move data from the source systems, - through the data warehouse layers where appropriate and, to present the data to authorised end users - The clarification and documentation of business rules and data transformations with - technical colleagues and business users - Working with Database Administrators (DBA’s) and information service designers to - ensure the physical implementation meets the functional and non-functional requirements