Job Description

Business Analyst-Data Engineer

Posting Start Date:  20/11/2026
Job Location:  South Africa

About Sanlam Corporate

About Sanlam Corporate Sanlam Corporate forms part of the Sanlam Life and Savings (SLS) business cluster within the Sanlam Group. We partner with employers, retirement funds and intermediaries across South Africa to strengthen financial confidence through clear advice, responsible decision-making and sustainable long-term value. Our integrated retirement, investment, group risk, healthcare, consulting and advice solutions support financial resilience and wellbeing.   Our ambition is to be the trusted partner for digitally enabled financial wellness by 2030, encompassing retirement, health, investments and group risk, complemented by rewards and banking. Combining specialist expertise and innovation with exceptional client and member experiences, we deliver lasting value to organisations and their people. Underpinned by integrity, care, collaboration and innovation, our culture supports professional growth, the development of future-ready capabilities and meaningful contribution.

Purpose of the Role

The Business Analyst will act as the bridge between Employee Benefits, Group Risk, Data Engineering and technology stakeholders, translating business requirements into clear data, reporting and integration requirements.

The role will support strategic projects, BAU initiatives, regulatory and audit requirements, data migrations, reporting solutions and modernisation initiatives. The BA will work closely with Data Engineers, SQL/ETL Developers, Solution Architects, Product Owners, business stakeholders and support teams to ensure requirements are clearly understood, traceable and successfully implemented

Key Responsibilities

1. Business Analysis & Requirements

  • Engage stakeholders to understand business needs and challenges.
  • Facilitate requirement-gathering workshops and define solutions.
  • Document business, functional, technical and data requirements.
  • Create user stories, acceptance criteria and process documentation.
  • Conduct impact and gap analysis.
  • Ensure requirements traceability through development, testing and implementation.

2. Data Analysis

  • Use SQL to analyse, validate and investigate data.
  • Perform data mapping and source-to-target analysis.
  • Understand data relationships, business rules and transformations.
  • Investigate data quality issues and support root-cause analysis.
  • Define validation, reconciliation, migration and consolidation requirements.

3. Data Engineering & Integration

  • Collaborate with technical teams on data warehouses, ETL/ELT processes, APIs, integrations and cloud platforms.
  • Support reporting datasets, legacy-system modernisation, data migration and quality controls.
  • Understand data flows from source systems through transformation layers into downstream reporting solutions.

4. Employee Benefits & Group Risk

Support initiatives relating to:

  • Employee Benefits administration and Group Risk products.
  • Member, policy, claims, client and intermediary data.
  • Financial, operational and regulatory reporting.
  • Data reconciliation, controls and digital solutions.

Experience in Employee Benefits, Group Risk, retirement funds, insurance or financial services is highly advantageous.

5. Reporting & Power BI

  • Define reporting requirements, KPIs and business measures.
  • Support Power BI dashboards, reports and datasets.
  • Assist with report migration and rationalisation.
  • Validate reporting outputs against source data.

6. AI & Automation

  • Identify opportunities to improve efficiency through AI and automation.
  • Use approved AI tools for requirements analysis, documentation and data investigations.
  • Support AI-enabled initiatives while ensuring strong data governance, quality and security.

7. Testing & Implementation

  • Develop acceptance criteria, test scenarios and business validation plans.
  • Support SIT and UAT testing.
  • Manage defect clarification between business and technical teams.
  • Support implementation and post-deployment validation.

8. Governance & Documentation

Maintain documentation including:

  • Business requirements and functional specifications.
  • User stories, process flows and business rules.
  • Data mappings and source-to-target mappings.
  • Data quality rules, integration requirements and test scenarios.
  • Data dictionaries and operational support documentation.

Technical Skills

Essential

  • SQL and relational data analysis.
  • Microsoft Power BI.
  • Microsoft 365 ecosystem (Excel, PowerPoint, Word, Teams).
  • Data analysis, profiling and mapping.
  • Requirements elicitation and documentation.
  • Process modelling.
  • User stories and acceptance criteria.
  • Agile/Scrum delivery methods.
  • Azure DevOps.

Advantageous

  • Azure or AWS data technologies.
  • Snowflake.
  • ETL/ELT tools and concepts.
  • Data warehousing and data modelling.
  • REST APIs, JSON and XML.
  • Jira or Azure DevOps.
  • Cloud data platforms.
  • Generative AI / Microsoft Copilot.
  • Basic Python knowledge.
  • Financial services data environments.

Qualifications

  • Minimum:

    • Relevant bachelor's degree, diploma or equivalent experience in Business Analysis, Information Systems, Computer Science, Data, Finance or a related discipline.
    • Approximately 3+ years' Business Analysis experience, preferably working with data or technology solutions.

    BA certification advantageous, for example:

    • IIBA ECBA, CCBA or CBAP
    • PMI-PBA
    • Relevant Business Analysis diploma/certificate

    Experience within Employee Benefits, Group Risk, insurance or financial services would be advantageous.

Overview of Role Responsibilities (Level 1-13)

Data Collection and Analysis- Level 5 - Application
Collate and analyze data using preset tools, methods, and formats. Involves working independently.

Analysis of "As Is" and "To Be"- Level 5 - Application
Support and contribute to the documentation of "as is" and "to be" processes and describe the changes required to migrate to the "to be" capability to record accurately the change required.

Feasibility Studies- Level 5 - Application
Contribute to and support feasibility studies from a technological and organizational perspective, and document findings.

Business Requirements Identification- Level 5 - Application
Support collection of business requirements using a variety of methods, such as interviews, document analysis, and workflow analysis, to express requirements clearly and succinctly.

Business Case- Level 5 - Application
Carry out feasibility and assessment work for proposed and current projects to contribute to the development and continuous review of business cases.

Required Skills

Data Collection and Analysis - Fully Competent
Works with full competence to determine and analyze trends from data that is collected to assist in compiling reports that will help in decision-making. Typically works without supervision and may provide technical guidance.

Perform Gap Analysis - Fully Competent
Works with full competence to conduct gap analysis between current and future states to identify components of the overall change strategy. Typically works without supervision and may provide technical guidance.

Requirements Creation and Verification - Fully Competent
Works with full competence to create the rules for requirements and design quality, perform verification activities, and maintain quality control. Typically works without supervision and may provide technical guidance.

Analyze Current State/AS-IS State - Fully Competent
Works with full competence to understand business context, needs, rules, and architecture, as well as organizational structure, cultures, capabilities, and processes to document the current state of processes and the business. Typically works without supervision and may provide technical guidance.

Requirements Elicitation and Facilitation - Fully Competent
Works with full competence to lead facilitated sessions for requirements elicitation, focus groups, and user acceptance testing. Typically works without supervision and may provide technical guidance.

Business Requirements Analysis - Fully Competent
Works with full competence to express user needs in terms of business requirements, identify current capability of the business to deliver, conduct build or buy analyses, and recommend preferred approach. Typically works without supervision and may provide technical guidance.

Education

Degree

Required Behavioural Competencies

Manages Complexity
Optimises Work Processes
Ensures Accountability
Plans and Aligns
Action Oriented
Business Insight

Turnaround Time

The shortlisting process will only start once the application due date has been reached. The closing date for this advert is 25 November 2026

Our Commitment to Transformation

The Sanlam Group is committed to transformation and embracing diversity and our employment equity plan and targets will be considered as part of the recruitment process. This commitment is what drives us to achieve a diverse workplace with employment equity as a key goal to create an inclusive workforce, representative of the demographics of our society as well as people with disabilities.