Data Modeller Job in City Of Edinburgh, Scotland Uk
The project is responsible for the delivery of a Solvency II repository and Reporting solutions, to be used for internal and external reporting of Solvency II metrics.
The person shall be responsible for producing the S2 DRR project Logical Data Model, aiding the business analysts in the creation of their subject area data models and performing model management for all data models in the project.
You will be undertaking the production of logical data models (ER and Star Schema) required to support the Solvency II requirements, utilising IBM's Insurance Industry Warehouse model as the framework and extending as necessary.
Documenting and adhering to modelling standards as required. Model Management of the various data models. Working with Business/Data Analysts on mapping source to target data structures and production of ETL specifications. Confirming models with the appropriate business stakeholders. Working with DBAs and other technical staff to support creation of the physical design and implementation
(E) - Essential:
- Data analysis
- ER Data Modelling
- Star Schema Data Modelling
- Use of Data Modelling tool, specifically InfoSphere Data Architect tool (IDA)
- Model Management (of IDA models using Enterprise Model Extender (EME))
- Attention to detail
- Team player
- Good written communication skills
- Involvement in a data warehouse project
- Model Governance in a medium to large organisation
- Ability to work proactively in an indirect supervision environment,
- IBM Insurance Industry Warehouse Model
- Solvency II
(D) - Desirable:
Workshop facilitation Skills
- Stakeholder management
- Previous experience in the Financial Services industry
- Experience of financial regulation reporting (especially in the areas of Risk and Finance)
- Management Information reporting
- Production of Functional Specifications/Designs