Business Intelligence Developer at Sanlam Group

Who are we?

Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as funeral insurance, savings for education, life cover and personal accident plans. In terms of the Sanlam Group Governance Policy, SDM is managed by the SA Retail Mass cluster, which is part of the Sanlam Life and Savings cluster within the Sanlam Group. The cluster focusses on retail porducts, as well as group schemes.

What will you do?

• Responsible for supporting the business with timely Reporting/Dashboard/Scorecard solutions using SQL Server/SSIS/SSRS, MS Excel, SharePoint and similar Business Intelligence tools.
• To support the reporting requirements by way of data extracts, queries, and automating processes/tasks, creating reports, scorecards and dashboards.
• Generate both periodic and ad hoc reports as needed.
• Understands the data, systems and architecture of front end applications and back end data.
• Analysis of data, finding patterns within large complex datasets
• Interface with multiple business users across the organization to gather and understand analytics /reporting requirements
• Build and maintain strong relationships with internal clients, and recommend innovative solutions to business problems
• Perform data validation to ensure that data is correct and meets functional area data specifications.
• Validates the quality of the data, raises incidents, where necessary and works with business specialist to continuously improve on the quality of data.
• Adhere to reporting requirements and standards as stipulated in the service level agreement (SLA)
• Translate data in a way that meets functional area specifications.
• Provide continues improvement on reporting and analytics methods.

What will make you successful in this role?

• Matric
• Relevant tertiary qualification
• Extensive experience with MS SSRS
• Extensive experience with MS SSAS
• Extensive experience with MS T-SQL
• Extensive experience with MS SSIS
• Must have experience in designing Enterprise level BI Solutions using the Microsoft stack.
• Must have experience in designing Self Service BI Solutions.
• SAP Hana modelling will be advantageous
• Must have real world experience with designing and implementing predictive & descriptive analytical models.

Qualification and Experience

• Degree with 10 years related experience.

Knowledge and Skills

• IT Data Analysis
• Project Oversight
• Reporting and Administration
• Quality, Compliance and Accreditation
• Business Requirements Definition
• Technologies