Senior BI Developer

Date: 10-Jun-2019

Location: Johannesburg, Gauteng, South Africa

Company: Sanlam Group

Who are we?

Sanlam is one of the leading financial services providers in the South African entry-level market. We’re in the business of planning for tomorrow. The never-ending pursuit of meticulously crafting our clients’ futures. We do this by truly appreciating the value of money and turning the materials we’re given into something more.  It’s our trade and it is something we are passionate about. It’s what makes us Wealthsmiths™. 

As Wealthsmiths™ we believe in creating and cultivating a positive, energised working environment that gives you every opportunity to achieve success. Sanlam is committed to transformation and embracing diversity. This commitment is what drives us to achieve a diverse workplace with employment equity as a key goal to create an inclusive workforce, representative of the demographics of our society as well as people with disabilities.


Sanlam Values

The ability to demonstrate, understanding and apply our Sanlam values is embedded in all roles.  Applicants must exhibit their commitment to the values as part of the application process.

  • Lead with courage
  • Serve with pride
  • Care because we respect each other
  • Act with integrity & accountability
  • Grow value through innovation & superior performance
What will you do?

Enabling business

  • 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.
  • Identify and drive the translation of Adhoc reports to automatic dashboard based reports
  • Understands the data, systems and architecture of front end applications and back end data.


  • 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

Improving the quality of data and report output

  • Test planning and execution.
  • Performs 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.
  • Adheres to reporting requirements and standards as stipulated in the service level agreement (SLA)

Must be innovative

  • Translates data in a way that meets functional area specifications.
  • Provide continues improvement on reporting and analytics methods.

System Documentation

  • Create and update documentation for the entire BI environment
What will make you successful in this role?
  • Matric
  • Relevant tertiary qualification
  • Minimum 8 years extensive working experience in a BI Environment
  • Extensive experience with SSRS, SSAS, T-SQL and SSIS.
  • Minimum 6 years extensive Database design (OLTP and Data warehouse)
  • 6 Years dimensional modelling working experience
Qualification and Experience
Degree or Diploma with 6 to 8 years related experience.
Knowledge and Skills
Netcentric Application Environment design
Reporting and administration
Quality, Compliance and Accreditation
Business Requirements definition
Web technologies
Personal Attributes
Interpersonal savvy - Stage 2
Decision quality - Stage 2
Action orientated - Stage 2
Optimises work processes - Stage 2
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 business clusters – Sanlam Personal Finance, Sanlam Emerging Markets, Sanlam Investments, Sanlam Corporate, Santam, Miway, as well as the Group Office – the group provides many opportunities for growth and development.

Core Competencies
Cultivates innovation - Stage 2
Customer focus - Stage 2
Drives results - Stage 2
Collaborates - Stage 2
Being resilient - Stage 2
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. 

Our commitment to transformation

The Sanlam Group is committed to achieving transformation and embraces diversity.  This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensuring a thriving and sustainable business in South Africa.  The Group's Employment Equity plan and targets will be considered as part of the selection process.

Find similar jobs: