Position Name : Data Warehouse Specialist

 

The Data Warehouse Specialist reports to the Infrastructure Services Team Leader and is responsible for the implementation, support and maintenance of the comapanies' Data Warehouse infrastructure. A key objective of this role is to ensure optimal performance of system databases and the Enterprise Data Warehouse.

Perform technical administration duties for data warehouse development and maintenance.

Perform data warehouse design, configuration, testing and movement to production.

Implement and enforce standards and procedures to ensure data is managed consistently and is properly integrated within the

warehouse.

Implement business rules via stored procedures, middleware, or other technologies.

Provide support for data warehouses.

Code and document procedures.

Programme, test and debug data warehouses.

Apply best practice standards.

Stay abreast of and implement current technologies.

 

Qualifications:

Relevant degree or diploma

Accredited MS SQL DBA

SSIS (SQL Server Integration Services)

SQL Database Administration

Transact SQL

 

Experience and Requirements:

Data Warehouse experience (3+ Years).

A successful candidate would need to have demonstrated exceptional achievement in his/her area of study.

 

Beneficial:

Business Intelligence experience, e.g. QlikView, Cognos, etc.

Windows Server experience (BI servers)

MySQL experience

PostgreSQL experience

Integration experience with other systems, e.g. ERP’s, ESB’s, etc.

Salary will be based on experience and skills brought to the role

Benefits provided - medical and pension