Now hiring

Business Analyst-Data Engineer (Cape Town, Western Cape, ZA) @ Sanlam Life Insurance Limited

Cape Town, Western Cape, ZAOnsiteFull-time
Apply with ResuMinder

Opens on the employer's site

About this role

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.

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

Requirements

Elicitation and Facilitation - Fully Competent Works with full competence to lead facilitated sessions for requirements elicitation, focus groups, and user acceptance testing. 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. 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.

Skills

SQLPower BIMicrosoft 365AgileScrumAzure DevOpsJiraETLData ModelingData WarehousingAPIPython

Ready to apply?

Install the ResuMinder extension and we'll auto-fill the application in seconds — no rewriting.

See how your CV scores