Job Openings Data Modeler

About the job Data Modeler

  • EMPLOYMENT TYPE: 

    Contract - 12 months with high probability of extension.

     

    LOCATION: 

    Cape Town but all work is currently conducted remotely.

    JOB OVERVIEW: 

    The candidate will work in a team guided by a project manager and architect. 

    Responsibilities: 

    • Design and implement  

    • cubes,  

    • views,  

    • simple ODS designs  

    • hybrid Kimball designs  

    • data vault designs. 

    DESCRIPTION OF THE POSITION: 

    • Willing to work in a technology-agnostic environment  

    • Have strong SQL, proc SQL and ETL / ELT skills 

    •  Strong dimensional modelling background 

    • Hands-on experience building dimensional data warehouses 

    Strong exposure to some of the technologies below: 

    • SAP HANA  

    • Microsoft SQL  

    • SSIS,  

    • SSRS,  

    • SAP BODS 

    • Hadoop,  

    • HIVE, 

    • Cloudera, 

    • Informatica or related tools 

     

    KNOWLEDGE AND SKILLS: 

     

    • Database development: SQL and Stored Procedure development. 

    • General Data architecture design and delivery experience essential 

    • Ability to define structured approach to problem solving and delivery against it 

    • Ability to create design standards, patterns and principals 

     

     

    QUALIFICATIONS REQUIRED: 

    • Relevant Degree or Diploma  

    EXPERIENCE REQUIRED: 

    • 8 - 10 years related experience. 

    • Experience in database technologies like: 

    • SAP HANA 

    • SQL Server, Teradata or Hadoop/Cloudera 

    • SAP Hana Development/Data Modelling 

    • Experience in ETL tools, e.g. SAP Data Services 

    • Dimensional modelling,  

    • OLAP and MDX experience 

    • Experience with server-side languages like: 

    • Java,  

    • JavaScript,  

    • Python/Hadoop  

    • Components: 

    • HDFS,  

    • Spark,  

    • Hive,  

    • Impala 

     

    ADVANTAGEOUS SKILLS: 

    • SAP HANA Certification 

     

     

     

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