Data Analyst

2 weeks ago


Bellville, South Africa Sanlam Full time

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. Sanlam Collective Investments (SCI)

Sanlam Collective Investments (South Africa) was established in 1967 as a full Sanlam subsidiary. Sanlam Collective Investments manages funds of about R215 billion on behalf of more than 238 000 investors. Other renowned financial services companies have also partnered with us to offer third-party funds. In these cases, the third-party funds are distributed and promoted by the respective financial services companies, whereas Sanlam Collective Investments is responsible for the client administration and compliance About the position?

The data stream at Sanlam Collective Investments requires a Data Analyst with ETL and reporting skills to compliment the existing Data stream. The Data stream is responsible for data quality, data integrity, security, audit information and producing exception reports and to produce tools and dashboards, both operational and on tabular models. The data stream also signs off on the architectural design and integration into other platforms within the business and provides input into groupwide data excellence programs.
The Data Analyst will identify opportunities for improvement in data quality and integrity and build health check and exception reports supporting specific business questions and strategies. The data analyst with be expected to write complex data queries to investigate and solve business queries and suggest and build long-term solutions to ensure better data integrity and processes over time.
The role will include occasional after-hours work.
Key responsibilities
Perform data analyses on data to support specific data questions and provide either once off or scheduled reports to business to improve processes. Identify data integrity and quality gaps and propose solutions Ensure adequate controls are built into business processes to ensure data integrity over time Investigate and resolve data issues logged and raised via the support team within agreed timeframes Closely working with business teams, development team, vendors and testers to ensure requirements are delivered in an expected format Supporting the business with regards to business and process improvements Provides inputs into training manuals and assists with transfer of knowledge to end users and trainers Facilitation of meetings, workshops, etc. to gather information Working with key service providers to ensure business requirements, business rules and controls are documented and signed off Translate business requirements into solutions Ensure appropriate documentation is created and maintained Ability to perform process mapping and design Provide input into test plans and test cases Behavioural competencies:
Meticulous attention to detail, with a commitment to follow through and follow-up Willingness to learn and share knowledge Ability to work independently and shows initiative Time management and organizational skills Resilience and the ability to adapt well under stress Ability to be an effective team player and proactive individual Must be able to communicate effectively with technical and non-technical audiences and interact with all types of clients including technology, business, management and executive management Analytical, innovative and demonstrates initiative Good communication skills both written and verbal Good interpersonal and facilitation skills Ability to collaborate and pull information together

**Technical competencies**:
Good understanding of the software development lifecycle, both waterfall and agile Solid SQL knowledge Solid knowledge of SSRS, SSMS and SSIS Strong Excel knowledge using excel formulas Knowledge of Power BI Advantageous: knowledge of ETL and working with tabular models using Dax (will be developed) Experience working within a fast-paced and dynamic business environment (advantageous) Ability to transfer knowledge to users, trainers and peers Ability to package and present analysis with recommendations to management and executive teams Strong facilitation skills for meetings, workshops and forums Minimum requirements:
Matric and relevant tertiary qualification Experience in data analyses and BI tools relevant (SQL) Minimum of 2 - 3 years’ experience in a data analyst,



  • Bellville, South Africa Sanlam Full time

    The Role - We are seeking to hire a Data Operations Analyst on a full-time basis, to be located at the Tygervally/Bellville office in Cape Town reporting to the Data Operations Manager. **What will you do?** - The Data Operation Analyst will be responsible for managing and optimizing data processes to ensure the accuracy, integrity, and availability of data...

  • Head of Data Analyst

    2 weeks ago


    Bellville, South Africa Sanlam Full time

    Who are we?- Sanlam Fintech is a newly established digital first business within the Sanlam Group on a mission to democratise financial advice and solutions for everyone across the African continent. We exist to pioneer inclusive financial confidence helping people build strong foundations to bridge the gap in generational wealth. Our culture is that of...


  • Bellville, Western Cape, South Africa University of the Western Cape Full time

    Job Description:The University of the Western Cape invites applications for a Business Intelligence Data Analyst position in the Institutional Planning Department. This role involves utilising business intelligence and statistical tools to conduct research and analyse institutional data.The successful candidate will be responsible for:Data analysis, report...

  • Data Analyst

    2 weeks ago


    Bellville, South Africa PSG Wealth Distribution Full time

    Data Analyst Company industry: Financial Services Job location: Bellville Career level: Junior Employment status: Full Time Qualification: Diploma Years of experience: 2-3 years Job description: **Responsibilities**: - Source, analyse, implement, and support the product and client data in our central CRM system - Perform regular testing on the data...


  • Bellville, Western Cape, South Africa Sanlam Limited Full time

    The Intelligent Data Analyst will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Analyze and interpret large datasets to identify trends, patterns, and correlations.Develop and maintain reports, dashboards, and other analytical tools to support business needs.Collaborate with stakeholders to...


  • Bellville, Western Cape, South Africa Pepkor Speciality Full time

    Human Resources Information and Data AnalystJoin to apply for the Human Resources Information and Data Analyst role at Pepkor Speciality. Pepkor Speciality is excited to announce an excellent opportunity within our HR team for a skilled and motivated Human Resource Information and Data (HRIS) Analyst. As a key member of the team, your expertise will be...

  • Data Analyst

    6 days ago


    Bellville, South Africa Santam Full time

    What will you do? Santam’s Actuarial and Data Analytics team has an exciting new opportunity available for a data analyst. The position can be based Tygervalley, Bellville. What will make you successful in this role? **KEY ACCOUNTABILITIES**: Supporting the development of data-driven predictive and prescriptive modelling Support and enhance the existing...

  • SQL Data Analyst

    2 weeks ago


    Bellville, Western Cape, South Africa QE Services IT Recruitment Full time

    Job OpportunityWe are currently looking for a talented SQL Data Analyst to join our team at QE Services IT Recruitment.About the PositionThis role involves working on data analysis, report writing, and data visualization using Microsoft BI tools.Key Responsibilities:Analyze complex data sets to provide insights and recommendationsDevelop reports and...


  • Bellville, South Africa Progressive IT Resourcing Full time

    Are you analytically minded, curious and enthusiastic about data? Passionate about finding insights in datasets, with the ability to synthesise and clearly communicate the results and drive business impact? We are looking for an individual with experience in data analysis, data modelling and with a keen passion to build data warehouses. If you believe you...


  • Bellville, Western Cape, South Africa Talent Match Consulting Full time

    About the Role:Actuarial Analyst with Pricing ExperienceWe are seeking a highly skilled Actuarial Analyst with Pricing experience to join our team at Talent Match Consulting.Key Responsibilities:To provide support on all actuarial disciplines in the short term insurance spaceTo perform data collection, management and reporting tasksTo conduct experienced...


  • Bellville, Western Cape, South Africa Sanlam Full time

    Data Analyst: Digital GrowthDate: 10 Apr 2025Location: Bellville, Western Cape, ZACompany: Sanlam GroupWho are we?Sanlam is a leading financial services group, recognized for our innovative approach towards providing comprehensive insurance, investment, health, and credit solutions to millions of clients across Africa. Now, we're on a mission to digitize...


  • Bellville, Western Cape, South Africa University of the Western Cape Full time

    Business Intelligence Data Analyst - (1945)University of the Western Cape -> Rectorate -> Institutional PlanningType of Position: Permanent - Full TimeClosing Date: 23/2/2025Role Clarification & Key Performance AreasThe University of the Western Cape (UWC) is a vibrant, diverse and dynamic university, rooted in the African continent with an increasingly...


  • Bellville, Western Cape, South Africa UWC Online - University of the Western Cape Full time

    We are seeking a Data Analyst Lecturer to join our Statistics and Population Studies Department in the Faculty of Natural Sciences. The successful candidate will contribute to the development of our department and provide academic leadership.Responsibilities include facilitating learning at undergraduate and postgraduate levels, conducting research,...


  • Bellville, Western Cape, South Africa Sanlam Limited Full time

    Sanlam is a leading financial services group, recognized for our innovative approach towards providing comprehensive insurance, investment, health, and credit solutions to millions of clients across Africa. Now, we're on a mission to digitize new and existing business models and activate them to acquire digital-first customer segments that have historically...


  • Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam is a leading financial services group, recognized for our innovative approach towards providing comprehensive insurance, investment, health, and credit solutions to millions of clients across Africa. Now, we're on a mission to digitize new and existing business models and activate them to acquire digital-first customer segments that have...


  • Bellville, Western Cape, South Africa Sanlam Full time

    About the RoleWe are seeking a highly skilled Data Scientist and Business Analyst to join our team at Santam. As a Data Scientist and Business Analyst, you will be responsible for leveraging statistical analysis, machine learning, and data modelling to drive business value.Key Responsibilities:Involvement in engagement with stakeholders to understand their...

  • BI Data Analyst

    4 weeks ago


    Bellville, South Africa Sanlam Full time

    **CAREER OPPORTUNITY** - Santam has a career opportunity for a Data Analyst in the B.I.T.S. environment who will be based in Bellville, Cape Town.**JOB DESCRIPTION** - Guided by the Data Management Lead, 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...

  • BI Data Analyst

    2 days ago


    Bellville, South Africa Sanlam Full time

    **CAREER OPPORTUNITY** - Santam has a career opportunity for a Data Analyst in the B.I.T.S. environment who will be based in Bellville, Cape Town.**JOB DESCRIPTION** - Guided by the Data Management Lead, 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...

  • Underwriting Analyst

    2 weeks ago


    Bellville, South Africa Santam Full time

    CAREER OPPORTUNITY We have a position available for an Underwriting Analyst who will be based in Cape Town (Head Office) in our Underwriting and Reinsurance (Personal Lines Underwriting) department. The purpose of the role is to support Personal Lines Underwriting & Commercial & Personal Lines (C&P) with: Performance analysis of data and identification of...


  • Bellville, South Africa Pepkor Speciality Full time

    Pepkor Speciality is excited to announce an excellent opportunity within our HR team for a skilled and motivated Human Resource Information and Data (HRIS) Analyst. As a key member of the team, your expertise will be instrumental in processing employee data, generating essential HR reports, managing system integrations, and upholding the integrity of our...