Job description

The ideal candidate for this role will be responsible to support, enhance and optimise the current data warehouse environment by extracting, transforming and loading data from various sources using TSQL and SSIS and will develop and enhance reporting and analytical capabilities/solutions, using SSRS, Power-BI and SSAS, delivering projects that support the business’ requirements in an agile manner.

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

• Interpret and understand business data and information requirements as per technical specifications
• Deliver 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 as well as user expectations 
• Be involved in the process of populating new data within the Data Warehouse
• Understand and offer support to the current production environment and relevant processes  
• Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published
• Ensure efficient and effective resolution of production issues
• Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot
• Recurring standby to support and resolve operational issues encountered in the day to day operations of the data warehouse production environment
• Provide support service to users on data and information to satisfy user needs

Requirements

A little about who you are

• Relevant three-year IT degree/diploma
• A minimum of five years’ data warehousing experience with a working understanding of dimensional modelling
• At least five years’ experience in ETL processes using SSIS
• Intermediate to Advanced skill level in using MS-SQL/T-SQL
• Intermediate to Advanced skill level in developing reports using SSRS
• Experience in building and maintaining Tabular Cubes (DAX) using SSAS will be an added advantage
• Exposure to Self-Service BI using Power-BI will be an added advantage
• Exposure in using TFS or SVN will be an added advantage
• Exposure in working within an agile project environment will be an added advantage

Benefits 

• Flexible benefits to structure your own package
• Creative agile work environment
• Flexible working hours
• Café and lounge area
• Staff restaurant with a variety of healthy meal options

Posted on 27 Jun 09:37