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