Specialist: Data Architecture and Modelling at CRDB Bank

Specialist: Data Architecture and Modelling at CRDB Bank

Reporting Line- Manager; Data Management Operations

Department- ICT

Location- Head Office

Job Summary.

The purpose of the job is to be responsible of design, implementing, and documenting 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. This role involves analyzing systems data requirements, overall design and giving architectural recommendations on appropriate methods for data capture from source, transformation logics and final storage in the data warehouse, on occasion, it will involve recommending migration methods for existing data.

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 modeling 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.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.
• 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 information technology, Computer Science, Computer Engineering or any other equivalent and relevant qualification from an accredited institution.
• Minimum 3 years of hands-on experience in analytical systems support, data designs and modelling, Data
• Architect, Data Modeler and relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Experience with enterprise data platforms.
• Good knowledge of metadata management, data modeling-related in ER Studio or others).
• Experience with data management and relational database design and familiarity with data formats, table joins, and ETL.
• Knowledge in data architecture, data warehousing, master data management, enterprise information integration and ETL using a cross-section of technologies and programming languages.
• Clear understanding of common data requirements as they relate to the finance, sales, marketing and contact centre organizations.
• Understands the impact of the data models on complex business issues across many functions and departments.

Deadline 14th August 2023

CLICK HERE TO APPLY