Description
We are supporting a leading consultancy in their search for a Data Model Designer
- Experience owning SQL Schema Design of this scale
- Understand Conceptual/Relationship Data Models and all extract specifications
- Be Business Facing' and able to run workshops with the wider team if required to deliver the Schema Design
The Data Integration workstream is delivering the central mechanism for transferring and distributing Wrap Platform (ISA/GIA/SIPPs/Bonds).
This data will be delivered via daily extracts (approx. 70 daily files covering up to 800 unique data items across all Wrap products) from the platform and loaded to the Platform ODS. Although called Operational Data Store this is not truly an operational data store and is used to store and build history. The Database will then be used as a source for Qlikview reporting as well as downstream integrations via SQL BI views.