Job Openings SAP HANA Data Modeler

About the job SAP HANA Data Modeler

EMPLOYMENT TYPE:

Contract

COMPANY:

A large financial services company

LOCATION:

Cape Town (Hybrid working model)

JOB OVERVIEW:

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.

DESCRIPTION OF POSITION:

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

KNOWLEDGE AND SKILLS:

  • 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.

QUALIFICATIONS REQUIRED:

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

EXPERIENCE REQUIRED:

  • 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.