Junior Data Analyst

Santam Insurance; Cape Town; On-site; ZAR 180,000 - 300,000; Full time

Job summary

Santam is seeking a Junior Data Analyst to join the Information Management Team in our Shared Services Department at the Cape Town head office. The role focuses on sourcing, transforming, and delivering data-driven insights to support business decisions.

Under guidance from Senior Analysts, you will build reports, dashboards and analytical models, while ensuring data quality and alignment with governance practices. Minimum 1–2 years in data analysis is expected.

Qualifications

• Degree or diploma in information systems, statistics, data science or related field.
• 1–2 years of experience performing data analysis.
• Familiarity with reporting packages and BI tools.
• Ability to translate business requirements into non-technical terms.
• Experience handling large data sets and relational databases with BI tools.

Responsibilities

• Source and transform data across the business into usable formats for insights.
• Create reports and dashboards; own ongoing reporting and ad hoc requests.
• Test outputs, investigate data issues, and devise data-quality solutions.
• Communicate findings to both business and technical teams.
• Collaborate with stakeholders to elicit requirements and define analysis scope.

Skills

Data analysis

Data visualization

Problem solving

Stakeholder communication

Education

Diploma/Bachelor Degree in Information Systems or related

Statistics or Data/Computer Science background

Tools

SQL

Power BI

Job description

Stay safe online.Now more than ever it’s important to be cybersafe. See Santam’s tips to help you stay safe online. Learn more.

An exciting career opportunity exists for someone to perform a new and critical role within our Shared Services Department as a Junior Data Analyst in the Information Management Team.

This is a permenent opportunity based at our Santam Head Office in Tygervalley, Cape Town.

What will you do?

Guided by Senior 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 and create 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.

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.

What will make you successful in this role?

Data Preparation

• 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.)

Stakeholder Engagement

• Work directly with management and other business users to gather requirements, provide status updates, and build relationships
• Facilitate requirements gathering workshops with the business
• Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes

Coaching/Mentorship

• Provides problem solving assistance to other team members

Qualifications and experience

Diploma/Bachelor Degree in Information Systems; Statistics; Data or Computer Science; Engineering or equivalent
Functional experience in analytics, data visualisation or reporting
1-2 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 BI Tools
Ability to comply to and manage data assets under strict governance framework
Experience in agile development desired
Business experience in financial services would be advantageous
Ability to work with data profiling, data quality and reference data toolsets advantageous

Skills and competencies

• Ability to translate business requirements into non-technical terms
• Strong analytical-thinking and problem-solving abilities
• Ability to collect, organize, analyze, and disseminate significant amounts of information
• Attention to detail and accuracy
• Collaboration
• Client focus
• Drives results
• Flexibility and adaptability
• Cultivates innovation
• Decision Quality
• Communicates Effectively
• Ensures Accountability
• Business Insight
• Balances Stakeholders
• Manages Ambiguity
• Nimble Learning

Who we are

Santam is South Africa’s leading general insurer, with a market share of approximately 24% and over 108 years of industry expertise. We provide a comprehensive range of general insurance products and services to individual, commercial and corporate clients across South Africa, Namibia and selected emerging markets through a network of intermediaries, direct channels and strategic partnerships. Our diverse portfolio includes motor, property, liability, engineering, agricultural, guest house, tourism, leisure and entertainment, and reinsurance solutions. We also offer specialised agricultural insurance products, including crop, asset and weather insurance, as well as claims, brokerage and SOS services. Serving more than one million policyholders, our client base ranges from individuals to commercial enterprises, specialist business owners and institutions. Headquartered in Cape Town, South Africa, Santam was founded in 1918 and listed on the JSE in 1964. The Group also holds secondary listings on the Namibian Stock Exchange and A2X Markets Exchange and is a subsidiary of the Sanlam Group, one of Africa’s largest financial services organisations.
Santam Syndicate 1918 is a wholly owned and capitalised entity of Santam, established as a key component of Santam’s international growth strategy. Based in London, the syndicate plays a strategic role in expanding and strengthening Santam’s global footprint through access to London market expertise, distribution networks, and Lloyd’s worldwide insurance and reinsurance licences. Managed and operated from London, Santam Syndicate 1918 is led by a highly experienced leadership team committed to underwriting excellence, disciplined decision-making, and operational accountability. We foster a collaborative and inclusive culture where underwriting, claims, actuarial and other specialist teams work closely together to deliver superior underwriting performance, sustainable growth, and exceptional outcomes for our clients and partners.