Data Intelligence Developer II

• Collaborate with stakeholders to gather requirements and define key performance indicators.

• Develop robust data models and ETL/ELT pipelines to ingest, transform, and store data.

• Design and maintain canonical and semantic data models aligned to business and integration needs.

• Ensure data quality and accuracy through validation checks and reconciliations.

• Monitor and optimise the performance of our data environment for efficiency and scalability. Works in partnership with Business representatives (e.g. Product Owner, Business Owner) ensuring alignment and value to the customer

• Aligns personal values to the company's culture and values.

• Takes responsibility for personal development and career pathing.

• Subscribes to the company's code of ethics.
• Behaves in a manner that enhances the reputation and brand of the department and the company.

Minimum Requirements

Education

• BSc in Computer Science, Electronic Engineering, or BCom in Business Information Systems (BIS).
• A high-quality Technikon Diploma will also be considered.
• A Master’s degree is an advantage.

Experience

• 4–6 years’ experience in a large organisation (financial services preferred).

Competencies

• 
  Technical Competencies:
• Core
• Strong foundation in data warehousing concepts and ETL/ELT processes.
• Query Performance Optimisation, indexing, using rowstore and column store databases
• Experience using No
  
  SQL platforms like Mongo
  
  DB, Document
  
  DB etc.
• Hands-on experience with Snowflake, DBT, Airflow.
• Proficiency in SQL and Python.
• 
  Advantageous:
• Knowledge of data virtualisation; experience with Denodo will be a strong advantage.
• Experience working with Amazon Q / Kiro