REF # 20260

 179 total views,  9 views today


Data Warehouse Architect (PTA)

Enquire / Apply


A data-driven firm specializing in managing risks & developing innovative business opportunities in Pretoria seeks the expertise of a highly skilled Data Warehouse Architect to join its team. Your core role will include designing ETL processes & performing test on data. You will require a Bachelor’s Degree in Computer Science/Engineering or a Quantitative field, 8 years’ relevant experience a similar role & in-depth knowledge of Power BI (cloud, server, and embedded), Tableau, SQL Server Management Studio, Excel, Report Building, Programming, and/or Quantitative Analysis.



Design various ETL processes and perform tests on data.

Implement various ETL processes (SQL SSIS).

Perform troubleshoot on all ETL processes and resolve issues effectively.

Define meta data standards for the data warehouse

Analyse all data warehouse architecture goals and identify skill requirement for same.

Develop both physical and logical data models.

Prepare designs for database systems and recommend improvements for performance.

Maintain and develop various database scripts and tools to facilitate automation process.

Provide support to all data warehouse initiatives.

Analyse all data warehouse activities and identify key resources for same.

Monitor processes and develop plans to capture and access all metadata.

Develop and implement various work plans for projects.

Evaluate all proposals requests and assist to improve structure of data warehouse.

Prepare appropriate status reports and submit it to management.



Qualifications –

Bachelors’ Degree in a Quantitative, Computer Sciences, Engineering or equivalent.


Experience/Skills –

8 Years of related experience in a similar role.

Previous experience within a medical service/ funding or similar industry is advantageous.

Experience in Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS and Power BI).



Excellent verbal and written communication skills at a senior level.

Ability to innovatively solve complex business information needs through the application of current business intelligence tools and technology.

Personal Drive – Willingness and desire to go the extra mile in solving difficult business problems, even when it lies outside traditional boundaries.

Team Player – Willingness, and desire to be part of a strong team and contribute to a strong culture within and across organisations.

Collaborates productively with internal/external partners, subject matter experts, and business leaders.


While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.



When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence.

Degree, Permanent

Please complete the following form.

Upload Your CV (MS Word)