Job Purpose: 

Formal Education:

1. Grade 12
2. Bachelor’s Degree in Computer Science, Software Engineering, or a related field.
3. Preferred: Microsoft DevOps certifications, Microsoft SQL Server, Microsoft SQL Sever Integration Services Certification and IaC (Infrastructure as Code)

Work Experience

1. Minimum of 3–5 years experience in DevOps, Data Extract-Transform and Load (ETL), Database Services and Data Integration Services.
2. Proven experience in Database Development and Maintenance.
3. Proven Experience in Data Extraction, Transformation and Load (ETL).
4. Experience working with MS SQL Server, Power BI, MS SQL Server Integration Services, MS Power Automate and IaC.
5. Familiarity with agile development environments.

Key Skills and Capabilities Required

1. Ability to translate Business Strategy and Objectives into Data Requirements.
2. Ability to function across Business Units and engage with key data stakeholders.
3. Data exploration and data modelling capabilities.
4. Database creation, maintenance and optimisation skills.
5. Technical Skills in terms of Data Extraction, Data Transformation and Data Load (ETL).
6. Data Integration skills.
7. System Development Skills.
8. Project Management Skills.

Technical and Legal Certification

1. MS SQL Certification
2. MS SQL Server Integration Services
3. Microsoft Power Automate
4. MS Power BI
5. DevOps Foundation Certification

Key Responsibilities

1. Data Warehouse
2. Create and maintain Data Warehouse (Databases, Data Tables).
3. Create and maintain Data Views.
4. Monitor and optimise database performance.
5. Track and manage changes using version control.
6. Automation
7. Automate the Extraction, Transformation and Load of data from various internal and external data sources.
8. Setup of automated data pipelines to ensure data flows optimally between data sources and the Data Warehouse.
9. Monitor, manage and optimise data loads, and attend to extract, transform or load errors.
10. Maintain and improve pipeline performance, reducing deployment time and error rates.
11. Develop APIs for the extraction of information, making use of API Factory standards, patterns and guidelines.
12. Manage APIs throughout the API lifecycle.
13. Data Integration and Security
14. Securely connect the Data Warehouse to internal and external data sources.
15. Securely extract data via API Gateway.
16. Implement User Access Controls and Row Level Security.
17. Collaboration and Integration
18. Collaborate with Data Strategist and Data Analyst in the design and implementation of data models, entity relationships diagrams.
19. Support Power BI Team with data operations, improving feedback loops, and reducing deployment bottlenecks.
20. Work closely with security and compliance teams to ensure DevSecOps principles are applied.
21. Monitoring, Logging & Incident Support
22. Implement system observability and monitor data warehouse health and infrastructure performance.
23. Set up logging and alerting mechanisms using industry-standard tools (VMWare Aria, Splunk, BMC Helix).
24. Assist in troubleshooting production issues, performing root cause analysis, and implementing preventive fixes.
25. Optimise query performance and data loading times.
26. Implement and manage data refresh cycles and improve efficiency.
27. DevOps Governance & Best Practices
28. Document and maintain DevOps standards and SOPs.
29. Advocate for automation, reuse, and continuous improvement in deployment and operations practices.
30. Participate in internal DevOps community of practice, sharing knowledge and aligning on tooling and strategies.
    
    

Personal Attributes

1. Problem-solving and analytical skills
2. Creativity and innovation
3. Effective communication
4. Collaboration and teamwork
5. Strategic thinking and vision
6. Integrity
7. Dependable