POST 32/14 :Senior Business Intelligence Developer (Ref No: SBID/ICT/2018/08-1P)
The purpose of the post is to provide support by extracting, loading and transforming
(ETL) application data for relational databases by transforming business requirements
into optimal system implementations.
SALARY : R697 011 per annum (all-inclusive package)
CENTRE : Pretoria Office
A three year National Diploma or Degree in BSc (Computer Science); B Com
(Information systems) or similar professional qualification (at least 360 credits) coupled
with 6 years working experience in the Applications Services field of which 3 years was
in a managerial role. Experience in the Management of Application Development life
cycle will be an advantage. Subsequent Business Analysis, Programming, System
Analysis, Object-Oriented Design (ODD) Software Debugging qualifications will be an
advantage. Knowledge of Data Warehousing: Data Warehouse Design methodologies and architecture, Design and Data Modeling, Data Warehousing experience utilizing OLAP toolset. Strong Oracle Data Integration suite (ODI) skills, working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS Access/Excel documents, Warehouse and ETL processes skills as well as ODI scheduling. Knowledge of Database: Domain Modeling, SQL (DDL & DML) and related tools. Strong PL/SQL skills. Advanced level of writing stored procedures, reading query plans, tuning, indexes and troubleshooting performance bottlenecks. Knowledge of BI
Applications: Strong Oracle Business Intelligence Enterprise Edition (OBIEE) skills.
Strong knowledge on OBIEE Security, Administration, Advanced features of OBIEE 12c.
Ability to make assessments and informed design decisions that consider Development,
Quality Assurance and Technology Operations (Configuration, etc.). Knowledge of
SDLC: Analysis, enhancements, Version Control, releases, documentation, Integration
Testing. Ability to facilitate system reviews, conduct business process analysis and
functional gap analysis. Knowledge of Business Applications support services in an
outsourced environment including escalations and root-cause analysis. Knowledge of
laws, precedents, and government regulations around Government Finance (i.e.
PFMA), SITA Act, Electronic Communications Act, etc. Knowledge of Business
Applications fit on business continuity requirements with a specific focus on security and disaster recovery. Knowledge of Prince or PMBOK project management methodology. Knowledge of Oracle; Linux; Java; J2EE; ETL; Data Warehouse and change
management software. Teamwork. General Verbal Communication. Software
Architecture. Project management. Team collaboration. Ability to delegate. Emotional
Intelligence. Demonstrable Commitment. Customer service orientation. Structured
The successful candidate will be responsible for the following functions and include, but
not limited to: Implement Application Development, Support, Maintenance and
Adaptation of new Applications Technical Design: Designing technical architecture,
configuring all components of the Data warehouse. Design ETL Scenarios and
Procedures. Implementing the metadata layers and generating reports and dashboards.
Design Technical OBIEE Report Specifications. Design technical Dashboards and
navigation links. Participate in Technical/Functional Requirements meetings. Ensure all
assigned designs fit into the overall architecture/design of Oracle BI solutions. Maintain
data models continuously as modifications and enhancements are made. Create and
Design data modelling for data marts or for specific subject area as per BRS. Design
logic and physical Star Schema. Meet or exceed internal and external (customer)
expectations based on delivery. Implement development objectives by analysing user
requirements; envisioning system features and functionality. Complete application
development by coordinating requirements, schedules, and activities. Enhance the
quality of applications by improving the design or tuning for performance. Participate in
the Code Review process and action the outcomes of the code review. Deliver code
timeously to the test environment. Support, troubleshoot and resolve development and
production problems across multiple environments and operating platforms. Supports
users by developing documentation and assistance tools. Ensures operation by training
internal client personnel; providing support. Document, review and execute all
requirements for releasing of code. Manage the provision of Application Management
services to the organization: Ensure task activities are managed daily with estimates
and deadlines. Plan delivery commitment such that deliverables does not unnecessarily
move between releases. Ensure no delays accrue due to misunderstanding of
requirements. Ensure quality control over output by ensuring policies and procedures
are followed. Share technical assistance, guidance and advise within the team. Manage
potential Application Management risks: Identify production problems (network,
application, database, connectivity, performance problems) with proposed solutions
with follow up of execution of approach. Check that all Applications Management Audit
Report queries are addressed to eliminate or mitigate the associated risks. Raise risks
with management early. Plan capacity requirements: Assess IT infrastructure
requirements so that Application Management processes and procedures run smoothly.
Plan execution of own work (estimate duration for new/existing requirements
– project plan with dependencies). Facilitate business partnering: Enhances organization
reputation by accepting ownership for accomplishing new and different requests;
exploring opportunities to add value to job accomplishments. Provide Application
Management support and advice to the Design COE with regard to relevant applications
solutions to problems raised by managers. Contribute to Client meetings, demonstrating
Application Management capability when required.
FOR ATTENTION : Ms Thenjiwe Gasa – Recruitment
One Senior Business Intelligence Developer– ICT position is currently available at the
Government Pensions Administration Agency: ICT Division. This position will be filled
as a permanent position. Employment Equity target for the post is African, Indian or
Coloured males or females or people with disabilities. Candidates of the specified
groups are encouraged to apply.
GOVERNMENT PENSIONS ADMINISTRATION AGENCY (GPAA)
APPLICATIONS : Please forward your application, quoting the relevant reference number, Government
Pensions Administration Agency, 34 Hamilton Street, or Private Bag X63, Arcadia,
No late applications will be considered.
NOTE : Requirement of applications: Applications must be submitted on form Z83, obtainable on the internet (Originally signed).
The relevant reference number must be quoted on all applications.
Application should consist of (1) a comprehensive CV (specifying all experience and duties, indicating the respective dates MM/YY as well as indicating references with full contact details; original certified copies of all qualifications (including matriculation), Identity document, valid driver’s license (where driving/travelling is an inherent requirement of the job) and proof of citizenship if not RSA Citizen.
Copies of certified documents will not be accepted – all copies must be originally certified in the past 3 months.
Failure to submit the above information will result in the application not considered and deemed a regret.
The candidate must agree to the following: Shortlisted candidates must be available for interviews at a date and time determined by GPAA.
Applicants must note that pre-employments checks and references will be conducted once they are short-listed and the appointment is also subject to positive outcomes on these checks, which include but not limited to: security clearance, security vetting, qualification/study verification, citizenship verification, financial/asset record check, previous employment verification and criminal record.
Applicants will be required to meet vetting requirements as prescribed by Minimum Information Security Standards.
It is the applicant’s responsibility to have foreign qualifications evaluated by the South African Qualifications Authority (SAQA).
Correspondence will only be conducted with the short- listed candidates.
If you have not been contacted within three (3) months after the closing date of this advertisement, please accept that your application was unsuccessful.
The candidate must take note of:
It is intended to promote representativeness through the filling of these posts and the candidature of persons whose promotion/ appointment will promote representativeness, will receive preference.
Disabled persons are encouraged to apply.
For salary levels 11– 15, the inclusive remuneration package consists of a basic salary, the state’s contribution to the Government Employees Pension Fund and a flexible portion in terms of applicable rules. SMS will be required to undergo a Competency Assessment as prescribed by DPSA.
All candidates shortlisted for SMS positions will be required to undergo a technical exercise that intends to test the relevant technical elements of the job.
The GPAA reserves the right to utilize practical exercises/tests/competency assessments for non-SMS positions during the recruitment process (candidates who are shortlisted will be informed accordingly) to determine the suitability of candidates for the post(s).
The GPAA reserves the right to cancel the filling/not to fill a vacancy that was advertised during any stage of the recruitment process.
The successful candidate will have to sign and annual performance agreement and will be required to undergo a security clearance.