Business Intelligence Developer needed at Sanlam Group

What will you do?

• The purpose of the role is to develop and configure functions and solutions as defined in business requirements raised by the SC Core Operations teams.  
• It is the responsibility of the developer to translate the business requirements into a systems requirement and to then create a SQL-based solutions that will enable the business to then operate efficiently and effectively with the solution.  To this end, an understanding of the Employee Benefits Administration Operations will be beneficial. 
• The developer should be able to design and develop T-SQL queries and stored procedures, design and deploy SQL databases using agreed best practices and have a sound understanding of Warehouse design and development.  
• The developer will be responsible for the creation of custom reports using SSRS by extracting data from multiple sources to enhance the client’s operational productivity. 
• The developer also needs to be able to trouble shoot issues and find effective solutions to problems identified.  It will also be part of their responsibility to test the solution created prior to releasing it for integrated testing, to ensure that the requirements and required standards have been met. 
• The developer should be willing to assist with the training and mentoring junior team members.

Knowledge and Skills

• A minimum of 3 – 5 years’ experience in user-centred design and development environment, preferably in more than one role and organisation

Qualification and Experience

• The incumbent should have these qualifications:  
• Bachelor’s degree in IT, or other related field. 
• Advanced SQL knowledge with a proven track record of delivering solutions to complex problems. 
• Experience of design and development of databases. 
• Ability to optimise queries, indexes, and other performance tuning methods that will result in greater efficiency. 
• Ability to compile clear, concise, and readable specifications and other documents is required. 
• Experience in varied software development methodologies, including Waterfall, AGILE, SCRUM would be beneficial.