Job Openings at Sanlam

What will make you successful in this role:
The following are the key outcomes expected from this position:

• Delivering the required services as per the service catalogue of the team.
• Coordinate service requests with security and infrastructure teams when required.
• Load large, complex data sets to and make data available for data engineers.
• Source data from internal and external data sources, engaging with technical subject matter experts.
• Build the infrastructure required for optimal Extraction, Transformation, and Loading (ETL) of data from a wide variety of data sources using various ‘big data’ technologies.
• Help build the platform for a better data supply chain for advanced analytics that goes from experimentation into production.
• Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, re-designing models for greater scalability.
• Engage with a wide range of technical stakeholders including data scientists, business analysts, data engineers, and solutions architects.
• Work with data analysts and data engineers to understand the dynamic nature that is required to support the solution that needs to be built.
• Support data stewards to establish and enforce guidelines for data collection, quality improvements, integration, and processes.
   

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

• A solid background in SQL, information architecture and ETL procedures is required.
• Experience working on SAP Data Services, Sap Hana and/or Hadoop is preferred and highly advantageous.
• Previous scripting language experience e.g. Unix Shell scripting.
• Agile Development.
• Ability to comply with and manage reusable data assets under a governance framework.
• Advanced SQL skills.
• Ability to do effort estimations.
• Extensive working knowledge and experience in development methodologies.
• The ability to configure and build solutions in various ETL toolsets would be advantageous.
• Ability to build ETL solutions in a Hadoop environment.
   

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.
   

How the job will typically impact the business and where the impact will be felt.

• Information is an asset and it can be used strategically to gain a competitive edge in the market.
• Timely delivery required - information is key to business decisions
• Accurate delivery required - information is key to business decisions
• Access to information - information is key to business decisions
   

Qualifications
Qualification & Experience

• National Diploma in an Information Technology related discipline.
• Matric
   

Experience

• 5+ years' experience as a data engineer in a BI environment
• A strong data engineering background with a specific focus on staging high quality data.
• A solid background in SQL, information architecture and ETL procedures is required.
• Experience working on SAP Hana, Teradata as well as Hadoop is preferred and highly advantageous.
• Experience with object-oriented/object functional scripting languages: Python, Java, Scala or related is preferred but not essential.
• Understanding of Data warehousing principles based on Kimball and Data Vault patterns is preferred.
• Development using SQL and procedural extensions is required.
  
   

Knowledge And Skills

• Development of data warehousing blueprints.
• Data warehouse management
• Translates business needs into long-term architecture solutions
• Defines, designs and builds dimensional databases
• Object and data models

go to method of application »

What you will do:

The Data Platform SME on the Sanlam Group BI and Analytics program (BI) is responsible for the technical feasibility and vitality of the core data management technologies in the platform. Your primary focus will be on the Data Lake technologies used - Cloudera / Hadoop and Teradata. You need to make sure these technologies are properly installed, configured, maintained and integrated into the Sanlam technology landscape.

You also need to make sure integrated technologies used in tandem with Cloudera and Teradata are properly set up to enable the efficient use of the Data Lake. These technologies currently include SAP HANA, Attunity Replicate and Compose, SAP Data Services, SAS Enterprise Miner, IBM Data Stage, RStudio and Jupyter, but the list keeps expanding. You need to work with the technical experts supporting these tools to build a robust ecosystem that supports Sanlam’s BI and Analytical needs. Support developers interacting with the platforms in troubleshooting, performance tuning, and application design.

You will take guidance from the GBI and GTI architecture teams in creating detailed technical designs to run a successful Data Lake. Ensure the platform meets the SLA required by the business in terms of high availability, failover, and disaster recovery. Ensure the platform integrates into the required supporting group technology platforms, such as identity and access management systems. Assist the operational support teams by building robust monitoring and support processes for the running of the platform by enabling the required reporting functionality and data feeds. Remain aware of the impact of any designs on the cost-efficiency of the platform.
In order to succeed in this role you will need knowledge of:

• Linux
• Hadoop / Cloudera
• Data warehouse systems
• Data System management (monitoring / backup / recovery)
• Identity and access management technologies (LDAP / Kerberos / SAML / IBM IAM products)
• Network configuration
• Distributed system
• Scripting: bash/Python
   

You will need to stay abreast of the latest developments in the industry to ensure Sanlam’s Data Lake technology platform remains viable.

What will make you successful in this role:
The following are the key outcomes expected from this role:

• The planning, designing and building of the IT infrastructure and technology architecture to support the Group BI and Analytics program (BI). This includes computer hardware, server hardware, storage and backup, operating systems, utilities software and data storage / management software as well as integration between the components of the platform.
• The specification, product selection and design of infrastructure components to implement a systems architecture.
• The identification of new and emerging software technologies, methodologies and products, and ICT methods and techniques and the ongoing assessment of their relevance and potential value to the organisation.
• Applying mainly Development Management Technologies and methodologies, such as Application Life Cycle Management (ALM) e.g. Agile, Waterfall or other pattern, practices, and development frameworks.
• Utilising mainly a combination of relevant Architecture Models such as Technology, Data, Access, Identity, Security Management Models and Change Management Models.
• Acts as the technical subject matter expert (SME) in the BI Platform technical domain by providing solutions and advice to business across multiple complex problem sets.
• Manages and controls the technical IT domain solution in both project and production support environments.
• Provides a service that combines all the elements of consultancy, facilitation and implementation, thus providing an end-to-end enablement and implementation service.
• Participates in the planning, development and implementation of the IT Domain projects and enhancements.
• Monitors projects throughout all phases to ensure compliance to design standards.
   

The following areas of expertise are key to the successful delivery of the above outcomes:
Logical access principles for databases / data platforms

• SAP HANA,
• Qlik formerly Attunity Replicate and Compose,
• SAP Data Services
• SAS Enterprise Miner
• IBM Data Stage
• RStudio & Jupyter

Ancillary technologies (used in BI platform)

• Linux
• Hadoop/ Cloudera
• Data warehouse systems
• Data System management (monitoring / backup / recovery)
• Identity and access management technologies (LDAP / Kerberos / SAML / IBM IAM products)
• Network configuration
• Distributed systems
• Scripting: bash/Python
   

Qualifications
Qualification & Experience

• Degree/diploma/certificate in Information Technology related discipline.
• Matric.
   

Experience

• 5+ years related experience
• Extensive working knowledge and experience in Databases/Data platforms
• Experience working with Hadoop is preferred and highly advantageous.
   

Knowledge And Skills

• Strategic data management
• Requirement planning and feasibility studies
• Business Requirements Definition
• New technologies in hardware and software
• Development methodologies

Personal Attributes

• Organisational savvy - Contributing through others
• Manages complexity - Contributing through others
• Strategic mindset - Contributing through others
• Tech savvy - Contributing through others

go to method of application »

What you will 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
  
   

Qualifications
Qualification & Experience

• 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