Senior Specialist: Technical Support; Enterprise Data Warehouse

Position: Senior Specialist: Technical Support (Enterprise Data Warehouse)
Position Reports to: Manager: IT Service

Division:
Strategy Enab & Modernisation

Location:
Head Office - Brooklyn

Advert Closing Date: 20 March 2026

About the Position

An exciting opportunity is available for a highly specialised forward thinking, self-motivated and dynamic IT specialist with a passion for data. The incumbent will function on strategic level with regards to extraction, transformation and loading of data into the Enterprise Data Warehouse. The extraction of information from the various lines of business systems into a normalized warehouse will be a key responsibility and challenge.

Data scrubbing and cleansing ability to keep track of the dynamic changes in the SARS business environment will be crucial as well as third party data sources. Automating the ETL process through scheduling and exception-handling routines.

Job Purpose

To provide advice and support on architectural design strategies in order to achieve business objectives.

Education and Experience

Minimum Qualification & Experience Required

Bachelor's Degree / Advanced Diploma (NQF
7) in Information Technology/ Software Development AND 8 - 10 years' experience in a similar environment, of which 3 - 4 years at a junior specialist level in at least two of the following: data collection, technical support, source to target mapping, or database administration. 8 years' experience with SQL Server, SSIS, DB2 and IBM Q-Replication technology and Unix fundamentals will be an added advantage.

Experience in Data Warehouse load utilities. of which 3-4 years is at operational specialist level

ALTERNATIVE #

Senior Certificate (NQF
4) AND 15 years related experience, of which 3 - 4 years years at a junior specialist level in at least two of the following: data collection, technical support, source to target mapping, or database administration. 8 years' experience with SQL Server, SSIS, DB2 and IBM Q-Replication technology and Unix fundamentals will be an added advantage. Experience in Data Warehouse load utilities.

of which 3-4 years is at operational specialist level

Job Outputs:

Process

• Analyse and make recommendations about improvements to specialist systems, procedures and associated area's practice.
• Analyse and make recommendations about improvements to specialist systems, procedures, policies and practices.
• Combine applied and theoretical knowledge, to know and understand the theory and principles underpinning a particular discipline(s).
• Contribute to the optimum utilisation of org. resources, advising on effective planning and development of area of specialisation resource plans.
• Develop a single practice area in alignment with operational activity and procedural frameworks and ensure tactical implementation.
• Develop integrated solutions based on features, capabilities and ad hoc architectural systems.
• Draw on own technical or professional expertise, knowledge and experience to identify and recommend tactical solutions to defined problems in practices.
• Enhance processes and drive process optimisation to increase efficiencies of the functional area.
• Ensure that processes are automated where appropriate, optimised and suitably scalable.
• Integrate business information, compare, analyse and produce reports to identify trends, discrepancies and inconsistencies for decision making purposes.
• Note potential problems and obstacles, accumulate supporting data and initiate actions to prevent or overcome predicted problems as may be identified.
• Optimise goal achievement through tactical strategy implementation and optimisation of practises, processes and systems across an internal value chain.
• Plan for value-added, continuous practice and system improvements to deliver on objectives to enhance tactical implementation and excellence.
• Proactively identify interconnected problems, determine its impact and use to develop best fit alternatives; best practice implementation solutions.
• Recommend changes to optimise processes, systems, practice areas and associated procedures and execute the implementation of change and innovation.
• Translate top-down policy, apply modification in relation to own practice area and communicate impact to relevant stakeholders.

Governance

• Develop and /or align governance and compliance policies for own practice area to identify and manage risk exposure liability.

People

• Integrate new knowledge and transfer skills attained through formal and informal learning opportunities in the execution of your job.
• Provide specialist know-how, support, advice and practice thought leadership in area of expertise.

Finance

• Implement and monitor financial control, management of costs and corporate governance in area of specialisation.

Client

• Develop and ensure implementation of a practice that builds service delivery excellence and encourages others to provide exceptional stakeholder service.
• Participate in the specialist practice community and contribute positively to organisation knowledge management.
• Provide authoritative, specialist expertise and advice to internal and external…