BI Data Analyst

2 weeks ago

Bellville, Western Cape, South Africa Santam Full time

CAREER OPPORTUNITY
An exciting career opportunity exists for someone to perform a new and critical role within our Business Intelligence department, reporting to the

BCM:
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 environment.

This role will also play a crucial role in the Data Warehouse decommissioning initiative as well as in the cloud migration preparation phase where data analysis work is key.

Additional responsibilities will include sourcing and transforming a wide range of data across the business into formats that can be used by end users or reporting systems.

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 unpacking and analysing data structures in existing databases and ETL processes using SQL, Business Objects and QlikView.

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 and proven proficiency in SQL is a must.

They should be able to communicate technical information to business teams as well as to communicate business information to technical teams.

Thy should also 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.

PRINCIPLE ACCOUNTABILITIES INCLUDE:
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.

Create and maintain dashboards, ongoing reporting, and ad hoc requests from the BCM in measuring data quality and data usage.

Assist Data Modelers/Architects to draw up detailed data models.

Stakeholder Engagement
Work directly with management and other business users to gather requirements, provide status updates, and build relationships
Present information using data visualisation techniques
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 (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)
Functional experience in analytics, data visualisation or reporting
4 + years of experience performing data analysis
Knowledge of and experience with reporting packages (QlikView/ Business Objects/ Cognos)
Adept at queries, report writing and presenting findings for stakeholder use
Experience working with data in various data sources and databases
Demonstrated experience in handling large data sets and relational databases with proven SQL skills
Experience in agile development desired
Business experience in financial services would be advantageous SKILLS
Ability to translate business requirements into non-technical terms
Ability to comply to and manage data assets under strict governance framework
Ability to work with data profiling, data quality and reference data toolsets advantageous
Strong analytical-thinking and problem-solving skills
Ability to collect, organize, analyze, and disseminate significant amounts of information
Attention to detail and accuracy

COMPETENCIES
Collaboration
Client focus
Drives results
Flexibility and adaptability
Cultivates innovation
Decision Quality
Communicates Effectively
Ensures Accountability
Business Insight
Balances Stakeholders
Manages Ambiguity
Nimble Learning ABOUT THE COMPANY

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

  • 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 BI Manager

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    Who are we?The Sanlam Retail Affluent business (SRA) is dedicated to empower South Africans in the middle- and upper-income segments to be financially confident, secure and prosperous. With deep client understanding and a focus on excellence in technology, client and intermediary experiences, SRA delivers financial solutions including comprehensive financial...

  • 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: Digital, Data and Bi

    2 weeks ago

    Bellville, Western Cape, South Africa Sanlam Full time

    **Job Overview The job purpose of a Head of Digital, Data and Business Intelligence is to strategically lead and oversee the organization's digital transformation initiatives. This involves harnessing datadriven insights, implementing advanced analytics, and optimizing business processes to enhance efficiency. The role encompasses shaping a cohesive digital...

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

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

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

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

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

  • Cyber Information Security Analyst I

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

  • Manager: Information Delivery

    2 weeks ago

    Bellville, Western Cape, South Africa Santam Full time

    CAREER OPPORTUNITYThe Purpose of the job is to provide technical guidance for the solutioning of data architecture for the Santam Group.The role is responsible for designing and implementing solutions to increase the performance and quality of new and existing data solutions. In order to build and run Santam's data assets effectively. This leadership role...

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

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

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