Senior Specialist:Data Design at Old Mutual

Purpose of the Job

This role is responsible for creating and embedding the data design practice in all areas of the data office, which include conceptual, logical and physical data modeling. In collaboration with the enterprise architecture function create a future fit data architecture and drive data interoperability within the organization.  

Job Objective

• Responsible for separating different types of data into structures that can be easily processed.
• Define and lead the implementation of an in-house data modelling framework to ensure the transformation and adoption of data modelling principles across all the data office
• Define and govern data modelling and design standards, tools, best practices and related development methodologies for enterprise data models.
• Set standards for document naming, security and lifecycle & retention architecture.
• Collaborate with enterprise architecture to translate data so that it can be read by various types of computer systems.
• Translate business needs into data models supporting long term solutions.
• In collaboration with data engineers create optimal physical data models of datasets, create and maintain data maps and systems interrelationship diagrams for data domains and systems.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• In collaboration with enterprise architecture optimise information/data management through an understanding of evolving business needs and technology capabilities.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Analyse data related system integration challenges and propose solutions.
• In collaboration with data teams, implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimise and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Build bespoke data models together with processes and capture tools to solve business problems.

Minimum Requirements

• Bachelor’s degree in Computer Science or Information Systems
• 8 – 10 years’ experience in Data modelling and Data architecture.
• 3 – 5 years’ experience in architecting data solutions with the latest hardware and software engineering competencies.