Data Warehousing Specialist

Purpose of Role:

Maintance of:

Existing MIS databases

Existing reports and dashboards

Existing data warehouses

Develop, test, deploy, maintain and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.

Responsibilities:

Develop, implement and document Business Intelligence Solutions (Internal Process):

Contribute to the overall data warehouse architecture and data base designs

Maintain and oversee the administration and maintenance of the data warehouse

Develop and maintain Business Intelligence and reporting technologies and processes

Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications

Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications

Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions

Ensure the continued maintenance and enhancement to existing business intelligence solutions

Within user specifications extract, transform and load (ELT) data using the relevant tools

Verify and quality assure of data provided

Provide support to business intelligence users on data-related issues

Skills and Qualifications:

Communication – articulating information and challenging ideas

Analysing and intepreting data

Problem-solving

Relevant IT and data analytics qualifications,

e.g. B.Tech or B.Sc. (Informatics)

The candidate must have practical experience of SQL Server Database Engine (4 years)

The candidate must have practical experience of MS SSIS ETL software (4 years)

The candidate must have practical experience of MS SSAS OLAP software (4 years)

The candidate must have practical experience of MS Visual Studio Data Tools (4 years)

Knowledge of Database Administration would add an advantage

Expert knowledge in configuration of database hardware resources