Data Designer / Modeller

at  Openwork UK Ltd

As an integral part of the multi-function Data Engineering Team provide data architecture, data design, and data modelling direction for Openwork’s data lake, dimensional model, reporting, and information systems.

KEY ACCOUNTABILITIES:

• Act as the Product Owner for the data lakehouse, semantic layers / data marts, and reference data solutions.
• Lead the Design and Modelling for data for Openwork data solutions.
• Produce and own the Logical Data Model for Openwork
• Produce and own the Kimball Symantec model using best practice techniques
• Define mapping specifications for the data migration from legacy DWH to the new DWH
• Produce and own the data mapping for the data warehouse reference data solution.
• Define mapping specifications for incremental data loads from various source systems into the DWH
• Drive enforcement of Architecture Principles within change, promoting re-use through adoption of the Openwork data model.
• Provide technical direction for Data and Business Analysts on the Data Transformation rules for mapping specifications
• Support development and Test team(s) within the programme

Please refer the Job description for details