Location: Bellville, Western Cape

Who are we?

Sanlam Group Technology and Information (GTI) is responsible for Group-wide Technology and Information Governance, Technology Architecture oversight and guidance as well as the Group’s Cyber Security oversight and governance. GTI is also responsible for IT Shared services to businesses in the Group which is provided through three units namely Infrastructure-, Application- and Security shared services. The shared service business model is based on commercial principles and the foundation of the model is a constant drive for consolidation, standardisation, automation and optimisation. As such, GTI has accountability for the design and implementation of agreed IT controls, governance frameworks, policies, standards and solutions to ensure business continuity and minimise information security risks.

What will you do?
The successful candidate will join the organisation in the role of a Senior BI Analyst. He/she will be part of a highly dynamic and analytical team working in an agile environment. Guided by a BI Technical Lead and Business Analyst, this role will be responsible for sourcing and transforming a wide range of data across our business into formats that can be used by analysts and end-users to develop differentiating business insights.

They will assist in specifying analytical modules using the specified toolsets to enable the analytical teams and businesses to create and analyse complex analytical models. Hence, they need to understand and continuously seek to build knowledge of data and information. In addition, they should be able to use the technology and seek to make use of the features therein to deliver value to the business.

The person fulfilling this role will not only analyse and design data models but also required to investigate data issues, troubleshoot data issues and devise solutions in line with best practice - High competency in problem-solving capabilities is therefore essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to project and operational leadership.

An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance. It is essential that the candidate exhibit and maintain a positive attitude in a highly agile technical and business environment where information forms the foundation to gain a competitive edge in the market.What will make you successful in this role?

The following are the key outcomes expected from this position:
- Analyse business requirements from documents and end-user discussions
- Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.
- Identify and define the security requirements necessary to protect the data items.
- Identify and define the business rules associated with the data; these should include all data integrity/constraint requirements.
- Identify and perform a detailed analysis of all data sources for each application and subject area.
- Perform data profiling of data contained in source systems.
- Provide a detailed analysis of all data implemented in the database.
- Provide the data mapping and associated transformation rules for each data item.
- Ensure that the business requirements and subsequent development activities are supported by accurate information.
- Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-level, integrated, etc.).
- Assist Data Modelers to draw up detailed data models.
Assist ETL Analysts to draw up data cleansing specifications.
- Present data quality anomalies and problem areas to business users and source system owners.
- Validate data models against the business- and data requirements.
- Ensure the quality, accuracy, integrity, and conformity to standards of all models.
- Provide accurate metadata, which allows a full understanding of the project data components.
- Identify data and data model inconsistencies and conflicts and assist the users in their resolution.
- Transition information and assist developers with the data mapping and transformation and provide additional data analysis as required during the development phase.
- Communicate project data-related information to Architects, DBA’s, Developers and Users.

The following areas of expertise are key to the successful delivery of the above outcomes:

- You have a strong data modeling background with the ability to interpret business requirements and analyse source system data and then to document transformation rules for developers to interpret to build the required data models.
- A solid background in SQL, information architecture and ETL procedures is required.
- Experience working on SAP Hana and/or Hadoop is preferred and highly advantageous.
- Data warehousing principles based on Kimball and Data Vault patterns
- Analysis experience in BI
Agile Development
- Knowledge of data profiling and data profiling tools.
- Experience with data quality management strategies and life cycles.
- Ability to comply to and manage reusable data assets under a governance framework
- Solid SQL skills
- Ability to work with data profiling, data quality, and reference data toolsets.
- Ability to do effort estimations

The complexity and variety of the most common challenges and problems:

- Delivering in a complex analytic environment
- Working with a high need for information security
- The diligence required when resolving data and technical issues and interacting with other support teams.
- Demanding business community

Qualification & Experience

Qualifications:
- Degree/diploma/certificate in Information Technology related discipline.
- Matric.

Experience:
- 4+ years' experience as a data analyst in a BI environment.
- A solid background in SQL and information architecture and ETL procedures is required.
- Experience working on SAP Hana, Teradata as well as Hadoop is preferred and highly advantageous.
- Understanding of Data warehousing principles based on Kimball and Data Vault patterns is preferred.

Knowledge and Skills

Data Analysis and MIS reporting
Business analysis
Data Mining
Information Reporting
System Documentation

Personal Attributes

Business insight - Contributing through others
Communicates effectively - Contributing through others
Financial acumen - Contributing through others
Plans and aligns - Contributing through others
Situational adaptability - Contributing through others

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

Being resilient - Contributing through others
Collaborates - Contributing through others
Cultivates innovation - Contributing through others
Customer focus - Contributing through others
Drives results - Contributing through others

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.