Specialist; Data Architecture and Modelling at CRDB October, 2023

Job Title: Specialist; Data Architecture and Modelling

CRDB

Line Manager: Manager, Data Management Operations

Department: ICT

Location: HQ

Job Summary

Design, implement, and document data architecture and data modelling solutions, which include the use of relational, dimensional, and NoSQL databases to support enterprise data management, business intelligence, machine learning, data science, and other data-related initiatives.

Key responsibilities:

  • Create data conceptual models and logical data models for each data asset.
  • Establish data mapping to all the source systems tables and fields that store data assets.
  • Analyze structural data requirements for new software and applications.
  • Develop migration plans of data from legacy systems to new solutions.
  • Design conceptual and logical data models and flowcharts.
  • Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
  • Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.
  • Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
  • Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
  • Work proactively and independently to address data-related project requirements and articulate design/modelling issues/challenges to reduce delivery risks.
  • Be responsible for the development of the conceptual, logical, and physical data models, OLTP RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
  • Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.
  • Engage with users during development and testing activities
  • Conceptualize, execute, and refine design specifications in the form of process flows, information architecture, wireframes, prototypes, and functional design specs.
  • Understand complex customer data, business goals, and requirements, and translate them into functional and technical designs.
  • Create customer-centric designs that meet organizational and user requirements.
  • Work closely with Data Architects in the development of stored procedures as well as data integrations and aggregation.

Experience, Knowledge and Skills Requirements

  • Bachelor’s degree in data science, Information Systems/ Computer Science or related discipline from a recognized university.
  • Minimum of 3 years of experience in data design and modelling.
  • Proven work experience as a Data Architect, Data Modeler or similar role.
  • In-depth understanding of database structure principles.
  • Experience gathering and analyzing system requirements.
  • Experience in data mining and modelling techniques.
  • Experience in SQL and Oracle.
  • Knowledge in data architecture, data warehousing, master data management, enterprise information integration and ETL using a cross-section of technologies and programming languages.
  • Hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols.

Deadline 18th Oct 2023

CLICK HERE TO APPLY