Data Architect
Cape Town, Western Cape, ZA
2d ago
source : Latest Jobs

The Information Management department has a position available for a Data Architect, in the Business Intelligence Solutions team, based in Bellville, Cape Town.

To ensure that the data assets of an organization are supported by the data architecture that aids the organization in achieving its strategic goals.

Execution of data architecture components as indicated in the Santam Group BI Strategic Roadmap. Create detailed data specifications

  • Design and prototype improvements to improve the product quality
  • Work together with Product Owners, Scrum Masters and Development teams
  • Work with Confluence and jira
  • Develop conceptual architecture
  • Refine the data model in Powerdesigner Create sourcing diagrams
  • Design / model history solutions and facilitate agreement amongst stakeholders
  • Design / model data migration solutions and facilitate agreement amongst stakeholders
  • Security requirements impacting database design modelled, agreed and accepted by Stakeholders
  • Relevant use of technologies agreed, inclusive of database, sql engine, etl tooling vs stored procedures
  • Create understanding and agreement for the need of appropriate database structures e.g. o Analytic (datawarehouse) o Operational (non-transactional, unstructured / semi-structured) o Operational (non-transactional, structured) o Operational (ACID compliant rdbms) What will make you successful in this role?
  • Experience in data analysis and data modelling techniques

  • Experience with backlog refinement to achieve a Definition of Ready Strong experience in business, data, and application analysis for data migration
  • Database layers and locations agreed e.g. landing, staging, atomic, on-premise, cloud, hybrid
  • Reference data list completed
  • Company Metadata Glossary aligned
  • Ability to consider all relevant architecture related needs such as synchronised indexes, key constraints, triggers, table partitions, table bucketing, multiple sql formats, database compression, memory utilisation, different data types
  • Conceptual understanding of database technologies
  • Understanding of business, systems and data analysis
  • Experience with investigating data queries and giving feedback
  • Exposure to physical database modelling and database design
  • Experience in the financial / insurance industry will be an advantage
  • Technical ability in ETL concept, design and development
  • Good SQL skills
  • Quality Assurance / Testing skills
  • Effective time management skills
  • Knowledge of IT System Development Life Cycles (SDLC) & agile methodologies specifically scrum
  • Transforms & Loads information, according to requirements, using the defined metadata Qualifications and Experience
  • Relevant Tertiary IT Qualification
  • Certificate or Diploma in Data Warehousing from industry recognised Training Institution will be an advantage but not essential
  • At least 3-5 years of experience in a Data Warehouse Environment
  • At least 3-5 years of data analysis & design experience Knowledge and Skills Technical specifications Analysis and design of systems and components Business Requirements Definition technologies
  • Report this job

    Thank you for reporting this job!

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

    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.
    Application form