SENIOR PRACTITIONER: FINANCIAL BUSINESS SYSTEM REF NO: GPT/2021/5/7
Directorate: Financial Governance
SALARY: R316 791 per annum (plus benefits)
REQUIREMENTS: A tertiary qualification NQF level 6 as recognized by SAQA in Computer Sciences or Information Technology or Informatics or Financial Information Systems or Finance or Statistics, Mathematics related qualification. 1-3 years experience in database design and the normalization of data structures. 3-5 years experience in database design and the normalization of data structures. 1-3 years experience in SQL – ability to write custom queries, views, and triggers and building tools for online analytical processing (OLAP cubes) 1-3 years experience in Predictive Modelling and Machine Learning or Project management methodologies or IT implementation cycle. Knowledge of Server Integration Services (SSIS), Data Validation, Visual basics. NET.
DUTIES: Monitor and ensure the management of internal controls in line with the existing application. Ensure that the server processes and services continue to run and operate in the most efficient manner. Oversee user account management processes for BI users. Translate business needs to technical specifications. Design, build and deploy BI solutions (e.g. reporting tools). Develop and update technical documentation (Developer and planning doc). Maintain and support data analytics platforms. Manage production environment through the building, maintaining and monitoring load processes according to an operational level agreement. Data Engineering (extractions, transformations, loading patterns). Descriptive analytics (ability to extract insight and trends from databases on requirements) effectively visualizing data (dashboards) to address business questions. ETL development to load Data warehouse. Testing and deployment of new development. Build, lead, or participates in the development and implementation of statistical model and sampling plans for application invalidation. Designing, developing, testing, and maintaining data architectures. Prepare data for descriptive, predictive, and prescriptive modeling. Automating repetitive tasks and manual processes related to data usage. Evaluate and improve existing BI systems. Prepare action plans for continuous data clean-up and integrity projects. Continuous improvement of application to ensure stability, quality reporting, and performance optimization. Maintain existing SSRS and QlikView report definitions to present the data. Support existing integration and reporting solutions in the production environment by analyzing problems reported by users and track down their cause through debugging techniques and discussion with other team members. Provide user training and support for BI users.
ENQUIRIES: Mr. Sihle Hlomuka Tel No: (011)
APPLICATIONS: must be submitted on a duly signed Z83 form, comprehensive CV, certified copies of ID and all Qualifications to be attached. The application should be submitted at Gauteng Provincial Treasury: Ground Floor, Imbumba House, 75 Fox Street, Marshalltown, Johannesburg, or posted to Private Bag X12, Marshalltown, 2107. To access the SMS pre-entry certificate course and for further details, please click on the following link: https://www.thensg.gov.za/training-course/sms-pre-entryprogramme/. For more information regarding the course please visit the NSG website: www.thensg.gov.za
CLOSING DATE: 21 May 2021
NOTE: Applications must be submitted on the New Z83 form, obtainable from any Public Service Department, or on the internet at www.dpsa.gov.za/documents. The Completed and signed form should be accompanied by a recently updated CV specifying all experience indicating the respective dates (MM/YY) as well as indicating three reference persons with the following information: name and contact number(s), email address, and an indication of the capacity in which the reference is known to the candidate as well as certified copies of all required qualification/s as per the advertisement and ID document. Suitable candidates will be subjected to Personnel Suitability Checks (criminal record, citizen, credit record checks, qualification, and employment verification). Confirmation of the final appointment will be subject to a positive security clearance. All non-SA citizens must attach certified proof of permanent residence in South Africa. It is the applicant’s responsibility to have foreign qualifications evaluated by the South African Qualifications Authority (SAQA). Failure to submit all the requested documents will result in the application not being considered. The persons appointed to this position will be subjected to a security clearance. SMS candidates will be required to undergo a Competency Assessment as prescribed by the DPSA. All shortlisted candidates for SMS positions will be required to undergo a technical exercise that intends to test the relevant technical elements of the job. Gauteng Provincial Treasury (GPT) reserves the right to utilize practical exercises/tests for non-SMS positions and during the recruitment process (candidates who are shortlisted will be informed accordingly) to determine the suitability of candidates for the post(s).GPT also reserves the right to cancel the filling / not to fill a vacancy that was advertised during any stage of the recruitment process.