450 Sql Analyst jobs in South Africa

Stay vigilant. Santam has been made aware of a malicious e-mail instructing policyholders to claim a refund within 24-72 hours. This is a scam, Santam will only communicate through their broker or official channels. Learn more.

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

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.
• 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.).
• 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.
• Facilitate requirements gathering workshops with the business.
• Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes.
• Engage with role-players within our implementation of Scrum @ Scale.

Coaching/Mentorship

• Provides problem solving assistance to other team members.

• 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 QlikView and Qlik Sense reporting packages.
• Knowledge of Business Objects and Cognos – advantageous.
• 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.
• Business experience in financial services would be advantageous.

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

• Client focus.
• Drives results.
• Flexibility and adaptability.
• Cultivates innovation.
• Decision Quality.
• Communicates Effectively.
• Ensures Accountability.
• Business Insight.
• Balances Stakeholders.
• Manages Ambiguity.
• Nimble Learning.

Santam is the market leader in the general insurance industry in Southern Africa. We are a large, diversified, expanding and transforming company and whilst based in South Africa, we are rapidly moving into a number of emerging markets, both in Africa and Asia.

At Santam, we are committed to transformation and embracing diversity. 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. In achieving our employment equity goals, we give preference to applicants from the designated groups in alignment with the Divisions Employment Equity targets.

From the day we opened our doors in 1971, MRI Software has built flexible, game-changing real estate software solutions to improve people’s lives. The only way to carry out that mission is to hire the absolute best employees on earth. People like you.

Work hard, play hard. Always. Our relentless commitment to client success, our employee resource groups and our promise to empower our teams to reach their full potential are a few examples of what makes MRI Software special.

And we’re passionately dedicated to creating a work environment that you look forward to every single day. That’s why we invest heavily in our employee engagement, so you enjoy the tech industry’s best perks. Together with the whole Pride, (lion roar for "family") employees, customers, and partners, we’re on a mission to break new ground and lead the real estate industry into a digital-first future.

We understand the need to provide a flexible working environment partnered with team collaboration and socialization. Therefore, we operate a hybrid working model with 3 days in-office and 2 days remotely. This role is based at our Cape Town Office.

Please note, this position is required to work in accordance with U.S. hours (EST) 8:30am-5:00pm as well as U.S. Public Holidays.

The Role:

As a Support Analyst with the MRI Software Client Support team, you will have the opportunity to analyze complex software issues, engage with our worldwide client base, and provide an incredible customer experience every day.

In this position, you will be the primary point of contact for a broad variety of customers from financial and property management institutions, assisting with a wide range of questions and issues. MRI Software will rely on YOU to use your troubleshooting skills, technical savvy, and creativity to meet their needs and deliver a consistent, professional experience.

Responsibilities

• Responds to inbound requests from all channels (phone, portal, e-case) within prescribed service levels

• Identifies, assesses and resolves all new and existing concerns

• Monitors, documents and manages the resolution process in a timely manner while effectively communicating status with the client to maintain a high degree of client satisfaction

• Assist in the creation and maintenance of user and procedural documentation

Requirements

• SQL Knowledge would be beneficial.

• Salesforce or equivalent CRM experience a bonus.

• Problem-solving mind-set

• Ability to manage multiple tasks at the same time (Time management skills)

• Bachelor’s degree or equivalent work experience

• Customer focus and a passion for support

• Creative and curious troubleshooter

• Aptitude for technology

• Professional communication skills

We’re obsessed with making this the best job you’ve ever had!

We want our teams to love working here, so we’ve created some incredible perks for you to enjoy:

• We want our staff to love working here, and so we’ve created a few unique perks such as office breakfasts, quarterly lunches and virtual social events. Additionally, we value your input in your employee experience and have employee-led groups such as our DEI committee, employee resource groups such as Women and Allies, and our Pride Event Group

• Have confidence in your health with our offered Medical Aid Scheme.

• Invest in our competitive Personal Pension plan and help set you up for your future.

• Big on family? So are we! Here at MRI Software we recognise that your family is important, and being able to spend quality time with your family as it grows is a wonderful experience. Therefore, the MRI Software Parental Leave benefit is designed to give you the opportunity to spend time with your new arrival(s).

• Enjoy a fantastic work-life balance with 25 days of annual leave plus public Holidays, in addition to a bank of 1 6 hours of "Flex Time Off" to be used whenever and however you choose!

• Further your professional development with our Tuition Reimbursement Schemes

• Enjoy the flexibility of working from anywhere in the world for two weeks out of the year!

MRI continues to strive to amaze as a global industry leader in real estate software. Whether you are joining as a new pride member or bringing your expertise back, your talent is important to maintaining MRI’s high client experience standard and continuing our growth in the PropTech space.

Amazing growth takes amazing employees. Are you up to the challenge?

As a global company, we believe diversity brings benefits for our people, customers and clients. This is why MRI Software is committed to being an inclusive employer, regardless of your ethnicity, religion, sexual orientation, gender identity, disability, age, military and veteran status.

Diversity, Equality and Inclusion are values that are critical to our success; come and see for yourself.

We are seeking to appoint a BI Analyst in a 12-month contract, to collaborate with an international team and work from our offices in Welgemoed (Northern suburbs of Cape Town).

To provide end-to-end analytics solutions to address the business needs using BI technologies. Responsibilities include analyzing data, building datasets when needed, reconciling with the data source, analyzing requirements, proposing solutions, maintaining existing platforms, monitoring data loadings, supporting users, and training them. Additionally, support the BI team and provide quality reviews of their developments while contributing to a best-in-class mindset within the team.

1. Ensure maintenance of the BI platform, including user management.
2. Monitor processes and data flows, and perform bug fixing.
3. Conduct new release testing.
4. Document, design, implement, and reconcile solutions.
5. Enrich the existing data model based on changes in the source.
6. Collaborate with the BI team and end users to propose the best analytics solutions.
7. Lead the BI team.
8. Take ownership of projects and communicate progress with the project team and the BI team.
9. Update stories and log time based on activities.
10. Conduct quality reviews of team developments and advise on architecture and presentation.
11. Act as a guarantor and mentor for best practices adoption.

Bachelor’s degree in computer science or higher.

1. 5+ years of experience with SQL and a programming language.
2. 7+ years of experience with BI solutions, including ETL and visualization tools.
3. 5+ years of experience working with end users to define requirements and propose solutions.
4. Experience with one of these tools: Salesforce, Tableau, CRM Analytics, Python, or Snowflake.

1. English is a must; French is highly desirable.
2. Ability to work with end users to define requirements and identify solutions.
3. Excellent analytical and problem-solving skills.
4. Excellent visualization skills.
5. Excellent communication skills.
6. Ability to speak both business and technical language.
7. Experience in Sales or Marketing (Google Analytics) or Finance Reporting.

Please note that this is a full-time, office-based position.

We are seeking a highly skilled and analytical Technical Data Analyst to join our data team. The ideal candidate will have experience with Tableau/Power BI/Other BI software, Microsoft SQL, and ERP systems, and will be adept at turning large data sets into meaningful insights, designing, and maintaining data systems and databases, and using a variety of tools and techniques to interpret results and drive decision-making.

Key Performance Outputs:

Qualifications/Experience:

Company: Xcede Group

Location: Mpumalanga

• Type: Permanent
• Hours: Full Time
• Published: 2 hours ago
• EE/AA: Yes

We have a current opportunity for a System Analyst on a permanent basis. The position will be based in Mpumalanga. For further information about this position please apply.

• HR Services, Recruitment & Selection

Company: Xcede Group

Location: Mpumalanga

• Type: Permanent
• Hours: Full Time
• Published: 2 hours ago
• EE/AA: Yes

We have a current opportunity for a System Analyst on a permanent basis. The position will be based in Mpumalanga. For further information about this position please apply.

• HR Services, Recruitment & Selection

Do you speak fluent Excel, dream in dashboards, and get a thrill from turning chaos into clarity? Our client is on the hunt for a funky, fearless, and forward-thinking Business Analyst to help us uncover insights, solve mysteries, and translate complexity into Aha! moments.

Were looking for someone who can juggle data, dance through processes, and still make time to sip a flat white while presenting a killer report.

Requirements:

• Informatics or other relevant degree
• 3 years exp as a Business Analyst
• 1 year User Interface analyst experience
• 1 year Software Development experience (ay Uni is great)
• Honours degree
• Genesys Software
• Paradigm Software
• Agile Methodology
• Project Management
• SQL queries
• Enterprise architect
• Visio
• SoapUI (SOAP) / REST client (JSON)
• Atlassian tool suite (Jira, Confluence)
• SQL (Oracle and IBM Netezza)
• UML
• XML
• JSON

What you will be doing:

• Design and validate the functional solution using Agile Methodology
• This involves interpreting the product / technical requirements into Agile Epics and Stories
• Plan Agile Sprints and Stories for the Sprint
• Apply knowledge of the system, interfaces and dependencies to highlight integration aspects that must be considered
• Identify a set of stakeholders that need to be involved in creating and validating the Agile Story Board by interview business and technical owners, as well as experienced members of the development team (Development Manager, Architect, Snr BA)
• Design a set of test cases/scripts, test scenarios and test data sets to accompany the Agile Story Board
• Validate the Agile Epics and Test Basket with the identified stakeholders and obtain sign-off

Reference Number for this position is GZ60713 which is a contract position based in Sandton offering a cost to company salary of R600k per annum

IT API Test Automation Analyst ISTQB / SQL - Tshwane

Introduction:

We require the services of an API Test Automation Analyst in our Development and Engineering division. The role calls for a self-starter with strong communication skills and the ability to work at all levels within the business. The successful candidate will facilitate test automation within the testing team, ensuring software quality, functionality, and reliability.

Minimum Requirements:

- ISTQB Foundation Testing Certification (Non-negotiable).
- ISTQB Advanced Test Analyst certification (advantageous).
- Relevant IT degree or diploma.
- Training in Object-Oriented Programming (OOP).
- Training in ReadyAPI, SOAPUI, and Visual Studio.
- Experience writing custom test applications.
- Strong background in SQL for data-driven testing.
- Experience with Git repositories and branching strategies.
- Proven expertise in automated test case development, estimation, and maintenance.
- Experience developing test cases and scenarios from requirements.
- Analytical mindset with excellent problem-solving skills.
- Strong attention to detail with a focus on quality assurance.
- Sound understanding of QA & QC concepts across the SDLC.
- Knowledge of test metrics and their application in decision-making.
- Ability to work independently or in a team environment.
- Strong communication skills and ability to engage across functions.
- Flexibility to work extended hours when required.

Attributes:

- Highly adaptive and able to thrive in a dynamic, ever-changing environment.
- Motivated, self-driven, and accountable.
- Detail-oriented with a focus on quality delivery.
- Cross-functional expertise with the ability to lead when necessary.

Key Responsibilities:

Test Strategy / Planning:

- Develop test plans, approaches, and scope for automation efforts.
- Provide test estimates for projects.
- Contribute to the continuous improvement of testing methodology.
- Establish and implement an approach for managing test data.

Requirements Management:

- Review and analyze functional requirements for completeness and clarity.
- Translate business capabilities into effective testing scenarios.
- Ensure traceability from requirements to test cases.

Test Development & Execution:

- Define automation targets and objectives with the Team Lead.
- Develop test cases, test scripts, and scenarios to achieve proper coverage.
- Execute scenario-based test cases and manage own test activities.
- Identify and prepare necessary test data.
- Perform quality assessment using metrics and analysis.

Reporting & Metrics:

- Provide input to standard test metrics and reporting.
- Track coverage and clearance of test cases.
- Work with project and test teams to report progress and resolve issues.

Defect Management:

- Debug and execute test scripts against defined test targets.
- Analyze test failures and prioritize logged defects with the development team.
- Ensure defects are tracked through to resolution.

Salary offer: Negotiable

Reporting & Insights Officer / Data Analyst

We're on the lookout for a data-savvy analyst to turn complex numbers into clear insights. If you thrive in fast-paced environments, love dashboards, and speak fluent SQL, Excel, and Power BI — we want you!

What You’ll Do:

• Build and maintain weekly/monthly reports for Finance, Ops, and Franchisor
• Analyze data to highlight trends and drive smarter decisions
• Create and manage dashboards (Power BI, SQL, POS systems)
• Translate business needs into clear, data-driven insights
• Ensure data accuracy, integrity, and compliance
• Support data-driven process improvements and cost-saving initiatives
• Provide training on new reports and dashboards
• Handle large datasets with precision and efficiency

What You’ll Need:

• Bachelor's degree in Computer Science or related field
• 2+ years in data analysis/reporting (preferably in FMCG)
• Strong skills in SQL, Excel (Advanced), Power BI
• Experience with POS systems (GAAP, Firecell)
• Excellent communication and problem-solving skills
• Ability to work independently and collaboratively

Ready to dive into data that drives decisions? Apply now!