BI Developer at Salt South Africa

Here’s what you can expect to be doing in the role

Support of Information Delivery production environment

•  Understanding the current product environment and maintaining it
•  Contribute to Standby roster to ensure on-going delivery of current information to the business on time
•  Effectively collecting & sourcing information and then correctly transforming & auditing this information
•  Accurately publishing the information
•  Appropriate resolution of production issues to ensure that information is delivered according to user expectations
•  Continuously identifying and improving processes & procedures to minimise negative impact to data and business reporting
•  Monitoring of the environment to proactively engage in preventative activities and to maintain an environment that is easy to understand and troubleshoot

Deliver data & information (projects, quick wins)

•  Understanding business data and information requirements
•  Delivering data and information to the business in line with business priorities, according to quality standards, within the agreed time constraints and according to departmental coding practice & standards
•  Being involved in the process of populating new data within the Data Warehouse
•  Logical and Physical design of fact and dimensions and transformation processes
•  Taking over information delivery tasks from other areas of the business

User Support

•  Provide support service to users on data and information to satisfy user needs

Qualifications

•  Relevant 3 year IT degree/diploma

Experience & Skills

•  4-5 Years’ DTS experience and have worked with the new SSIS
•  Advanced or expert level in SQL, writing stored procedures and general scripting
•  Experience building and maintaining OLAP cubes in Analysis Services 2005 and 2008
•  Experience in reporting services 2005 and have developed reports
•  Experience of datawarehouse design
•  Test Methodologies
•  Data warehousing skills
•  Retail experience preferred

Salt is acting as an Employment Agency in relation to this vacancy.