84 Report Generation jobs in South Africa

*** Our Johannesburg Office is Hiring *** 12-month renewable contract***

The Data Analyst and Visualisation Specialist will drive improvement of the data management maturity levels and provide the necessary technical support to client projects to support reliable and effective decision-making, appropriate usage, and protection thereof.

Responsibilities

The main purpose of this position is to conduct business and data analysis and document requirements in a manner that is suitable for Data Management solutions; this includes but is not limited to:

• Discover data by applying data discovery mechanisms to establish the data sets within the organisation.
• Identify data profiles of datasets discovered to determine completeness and compliance as well as for the purpose of inventory management.
• Establish relationships between data elements and their impact on the business.
• Understand business requirements and address matters of data completeness and data quality.
• Conduct analysis to track dataset lifecycle from its initial generation to its eventual archival and/or deletion.
• Conduct data analysis to determine various categories of data and information.
• Conduct data analysis to determine the importance of the data to the business and the probability of reuse.
• Produce regular reports and provide status updates as well as information for business domain.
• Develop and manage stakeholder relations effectively to promote data management across the organisation and support reliable decision-making and appropriate data usage.
• Provide input as data transitions from source to destination.
• To provide data storytelling through visualisation to ensure effective understanding and interpretation of information.
• To provide and ensure effectiveness of data visualisation techniques to enable deeper business insight.
• To develop and manage stakeholder relations effectively to promote data visualisation awareness across the organisation improve insight and decision making.
• To make large and/or complex data more accessible, understandable and usable
• To transform, improve and integrate data, depending on the business requirements.
• To combine the data result sets across multiple sources (also known as the data federation) to provide a landscape view.
• To deliver the data in a useful and appealing way to users.
• To provide aggregated views and also be able to drill down to the details at a level of columns and rows.
• Create robust, reusable data querying, transformation, and visualisation processes.
• Leverage analytics and visualisation tools to present information in a way that drives fact-based decision making
• Develop analytical reports and represent large, complex sets of data through visual representation

Qualifications

To be considered for this position, candidates must have:

• Bachelors degree or equivalent (e.g., BCom Informatics, BSc Information Systems, BSc Informatics, BTech); and
• Data Management Certification (e.g. DAMA CDMP)
• Minimum eight years' experience in data analysis; and
• Solid exposure to Agile methodology.
• Advanced knowledge of Information Management Business Analysis (minimum of 5 years' experience in Information Management).

Please note, due to the nature of the role, only South African citizens are being considered for this role.

Job description:

Join Us in Becoming the Best Bank in the World

We appoint energized and motivated people for their potential and continuously look for talented, driven individuals to help us innovate and evolve. That is why we focus on finding the right people for the right jobs.We love what we do because we focus on making a positive difference for our clients and employees. Our company DNA is built around talented and committed teams dedicated to build a brand that we are proud ofand earns the trust of our clients.

Who We are

We are a bank, but we're much more than that. We believe that banking is about enabling people to control their financial lives through banking that is simplified, accessible, affordable and delivered through personal experience. By helping our clients manage their financial lives better, we enable them to live better

Why Choose Us

At Capitec, we offer our best by living up to our CEO values in every situation – we always put the Client first,act with Energy and take Ownership. And to support people in being their best, our Employee Value Proposition offers every value to all team members through cohesive teams, growth opportunities as well as employee benefits and savings. We make it a priority to ensure that each member of the Capitec team feels welcome, valued, focused, and has the opportunity to grow

Purpose Statement

• To gather, analyse and understand business users' data and analytics requirements and translate these requirements into analytics best practice technical solutions that meet the relevant business objectives.
• To produce comprehensive business requirements specifications from business requirements leveraging domain, technical and data knowledge and coordinating collaboration from relevant stakeholders (e.g. own Product Line, Shared Services and other support teams) in the Capitec Data Estate

Education (Ideal or Preferred)

• Certification in AWS Data Analytics Speciality or AWS Architecture

Knowledge and Experience

Experience

Minimum:

• Relevant tertiary qualification in Statistics, Computer Science, Engineering or Mathematics
• At least 7 years' proven experience within information systems, business intelligence or data warehousing environments
• At least 7 years' proven experience in drafting Business Requirement Specifications/Documents and translating requirements between business and functional stakeholders
• Experience in Business Analysis using various techniques to describe business needs e.g. conceptual model, ERD, Test Cases, Data Flows, UML models, Data Dictionary, Business processes flows, etc.
• Experience in providing technical coaching to more junior team members as well as leading projects and/or Communities of Practice (COP)
• Able to perform data analysis and determine the impact on broader organisational frameworks and objectives
• Able to identify and classify data exposure risk from the relevant legislation

Minimum

Knowledge:

• Data Warehousing on an enterprise level
• Cloud data estates (e.g., AWS and Azure)
• Cluster computing fundamentals e.g., Big Data
• Data Governance and Data Management
• Understanding of data protection
• Financial systems and procedures
• SDLC / DevOps
• Conceptual Data modelling
• Basic data analysis using SQL (PostgresSQL)
• Understanding of the concepts of data visualisation
• Software Testing and Quality Assurance
• Coaching: principles and practice
• Databases and Database design

Ideal:

• Banking systems environment
• Banking business model
• Agile development life cycle
• Databases and Database design
• Quality Assurance (QA)
• Amazon Redshift

Ideal:

• Relevant business domain knowledge e.g., credit
• Business Information Business Analysis experience in a finance/banking environment

Additional Information

• Clear criminal and credit record

Contract

5 to 20 years

Negotiable

03 September 2025

PBT is a technology-agnostic company specialising in BI solutions. We help businesses harness the power of data to drive informed decision-making and achieve their strategic goals. Our team of experts is dedicated to delivering innovative and customised solutions that enable our clients to gain a competitive edge in today's rapidly evolving market.

Role Description:

As a BI Business Analyst at PBT, you will play a pivotal role in understanding the nature and business impact of requests, performing the required analysis, and collaborating with developers to ensure the successful delivery of functional and technical specifications. You will support the business by identifying opportunities for improvement, creating and maintaining documentation, and conducting high-level testing before deploying solutions.

Requirements:

• A relevant Business Analysis qualification is essential.
• Minimum of 5 years' experience as a Business Analyst
• Exposure to or experience in the Kimball methodology would be particularly advantageous.
• Strong technical data analysis skills
• Proficient in business process modelling
• Solid understanding of the Software Development Life Cycle (SDLC)
• High level of computer literacy, particularly in Excel
• Experience with Microsoft BI tools such as Power Pivot, Power BI, and SQL query writing
• Ability to design and document logical dimensional models.
• Well-developed analytical and problem-solving skills

Join our dynamic team at PBT and be part of a company that values innovation, teamwork, and personal growth. If you are enthusiastic about leveraging data to drive business success and meet the above requirements, we would love to hear from you.

• In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

"If you have not heard from us in two weeks, please note that you were unsuccessful for the role. However, we will keep your resume on file and reach out if any other suitable opportunity arises in the future".

AgileBusiness AnalysisBusiness IntelligenceBusiness ModellingDataData WarehousingSQL

Financial ServicesInsuranceBanking

The Apex Group was established in Bermuda in 2003 and is now one of the world's largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.

That's why, at Apex Group, we will do more than simply 'empower' you. We will work to supercharge your unique skills and experience.

Take the lead and we'll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Summary of the position

We are seeking a highly accomplished and visionary Business Intelligence Developer to join our team. As a BI Developer, you will report into the
Business Intelligence Manager
and be responsible for developing and maintaining BI and Reporting solutions.

Comptencies

• Proficient in reporting writing tools such as SSRS, dashboarding tools like Power Bi.
• Solid understanding of relational databases, Microsoft T-SQL.
• Solid understanding of ETL processes.
• Understanding of scheduling tools such as control-m.
• Fundamental understanding of basic warehouse concepts.
• Performance tuning of complex SQL queries.

Outline of main duties and responsibilities

As a Business Intelligence Developer, you will be expected to:

• Work with both Business Analysts and business owners to develop and enhance reports and dashboards.
• Maintain and enhance existing ETL processes.
• Be on regular after-hour stand-by support for the data warehouse loads.
• Performance tuning of stored procedures and reports.
• Ensure that development standards and processes are followed according to Apex's best practices.

Skills And Experience

• A degree or diploma (3 years) with majors Information Systems or Computer Science will be a strong advantage.
• A good working knowledge of IT systems in a corporate environment.
• At least 2-3 years of solid SQL Server development experience, with profiency in report writing skills. This includes but not limited to building complex stored procedures, functions, and views.
• 3-5 years' experience in building integration solutions independently.
• Strong attention to accuracy and detail.
• Strong analytical and problem-solving skills, including an ability to work independently from the business analyst team when appropriate.
• A high tolerance for ambiguity as requirements is not always clear at the start of a project and can change as users and analysts start to see the data.
• Self-starter who can take the initiative to learn new technologies independently and not just wait to be sent on training.
• Solid time management and communication skills essential.
• Ability to multi-task and to work on multiple project streams simultaneously.
• High personal integrity.

• The below skills are not an absolute requirement but would give the candidate a significant advantage over others.

• Scheduling tools such Control-m

• Cloud based database solutions like Snowflake
• Cloud based ETL solutions like DBT
• A background in Investment and Financial Accounting

Reporting structure

You will report to the team manager of the Business Intelligence Team for Open Ended Funds (SA).

Remuneration level

Remuneration is market related depending on experience.

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

Ready to take your IT career to the next level? A top-tier manufacturing company in Alberton is on the hunt for a tech-savvy
IT Support & BI Developer
who's eager to dive into real-time problem solving and data-driven innovation

This is your chance to get hands-on with cutting-edge manufacturing tech, own Qlik Sense development, and make a real impact across operations and ERP systems.

Key Responsibilities:

• Provide day-to-day technical support for internal IT systems, including ERP (SYSPRO), infrastructure, and network operations
• Develop, enhance, and maintain BI reports and dashboards using
  Qlik Sense
  and
  SQL
• Assist with integration of manufacturing plant systems into ERP platforms
• Work with operational teams to analyse data and identify system improvements
• Troubleshoot and resolve IT issues on-site

Requirements:

• Strong experience with
  Qlik Sense
  development and SQL reporting
• Working knowledge of
  SYSPRO ERP
• Solid understanding of
  network infrastructure
  and IT support best practices
• Proven experience in
  system integration
  within manufacturing environments
• Analytical mindset with the ability to translate data into actionable insights

Salary:

• The salary bracket for the role is around R35k - R40k CTC p/m. Note that it is the client's prerogative, regardless of advertised package, to offer a market related salary considering the candidate's qualifications, skills, and level of experience.

Introduction

Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms Momentum Metropolitan provides practical financial solutions for people, communities, and businesses.

Disclaimer

As an applicant, please verify the legitimacy of this job advert on our company career page.

Role Purpose

Manage the design and delivery of business intelligence and analytics solutions that provide business with the necessary data and insights that drive business decision making, operational excellence, business performance and service excellence.

Requirements

Qualification

• Valid Matric Certificate

• B-Degree in Data Science, Computer Science, Business Analytics, Statistics, Engineering or equivalent quantitative qualification

• Master degree (Preferable)

Knowledge

• Business process knowledge

• Knowledge of business intelligence and data analytics systems, programmes and processes

• Knowledge of financial service industry

Skills

• Communication skills

• Interpersonal skills

• Problem-solving skills

• Reporting skills

• Business acumen

• Data analysis skills

Experience

• 7 – 10 years business intelligence, management information systems or data analytics experience

• 3-5 years management experience

• Strong SQL and Data Warehouse/Data Lakes experience

• Proficient in Power BI and/or other Data Visualisation tools, like QlikView and Tableau

• Experience in Leading Data Migration Projects (Advantageous)

• Experience in IBM Cognos platform (Advantageous)

Duties & Responsibilities

INTERNAL PROCESS

Solution delivery

• Develop and execute Business Intelligence strategies to enable business to leverage off its data and analytical assets

• Design and implement business intelligence tools and systems, including data warehousing, visualization, and reporting toolsDesign, develop and maintain BI dashboards and reports

• Implement data modelling and organize complex data sets

• Identify trends and patterns in data to help improve business performance

• Elicit the business requirements and uncover business opportunities, resulting functionality, data and processes needed in order to recommend the appropriate solution

• Manage the delivery of data requests and maintenance of scheduled reports

• Accelerate the automation of reports and solutions

• Act as Data Officer and effectively manage the delivery of Statutory and Regulatory reporting

Data Governance

• Provide frameworks to best identify, understand, and interpret data structures across various databases within the business to facilitate data analysis and continuous monitoring activities

• Oversee the data sourcing, data models and data mining activities to support descriptive and trend analysis within the business environment

• Implement and manage data quality practices, measures and tools to ensure credible and trusted data, information, analyses and insights that are fully compliant to applicable legislation and industry standards

• Oversee the design and implementation of accurate, reliable and timeous metrics and reports to the business

• Oversee the delivery of data models, reports and insights that proactively identify risks within business, provide insight into business metrics

• Ensure and continuously improve the optimisation of data models, tools and solutions

• Actively pursue opportunities to assist business to identify risks and exposure and the prevention of losses through early detection and prevention processes

• Proactively Identify financial and business risks to the company and escalate accordingly

• Manage BI related projects to ensure the modernisation and optimisation

CLIENT

• Provide authoritative, expertise and advice to clients and stakeholders

• Build and maintain relationships with clients and stakeholders

• Contribute to the process of negotiating objective and realistic service level agreements, monitor appropriateness and recommend adjustments

• Deliver on service level agreements made with clients and internal and external stakeholders in order to ensure that client expectations are managed

• Make recommendations to improve client service and fair treatment of clients within area of responsibility

• Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service

PEOPLE

• Lead and develop a team of data professionals

• Create a positive work climate and culture to energise employees, give meaning to work, minimise work disruption and maximise employee productivity

• Demonstrate exemplary leadership behaviour, through personal involvement, commitment and dedication in support of organisational values

• Drive a culture that guides and directs best practice, fostering an environment of continuous learning, improvement and cohesiveness

• Enable a learning and growth culture whereby information regarding successes, issues, trends and ideas are actively shared between team members

• Identify employee growth and development needs and schedule interventions to enable ongoing development, training and personal growth

• Effectively manage performance within the team in order to ensure business objectives are achieved

• Encourage innovation, change agility and collaboration within the team

FINANCE

• Compile and control budgets to minimise expenditure in alignment with tactical delivery plans

• Control the budget for area, including the authorisation of expenditures and implementation of financial regulations

• Manage high risk and problematic financial issues in area of accountability and contribute to the development of policy

• Implement and manage financial risk methodologies, techniques and systems and use to monitor and report on financial activities

• Implement and provide feedback on the effectiveness of financial policy, practice and procedures: preventing illegal, unethical or improper conduct

• Implement risk management, governance and compliance policies in own practice area, to identify and manage governance and risk exposure liability

Competencies

• Examining Information

• Developing Strategies

• Directing People

• Interpreting Data

• Articulating Information

• Valuing Individuals

• Providing Insights

• Challenging Ideas

6Month Renewable Contract

HYBRID Mode ( Cape Town ONLY)

Responsibilities

• Manual testing of BV tables, HANA tables, data cubes, and SSRS reports
• SQL scripting for data validation and reconciliation
• Data structure and business logic validation
• Source-to-target data comparison during migrations
• BI tool-based output verification (SAP Analysis for Office, Excel)
• Test tracking in Jira and documentation in Confluence
• Cross-functional collaboration for issue resolution

Core Skills

• Advanced SQL (joins, CTEs, subqueries, CASE WHEN)
• HiveQL or Impala for large datasets
• SAP Analysis for Office and Excel proficiency
• Jira and Confluence experience

Desirable

• Data migration testing
• Familiarity with Data Vault concepts
• Interpretation of technical specs and mappings
• Agile/Scrum exposure
• Insurance industry knowledge

We are looking for an
exceptional Business Intelligence Analyst.
You have excellent use of logic and present high quality analysis. You are dependable and a great team player.

As a Business Intelligence (BI) Analyst, you will be responsible for extracting, cleaning, analysing, and interpreting data from company systems. You will create and maintain interactive dashboards that enable management to monitor system functionality, assess business performance, and make data-driven decisions to enhance profitability. You should have exceptional attention to detail.

Our client offers an exciting opportunity to work in a dynamic and data-driven environment that gives you exposure to the business.

They offer a competitive salary and benefits package with generous leave & pension benefits, as well as career growth opportunities in a dynamic team.

PLEASE NOTE:

Fully Remote

Salary: up to R70 000 CTC dependent on experience

Benefits: Benefits: 5% company pension contribution, laptop, Life Policy, 15 days annual leave plus certain Jewish Holidays, parental, maternity, study leave.

Required Qualifications & Skills:

• Bachelor's degree in Statistics, Mathematics, Data Science, Information Systems, or a related field.

• A minimum of 4 years of experience in business intelligence, data analysis, or a related role.

• Strong proficiency in SQL, data visualisation tools (e.g., Power BI, Tableau), and Microsoft Excel.

• Understanding of database structures and data modeling.

• Ability to interpret complex datasets and provide actionable insights.

• Experience with predictive analysis

• Excellent problem-solving skills and attention to detail.

• Strong communication and presentation skills for conveying findings to technical and nontechnical

stakeholders.

•
You are self-driven with a high work ethic and ability to meet deadlines.

• Experience working in the insurance or financial sector (preferred).

Responsibilities:

Checking, Understanding, and Working with Data

• Extract and collect data from various internal systems.

• Assess data quality and ensure accuracy through validation processes.

• Identify inconsistencies, anomalies, or inefficiencies in data and system processes.

• Provide structured feedback to developers to improve data accuracy and system efficiency.

Writing Queries for Statistics and Insights

• Develop and optimize SQL queries to extract relevant datasets for analysis.

• Conduct statistical analysis on data to identify trends, performance indicators, and

opportunities for improvement.

• Generate ad-hoc reports and structured insights to support business decisions.

• Work with large datasets and perform complex calculations to support management insights.

• Ensure that data extraction and analysis processes are efficient and scalable.

Building Dashboards Using Queries

• Design, develop, and maintain interactive dashboards using PowerBI.

• Ensure dashboards are user-friendly, visually appealing, and provide meaningful insights.

• Enable management to track system performance, detect anomalies, and make strategic

decisions.

• Regularly update and refine dashboards based on business needs and system updates.

• Train and support stakeholders in using dashboards and interpreting the data insights.