Business Intelligence Developer - Cape Town, South Africa - Sanlam
Description
Build a successful career with us
We're all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.
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.
Behavioural Competencies
Responsible with a high level of accountability
Excellent interpersonal and communication (written and verbal) skills
Client focus
Professional profile
Effective time management skills
Process orientated
Self-motivated with a strong focus on delivery
Conceptual thinking skills
Must be able to work under pressure, Individually or as member or a team
Team player
Innovative thinker with good problem-solving skills
Flexible
Able to adapt to change
Turnaround time
The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.