|
| POSITION DESCRIPTION | BANKING & FINANCE INDUSTRIES OCTOBER 2008 |
 | | Position Title: |
Datawarehousing Consultant |
| Position Code: | 216 | | Career Level: | 3 |
|
|
Responsible for
Providing specialist knowledge and technical support/maintenance of corporate datawarehousing/business intelligence applications. |
| |
Reports To
Senior Database/Datawarehousing Manager. |
| |
Supervises
No supervisory responsibilities. |
| |
Main Activities
Providing maintenance and production support of corporate data warehouse applications.
Performing ad hoc technical support of a basic to intermediate nature associated with the organisation's datawarehousing/business intelligence systems.
Participating in process improvement exercises and identifying and analysing business and related requirements and providing the most effective and efficient related business solution.
Documenting identified business requirements in a suitable form for use within the organisation.
Utilising knowledge in one or more of the major relational database/datawarehousing applications to resolve support issues.
Ensuring the implementation of Data Analysis/Design policies in database design.
Identifying the business and technical impact based on requirements coming through from internal change requests.
Undertaking testing activities associated with solving issues raised - either through specific identification exercises or via more formal requests.
Writing and maintaining associated training material - including user manuals and web based training materials.
Performing overnight batch processing.
|
| |
Key Skills
Well versed in datawarehousing concepts and issues.
Well developed skills in relational database (RDBMS) administration and associated database management.
Good knowledge of one or more datawarehousing applications that may include Oracle, PL/SQL, Unix Scripting, EssBase, Business Objects.
Good understanding of business database needs.
Conceptual analysis and design ability.
|
| |
Internal Contacts
User Groups. |
| |
External Contacts
Hardware and Software Vendors. |
| |
Typical Experience
At least 3 years technical experience with large scale commercial databases. Tertiary level qualifications in Computer Science or an associated discipline. |
| |
Other Comments
Alternative Title - Business Intelligence Consultant/Analyst. |
| |
| |
| |
