Data Modeller
PBT Group
Johannesburg, South Africa
6d ago
source : Job Placements

PBT Group has an opportunity for Data Modellers to design and maintain optimal data models / structures 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 :

    Data Management Domain Knowledge :

  • Data Modelling Concepts : Erwin & SAP Sybase Power Designer
  • Canonical Data Modelling
  • Entity Relationship Modelling
  • Physical Database Design
  • Configuration Management
  • Data Flow Management
  • Data warehousing,
  • Data Integration,
  • Data Mining
  • Data Quality
  • Master Data Management
  • Metadata
  • Tools- Technical Skills :

  • IBM Infosphere Information Governance Catalog - Building the Governance Catalog
  • IBM Information Analyzer Essentials v
  • IBM InfoSphere DataStage Essentials
  • IBM InfoSphere Advanced DataStage - Parallel Framework
  • IBM InfoSphere DataStage v - Advanced Data Processing
  • IBM InfoSphere QualityStage Essentials v
  • IBM InfoSphere Advanced QualityStage v
  • Talend
  • Metadex -(SSIS)
  • Linux
  • Skill package will include knowledge in :

  • APIs, PERL, Python, SQL, XML, Java, C / C++ and others.
  • Understanding of at least some of the newest trends in the DBMS debate like :

  • NoSQL platforms such as Cassandra, MongoDB, Couchbase, Riak, Redis, FlockDB, Stig
  • Cloud Knowledge :

  • AWS, Azure, IBM etc.
  • Experience Required :

  • 3-5 years and / or relevant industry experience as well as experience in the Data Modelling discipline
  • 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
  • Technical Competencies :

  • 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.
  • Behavioural Competencies :

  • Exercises substantial personal responsibility and autonomy. Plans own work to meet given objectives and processes in an efficient manner.
  • Plans, schedules and monitors work to meet time and quality targets.

  • Work includes a broad range of complex technical or professional activities, in a variety of contexts. Investigates, defines and resolves complex issues.
  • Accomplishing tasks by considering all areas involved, no matter how small; showing concern for all aspects of the job;
  • accurately checking processes and tasks; being watchful over a period of time.

  • Makes decisions which influence the success of projects and team objectives.
  • Selects appropriately from applicable standards, methods, tools and applications. Communicates fluently, orally and in writing, and can present complex information to both technical and non-technical audience.
  • Facilitates collaboration between stakeholders who share common objectives.
  • Setting high goals for personal and group accomplishment; using measurement methods to monitor progress toward goals; tenaciously working to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.
  • Participates in external activities related to data modelling
  • Takes responsibility for driving own development by actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities.
  • Rapidly absorbs new information and applies it effectively.

    Qualifications / Certification :

  • A degree / diploma in Computer Science / Information Systems / Business Administration / Commerce or equivalent
  • Preferred Qualifications : TOGAF
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form