Job Openings SAP HANA Data Modeler

About the job SAP HANA Data Modeler




A large financial services company


Cape Town (Hybrid working model)


You will be responsible to establish new technology components and reusable solution patterns that can be leveraged by business facing development teams in their day-to-day solutions. You are regarded as a data warehouse specialist with advanced analytical and technical skills who understands the data modelling, data engineering, data visualizations and analytical models.


Main responsibilities:

  • Data management and BI Solution development
  • Hands-on in complex SQL and data modelling
  • Quality assurance and governance of BI solutions
  • Ability to create efficient best practices and establishing suitable processes to ensure effective environment and solution management.
  • Ability to define a structured approach to problem solving and delivery against it.
  • Engage with a wide range of technical stakeholders including data engineers, database administrators and solutions architects.
  • Effective solution design.
  • Low error rate in deployed solutions.
  • Mentor Full Stack Developers within the team

Output/Core Tasks:

  • Provision data within Information Mart Layer through the development of analytical records and cubes
  • Design and build reusable artefacts to improve speed of delivery and reliability of solutions
  • Identifying performance enhancements for BI and Integration solutions
  • Troubleshoot technical issues such as database non-performance, integration failures and code failures.
  • Fulfil the role of technical expert on data modelling and data engineering aspects of BI products
  • Design, document and communicate technical solutions that deliver on business requirements
  • Form relationships and orchestrate delivery with key technical stakeholders across our business including architects
  • Assist with the design of architecture used by specialists in solutions.
  • Resolve data modelling issues impacting the functionality of BI products in production.
  • Contribute to BI development / modelling activity incl. code reviews, issue resolution and general support


  • You should be competent in communicating challenges and solutions to project and operational leadership. 
  • An understanding of data management solutions and a keen sense of the strategic value of information to an organization will be of importance. 
  • You will also be responsible for developing data models, monitoring program/ job performance, designing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems; translating business needs into long-term architecture solutions.
  • You should possess the ability to orchestrate delivery with a complex series of stakeholders 
  • You should be able to conceptualize solutions built on a hybrid of technologies with no real scope at the get-go, i.e. create, navigate and negotiate the scope on the fly.


  • Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering, or another quantitative field
  • National Diploma in an Information Technology related discipline preferred


  • 5+ years of experience in application and data engineering background with a solid background in SQL is required
  • Data architecture design and delivery experience preferred

Experience in the following areas is required:

  • Strong experience with SAP HANA studio - create views - calculation, analytical and attribute views and additionally creating of stored procedures.
  • Additional experience with SAP Web IDE is preferable
  • A solid background in Data Warehousing using SQL and ETL procedures is required, with a strong grounding in data modeling using Kimball
  • Application and data engineering background with a solid background in data warehousing environments
  • Experience in database management system (DBMS) physical implementation, including tables, joins, and SQL querying.
  • Experience of structured data, such as entities, classes, hierarchies, relationships, and metadata.
  • Experience in Agile development
  • Ability to comply to and manage data assets under a strict governance framework

Experience in one (1) or more of the following areas is desirable:

  • A solid background in Data Warehousing using SQL and ETL procedures is required, with a strong grounding in data modeling using Data Vault methodologies
  • Experience in data warehouse automation and the development of data pipelines using ETL tools (e.g. SAP Data Services), automation (e.g. Wherescape), scheduling, and test automation (e.g. Robot) is desirable
  • Strong Data Engineering background with a specific focus on staging high-quality data
  • Data Management technologies (e.g. Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX) are preferred

**Please note: If you have not heard from us within 2 weeks, please consider your application unsuccessful.