Data Analyst

2 weeks ago

Bellville, Western Cape, 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 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 - 3 years' experience in a data analyst,

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Scholtz Partners International (Pty) Ltd Full time

    To bridge business needs and technical solutions in Data Warehousing by understanding requirements. analysing data sources, collaborating with stakeholders, and ensuring effective design development, and maintenance,. Serve as liason between business users and technical teams to align data warehouse solutions with organizational objectives.Requirements:...

  • Head of Data Analyst

    2 weeks ago

    Bellville, Western Cape, 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...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, 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 modellingSupport and enhance the existing...

  • Data Warehouse Business Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Scholtz Partners International Pty Ltd Full time

    Job Title: Data Warehouse Business AnalystSalary: R R55 000Address: Bellville, Western CapeDescription: To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analyzing data sources, and collaborating with stakeholders to ensure...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed HR Full time

    We are currently looking for a professionally skilled Data Analyst to be part of a dedicated team in driving actionable insights within our client, who is a leading FMCG player within the Bellville area.The role you will play is crucial in ensuring that the client receives a service offering that enables them to make strategic decisions...

  • Sbi Jnr Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides strategic...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Recruitment and Human Resource Consultants Full time

    Reference:9375 RLConsultant:Rozel Liebenberg Analyse data and provide the Management and Sales Teams with insights to drive sustainable category growth. Work closely with service providers to ensure accurate business enhancing tools and information. Together with the Sales and Marketing Teams, develop category strategies aligned to the business objectives,...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Recruitment and Human Resource Consultants Full time

    Reference: CC 7576Consultant: Charné CoetzeeDescriptions:Data AnalysisCombine information from different sources to provide the business with category insightsSales and Category Reviews/Deep divesInternal and External Category reviewsAd hoc analysis and review requests from the company, including commercial argumentsCategory retailer reviews for TOP...

  • Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Exceed Hr Full time

    Reference: CC 7576Consultant: Charné CoetzeeDescriptions: Data Analysis Combine information from different sources to provide the business with category insights Sales and Category Reviews/Deep dives Internal and External Category reviews Ad hoc analysis and review requests from the company, including commercial arguments Category retailer reviews for TOP...

  • BI Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    CAREER OPPORTUNITYAn exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to theBCM:Information Management. Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the BI...

  • BI Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    CAREER OPPORTUNITYAn exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to theBCM:Information Management. Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the BI...

  • Sbi Data Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Life and Savings (SLS) is focused on serving our retail and corporate clients in South Africa and further developing our strategic advantages in the South African market. Sanlam Life and Savings consists of three clusters - Sanlam Corporate, Sanlam Retail Mass and Sanlam Retail Affluent. The Sanlam Life and Savings Office provides strategic...

  • Business Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa HR Genie Full time

    Position: Business Analyst at TwizzaLocation: City of Cape Town, Cape Town, BellvilleEmployment Type: Permanent, Full-TimePrimary Sector: IT and InternetSecondary Sector: FMCGQualifications: Industrial Engineering Degree, Dynamics NAV, Advanced ExcelSkills: User acceptance testing, JAD sessions, Project Management, Change ManagementCompany Description:...

  • Data Analyst: Retail Credit

    2 weeks ago

    Bellville, Western Cape, 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 democratize 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 us that of...

  • Junior Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Cipla Full time

    Department:Supply Chain-PlanningEmployment Type:PermanentJob Purpose:To create and lead the transformation agenda and best in class supply chain practices for the Function by optimising processes through automation & technology adoption, capability enhancement, institutionalization of best practices to improve performance, profitability, increased cost...

  • Portfolio Intelligence Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...

  • Head: Data Science

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    About Sanlam & SFTSanlam 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. Sanlam Fintech is a newly established digital first business within the Sanlam Group on a mission to democratize financial advice and...

  • Data & Digital Academy 2025

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology...

  • Application Support Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Parvana Strategic Sourcing Full time

    Client Details:Our client is a well-established and highly regarded South African software development company that develops, supports and consults software solutions for the academic sector. With offices in Jhb and Cape Town, they are progressive with regard to their technology stack. Their solutions and services span the full range of the software...

  • Application Support Analyst

    2 weeks ago

    Bellville, Western Cape, South Africa Momentum Life Full time

    IntroductionThrough our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations.Role PurposeRequirements: Relevant Bdegree or...