The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle- and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive financial planning, life- and disability insurance, credit solutions, savings and investments, retirement and fiduciary services that can be accessed through various platforms.
Role Description
Sanlam Business Intelligence (SBI) is a centre of excellence that delivers data and analytical services within the Sanlam Life and Savings (SLS) cluster. SLS provides clients across different market segments (entry-level, middle-income, affluent, professional market and business owners) with a comprehensive range of appropriate and competitive financial solutions.
These include traditional life insurance risk and savings products, investment, retirement, health, and fiduciary services. Designed to facilitate long-term wealth creation, protection and niche financing, these solutions are engineered around client needs.
For this role, we are looking for an individual with experience in data analysis, data modelling and with a keen passion to build data warehouses. This individual will help mature the existing data warehousing capability while growing their skills and competencies.
This individual will be responsible for the end-to-end tasks within the data analysis framework working with business representatives, product owners, technical teams, etc. to define and elicit requirements, analyse data, building technical solutions and own the enterprise data warehouse model.
What will you do?
Main Responsibilities
Data Modelling
- Define standards and guidelines for various delivery teams to adopt and build out domain specific data models.
- Drive adoption of the enterprise data modelling tool as the central repository of the enterprise vault layer.
- Provide SME guidance and act as coach/ mentor to help workload teams adopt and implement the Data Vault Modelling Technique (DV).
- Chair the Data Vault Analyst Forums to drive alignment of Shared Hubs and consistency across Links and Satellites
- Collate information from various stakeholders and collaboratively design Raw Vault data models using DV.
- Curate and manage the business glossary and metadata to support data discovery and reuse of datasets within the Enterprise Vault Layer.
- Work with developers to review and enable the implementation of vaults of source systems.
- Work with scrum masters and developers to co-ordinate, govern and plan the deployment of vaults across environments.
- Work with analysts and developers to ensure data completeness, consistency, and accuracy through automation (data debugging)
- Build and implement technical solutions to support the above initiatives.
- Writing scripts (SQL, Python, etc.)
- Automate testing solutions.
- Work directly with management and other business users to gather requirements, provide status updates, and build relationships.
- Present information using data modelling techniques.
- Develop and conduct analyst training.
Qualifications
Role Requirements:
- An Appropriate IT Qualification (Diploma/Degree in (statistics/data or computer science/engineering) will be a strong recommendation.
- Practical experience in data modelling, data warehousing, data analysis and data profiling.
- Business or Systems Analyst certification will be advantageous.
- More than 2 years of experience performing data modelling or data warehouse data model build.
- Strong knowledge of and experience with relational databases or Hadoop Distributed File System (preferred), data modelling (Kimball or Data Vault) and querying (SQL).
- Understanding of Business Intelligence and Data Warehousing software development lifecycle.
- Ability to perform well under pressure and manage competing priorities.
- Business experience in financial services an advantage.
- Strong analytical-thinking and problem-solving abilities.
- Excellent written and verbal communication skills.
- Experience working with data in various data sources and databases.
- Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
- Experience working in an agile environment, along with working experience of SharePoint, JIRA, and Confluence.
- Communication skills
- Accountability
- Analytical thinking
- Innovative thinking
- Building and maintaining relationships
- Results driven
- Team success
- Adaptability
- Attention to detail
Interpersonal savvy - Contributing independently
Decision quality - Contributing independently
Optimises work processes - Contributing independently
Plans and aligns - Contributing independently
Build a successful career with us
Were 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 four business clusters Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office the group provides many opportunities for growth and development.
Core Competencies
Being resilient - Contributing independently
Collaborates - Contributing independently
Cultivates innovation - Contributing independently
Customer focus - Contributing independently
Drives results - Contributing independently
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.
Closing Date : 30 September 2023
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.