Senior Oracle BI Developer - Johannesburg Verfied

Salary Negotiable Johannesburg, Gauteng Johannesburg, Gauteng more than 14 days ago 28-10-2014 7:08:37 AM
19-11-2014 7:03:14 AM
PBT is looking for an Oracle PL/SQL Developer to implement BI solutions on a
Microsoft platform. Microsoft BI experience would be a huge advantage.

This
position is for someone who has depth and breadth of skill and exhibits
leadership qualities. This role entails problem solving, technical depth and
innovation skills.

DUTIES:
- Strong working knowledge of the design and
implementation of BI systems
- Design, code, test, and document all new or
modified BI solutions.
- Develop query and reporting layer including dashboards
and structured reports
- Assist in the design of databases and data warehouses
- Troubleshoot BI solutions and performance-tune these applications as necessary
- Translate the BRD into the technical specification
- Use third party
applications as chosen by the client
- Promote BI usage to relevant departments
- Come up with innovative approaches to delivering more efficiently
- Adoption
of the architectural and development standards by the implementation team

- Oracle BI experience
- BI and data warehouse experience
- Knowledge of
Kimball methodology (specifically Kimball based data modelling)
- Intimate
knowledge of source systems as well as a basic understanding of dimensional
models.
- Conventional database- and data warehouse modelling skills, in order
to understand the data warehouse data models.
- A sound knowledge of the
programming language used to write the data staging programs or ETL tool.
- A
sound knowledge of SQL, or the language used to access the source databases and
the data warehouse from the data staging programs or ETL tool.
- A sound
knowledge of the capabilities of the ETL tools, to know what their capabilities
and shortcomings are – in order to exploit or avoid those aspects in the data
staging programs.
- Pride of work, thoroughness and attention to detail.

REQUIRED QUALIFICATIONS / TRAINING:
- Relevant data warehouse and BI solution
experience is essential.
- B.Sc. or related degree is advantageous.
- 3+ years
programming experience