Who we are?
Sanlam Investments Group is one of South Africa’s largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.We take particular pride in:
- Sanlam’s longevity and innovation
- People, teamwork and values
- A culture of diversity and commitment to growing our own timber
- Our robust, tested and proven pragmatic investment process and philosophy
Our local and offshore investment products cover the full investment spectrum: active and passive; single and multi-manager – both locally and internationally. Our active funds range are managed according to our pragmatic value investing style. What will you do?
What will you do?
Guided by Senior and Lead Analysts, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights.
We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact.
They will assist in specifying complex business rules using the specified toolsets to enable the Data Modellers to create complex analytical models. Hence, they need to understand and continuously seek to build knowledge of data and information.
The person fulfilling this role will not only analyse data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice. A high competency in problem solving capabilities is thus essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to the team.
The successful candidate will have to demonstrate flexibility across the BI team working on multiple data, digital transformation as well as analytics type of initiatives.
An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance.
You will be responsible for the end-to-end tasks within the data analysis framework working with business representatives, product owners, etc. to define and elicit requirements, analyse data and create reports/dashboards.
Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards
Assess the effectiveness and accuracy of new data sources and data gathering techniques
Extend the company’s data with third party sources of information when required
Process, cleanse and verify the integrity of data used for analysis
Perform data profiling of data contained in source systems
Provide detailed analysis of all data implemented into 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.
Analysis and Visualisation
Interpret data, analyse results using analytical techniques and provide reports and/or dashboards
Identify, analyse, and interpret trends or patterns in complex data sets
Use data to answer key questions about the business.
Own and maintain dashboards, ongoing reporting, and ad hoc requests from the organization.
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.
Work directly with management and other business users to gather requirements, provide status updates, and build relationships
Present information using data visualisation techniques
Facilitate requirements gathering workshops with the business
Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes
Provides problem solving assistance to other team members What will make you successful in this role?
Diploma/Bachelor Degree (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)
Functional experience in analytics, data visualisation or reporting
5 years of experience performing data analysis
Knowledge of and experience with reporting packages
Adept at queries, report writing and presenting findings for stakeholder use
Experience working with data in various data sources and databases
Ability to translate business requirements into non-technical terms
Demonstrated experience in handling large data sets and relational databases with proven SQL skills
Ability to comply to and manage data assets under strict governance framework
Experience in agile development desired
Business experience in financial services or financial asset management would be advantageous
Ability to work with data profiling, data quality and reference data toolsets
Knowledge of various toolsets such as SAP Hana Studio, SAP Data Services, Informatica Data Quality Suite, Cloudera big data storage and Microsoft Power BI will be advantageous.
Proficiency in MS Excel
Qualification and Experience Degree or Diploma with 10 to 12 years related experience. Knowledge and Skills Profile source data and determine all source data and metadata characteristics Advanced analytics to address business requirements Vendor Management Data Warehouse Modeling Statistical analysis and data Personal Attributes Manages complexity - Contributing through others Tech savvy - Contributing through others Plans and aligns - Contributing through others Optimises work processes - 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 Cultivates innovation - Contributing through others Customer focus - Contributing through others Collaborates - 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 ensure 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.