The Data Modeller / Data Analyst will be responsible for analysing, designing, and maintaining robust data models to support analytical, business intelligence, and warehousing use cases. This role involves close collaboration with business stakeholders, data engineers, and visualisation developers to ensure that data is structured, consistent, and aligned with business requirements and technical standards. Elicit, analyse, and document data requirements to support analytical, BI, warehousing, and other data platform use cases.

Responsibilities :

- Design, create, and maintain data models (logical and physical) in line with enterprise data modelling standards and best practices.

- Develop and maintain data transformation specifications (Source-to-Target Mapping) and transformation scripts using SQL, DDL, DML, and PySpark.

- Elicit, analyse, and document data requirements in support of analytical, business intelligence, warehousing and other business use cases for the data platform using a range of techniques, including source data analysis, documentation, interviews, and data modelling workshops.

- Create and maintain data models appropriate to the need, and that conform to data modelling standards.

- Produce and maintain metadata (including relationships, calculation logic, etc. ) and

documentation to accompany data models using data modelling tools where appropriate.

- Ensure models will provide data structures that meet the required range of non-functional

requirements, including performance, extensibility, change capture (SCD, etc),

understandability, and maintainability.

- Create and maintain specifications for data transformation in both documentation (Source to

Target Mapping) and script.