Senior Business Intelligence Developer at Sanlam Group

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.
  • Understands the data, systems and architecture of front end applications and back end data.
  • Analysis of data, finding patterns within large complex datasets
• Communication
  • 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?

Qualifications

• Matric
• Relevant tertiary qualification

Experience & Knowledge

• Minimum 10 years extensive working experience in a BI Environment
• Extensive experience with MS SSRS
• Extensive experience with MS SSAS
• Extensive experience with MS T-SQL
• Extensive experience with MS SSIS
• Experience with Power BI is required
• Minimum 8 years extensive Database design (OLTP and Data warehouse)
• 8 Years dimensional modelling working experience
• 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 or Diploma with 10 to 12 years related experience.

Knowledge And Skills

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