Aug 15, 2018
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
REQUIREMENTS : 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 Approach.
DUTIES: 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
NOTE : 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, Pretoria, 0001.
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.
Government Pensions Administration Agency
Pretoria, South Africa