PBT Group, leaders in Business Intelligence in South Africa, is looking for a Data Modeler to assist with the building of Data models at both an enterprise and system / application level that meet the business and architectural objectives of the organisation.

Duties:
- Design data models that meet the business requirements and align to the agreed architecture framework.
- Ensure data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders.
- Ensure all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards
- Apply the approved tooling to create the data modelling deliverables.
- Adopt the Enterprise Data Model (which is based on the IFW) as a standard for data model designs to leverage best practice and fast track data modelling efforts.
- Translate business requirements into data requirements.
- Analyse and profile the source data to understand data quality issues, relationships, patterns and rules in the data.
- Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, dimensional models to ensure optimal implementation.
- Compile Source to Target Mapping Specifications
- Ensure complete and correct data by identifying definitive or authoritative source of data; analysing source data; and identifying gaps
- Enable physical implementation of the data structure by generating the first cut physical data model from the logical data model.
- Facilitate dataflow understanding by collating dataflow diagrams outlining the flow of data across systems and interfaces.
- Reduce non value adding work by identifying opportunity for re-use of the Enterprise Data Model
- Maintain up to date knowledge of latest developments in the Data Modelling domain, including reading; continuous professional development courses; seminars and conferences

Skills Required
- 3+ years’ experience in data modelling:
:: 3rd Normal form modelling
:: Conceptual Data modelling
:: Logical data modelling
:: Physical Data modelling
:: Maintenance of data models in Data modelling repository
- Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling also an advantage
- Experience using Infosphere Data Architect or any other Data Modelling Tool
- Experience with industry models such as IFW BDW and FSDM
- Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
- Relevant regulatory knowledge, and understanding of banking and financial services
- Data analysis: Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.
- Data Modelling: Specialist knowledge of database concepts, object and data modelling techniques and design principles.
- Must have done modelling in data modelling tools such as PowerDesigner, E/R Studio, CA Erwin, Rational Data Architect
- Understanding of other types of data modelling (Atomic, Vault, Star schema) for applications, integration and BI systems
- Solid experience in implementing solutions with Referential Integrity
- Experience in implementation of solutions on various RDBMS
- Experience in modelling in Big data platforms (Hadoop, NoSql, etc.) would be an advantage
- Experience PowerDesigner data modelling tool (advantage)
- Integration of data models into metadata repositories and business glossaries (advantage)