72 Data Warehousing jobs in South Africa

Join a leading Financial Services firm in their quest for excellence! Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a world-class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.

Maintain and support:

• Existing MIS databases.
• Existing reports and dashboards.
• Existing data warehouses.

Develop, test, deploy, maintain and support: new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.

Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.

Outputs:

Internal Process:

• Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
• Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
• Conduct research and evaluate potential technical solutions to identified business problems.
• Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
• Design and code new database and analytics functionality using code that is readable, maintainable and reusable.
• Conduct Unit Testing of own code and resolve all issues/queries timeously.
• Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
• Deliver solutions into the applicable production environment once testing has been completed.
• Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
• Maintain existing databases and applications according to change requests approved by business as and when needed.
• Diagnose root causes of issues through problem-solving and recommend potential solutions.
• Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
• Log issues found in existing systems as internal change controls and ensure successful resolution of issues.

Responsibilities:

Develop, implement and document Business Intelligence Solutions:

• Contribute to the overall data warehouse architecture and database designs.
• Maintain and oversee the administration and maintenance of the data warehouse.
• Develop and maintain Business Intelligence and reporting technologies and processes.
• Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications.
• Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
• Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
• Ensure the continued maintenance and enhancement to existing business intelligence solutions.
• Within user specifications extract, transform and load (ELT) data using the relevant tools.
• Verify and quality assure of data provided.
• Provide support to business intelligence users on data-related issues.

Future development and planning:

• Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their application in the short-term insurance industry.
• Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the company short-term insurance business, in alignment with the company’s standards and the South African financial services regulatory framework.

Self-management and Teamwork:

• Provide authoritative expertise and advice to colleagues.
• Develop and maintain productive and collaborative working relationships with peers and team members.
• Deliver on Service Level Agreements made with colleagues.
• Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
• Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
• Take ownership for driving career development.

Finance:

• Manage financial and other company resources under your control with due respect.

Competencies:

• Business Acumen.
• Client / Stakeholder Commitment.
• Drive for Results.
• Leads Change and Innovation.
• Motivating and Inspiring Team.
• Collaboration.
• Impact and Influence.
• Self-Awareness and Insight.
• Diversity and Inclusiveness.
• Growing Talent.

Skills:

• Communication – articulating information and challenging ideas.
• Analysing and interpreting data.
• Problem-solving.
• Planning and organising – time and task management.

Experience and Qualifications:

• Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) – Essential.
• Dimensional modelling and/or relevant Microsoft certification – Advantageous.
• On-the-job training/qualifications:
• Microsoft Sql Server.
• Oracle.
• Power BI.
• Advanced MS Excel.
• Starquest.

Some experience in predictive analytic platforms will be advantageous. These include:

• Python.
• Scala.
• Spark.
• AWS Sagemaker.

Some experience in Azure / AWS platform services will be advantageous. These include:

• Azure SQL elastic instance.
• Data factory.
• PowerBI.
• AWS RDS.

Experience:

• Methodologies.
• The candidate must have ability to elicit data requirements from stakeholders.
• The candidate must have clear documentation skills.

Principles:

• The candidate must be familiar with design patterns in the data development industry.
• The candidate must have a solid understanding of Metadata constructs.
• The candidate must have clear understanding of EDW.
• Knowledge of Domain driven design would be an advantage.
• The candidate must be familiar with the concept of Data Marts.
• The candidate must be familiar with abstraction techniques.

Modelling:

• The candidate must have proven data modelling techniques (3 years).
• The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years).
• Knowledge of Immon data warehouse modelling techniques would add an advantage.
• The candidate must have data normalization skills most especially the 2nd Normal form.

Data Transportation:

• The candidate must have solid experience of ETL systems.
• The candidate must have solid experience of sourcing, staging and loading.
• The candidate must be familiar with parallel loading principles.
• The candidate must be familiar with source to target mapping.

Development Software:

• The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts.
• Dynamic T-SQL.
• Multi-threading.
• Performance optimisation and tuning.
• The candidate must have practical experience of SQL Server Database Engine (4 years).
• The candidate must have practical experience of MS SSIS ETL software (4 years).
• The candidate must have practical experience of MS SSAS OLAP software (4 years).
• The candidate must have practical experience of MS Visual Studio Data Tools (4 years).
• Knowledge of Database Administration would add an advantage.
• Expert knowledge in configuration of database hardware resources.

Repository type:

• The candidate must be able to source data from different repositories.
• The candidate must be fully acquainted with Microsoft SQL Server repository.
• Knowledge of Data Lake would be an advantage.
• Knowledge of Oracle would be an advantage.
• Knowledge of Hadoop is not essential but will also be an advantage.

Overview

Standard Bank Group is a leading Africa-focused financial services group, and an innovative player on the global stage, that offers career-enhancing opportunities and the chance to work with talented professionals. Our clients range from individuals to businesses of all sizes, high net worth families and large multinational corporates and institutions. We’re passionate about creating growth in Africa and delivering value to clients and communities.

Provide infrastructure, tools and frameworks used to deliver end-to-end solutions to business problems. Build scalable infrastructure for supporting the delivery of clear business insights from raw data sources; with a focus on collecting, managing, analysing, visualising data and developing analytical solutions. Responsible for expanding and optimising Standard Bank's data and data pipeline architecture, whilst optimising data flow and collection to ultimately support data initiatives.

• Type of Qualification: First Degree
• Field of Study: Information Studies
• Type of Qualification: First Degree
• Field of Study: Information Technology

• Data Monetisation
• Data & Analytics
• 5-7 years

• Experience with big data tools: Hadoop, Spark, Kafka, etc.
• Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
• Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
• Experience with AWS cloud services: EC2, EMR, RDS, Redshift.
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.

• Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable "big data" data stores.
• Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building and optimizing "big data" data pipelines, architectures and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

• Behavioural Competencies:
• Adopting Practical Approaches
• Articulating Information
• Challenging Ideas
• Checking Things
• Examining Information
• Exploring Possibilities
• Interpreting Data
• Meeting Timescales
• Producing Output
• Providing Insights
• Team Working
• Upholding Standards

• Technical Competencies:
• Data Analysis
• Database Administration
• Data Integrity
• Knowledge Classification

Overview

Business Segment: Personal & Private Banking

Location: ZA, GP, Johannesburg, 30 Baker Street

Provide infrastructure, tools and frameworks used to deliver end-to-end solutions to business problems. Build scalable infrastructure for supporting the delivery of clear business insights from raw data sources; with a focus on collecting, managing, analysing, visualising data and developing analytical solutions. Responsible for expanding and optimising Standard Bank's data and data pipeline architecture, whilst optimising data flow and collection to ultimately support data initiatives.

• Provide infrastructure, tools and frameworks used to deliver end-to-end solutions to business problems.
• Build scalable infrastructure for supporting the delivery of clear business insights from raw data sources; with a focus on collecting, managing, analysing, visualising data and developing analytical solutions.
• Responsible for expanding and optimising Standard Bank's data and data pipeline architecture, whilst optimising data flow and collection to ultimately support data initiatives.

• Type of Qualification: First Degree
• Field of Study: Information Studies
• Type of Qualification: First Degree
• Field of Study: Information Technology
• Experience Required
• Data Monetisation
• Data & Analytics
• 5-7 years
• Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with AWS cloud services: EC2, EMR, RDS, Redshift. Experience with stream-processing systems: Storm, Spark-Streaming, etc. Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
• 5-7 years
• Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependency and workload management. A successful history of manipulating, processing and extracting value from large disconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.
• 5-7 years
• Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience building and optimizing 'big data' data pipelines, architectures and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Overview

Provide infrastructure, tools and frameworks used to deliver end-to-end solutions to business problems. Build scalable infrastructure for supporting the delivery of clear business insights from raw data sources; with a focus on collecting, managing, analysing, visualising data and developing analytical solutions. Responsible for expanding and optimising Standard Bank's data and data pipeline architecture, whilst optimising data flow and collection to ultimately support data initiatives.

• Provide infrastructure, tools and frameworks that enable end-to-end solutions for business problems.
• Build scalable infrastructure to collect, manage, analyse and visualise data; develop analytical solutions.
• Expand and optimise data and data pipeline architecture; improve data flow and data collection to support data initiatives.
• Collaborate with teams to implement data-informed solutions and insights.

• Type of Qualification: First Degree
• Field of Study: Information Studies
• Type of Qualification: First Degree
• Field of Study: Information Technology
• Experience Required: Data Monetisation, Data & Analytics
• Experience: 5-7 years
• Experience with big data tools: Hadoop, Spark, Kafka, etc.
• Experience with relational SQL and NoSQL databases, including PostgreSQL and Cassandra.
• Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
• Experience with AWS cloud services: EC2, EMR, RDS, Redshift.
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
• Strong analytic skills related to working with unstructured datasets.
• Experience building data transformations, structures, metadata, dependency and workload management.
• Proven ability to manipulate, process and extract value from large, disconnected datasets.
• Working knowledge of message queuing, stream processing, and scalable big data data stores.
• Working SQL knowledge and experience with relational databases; proficiency in query authoring and familiarity with various databases.
• Experience building and optimizing big data pipelines, architectures and data sets; experience performing root cause analysis to drive improvements.

• Adopting Practical Approaches
• Articulating Information
• Challenging Ideas
• Checking Things
• Examining Information
• Exploring Possibilities
• Interpreting Data
• Meeting Timescales
• Producing Output
• Providing Insights
• Team Working
• Upholding Standards

• Data Analysis
• Database Administration
• Data Integrity
• Knowledge Classification

• Mid-Senior level

• Full-time

• Information Technology

Overview

Business Segment: Insurance & Asset Management

Location: ZA, GP, Roodepoort, Ellis Street 4

This role resides within Standard Insurance Limited Data management and Insights and requires the incumbent to provide data management support to Actuarial, Personal lines, Commercial and Finance. Responsible for data analysis, expanding and optimising data flow and collection to ultimately support data initiatives.

• Type of Qualification: Bachelor’s degree in Statistics, Computer Science, Mathematics, Business, or related field. Advanced degrees or certifications in data analysis, data management
• Other Preferred Qualifications, certifications or professional memberships : Data related certifications, SAS, Microsoft SQL server
• Experience Required: SQL, SAS or any related programming language (knowledge for querying, data extraction, and manipulation across databases.)
• Experience with data visualization tools such as PowerBi
• Basic accounting knowledge
• Business analysis and project management
• Data Quality and metadata management
• Strong analytical and troubleshooting abilities, with a keen attention to detail.
• Ability to think critically and resolve complex data issues efficiently.
• Proven experience identifying and addressing root causes of data discrepancies.

We are seeking a highly skilled Data Management Specialist to join our financial services team. The ideal candidate will play a pivotal role in managing and enhancing data governance, quality, and architecture to support regulatory compliance, business insights, and operational efficiency.

• Develop and implement data management strategies aligned with business objectives and regulatory requirements.

• Establish and maintain data governance frameworks, policies, and standards.

• Monitor and ensure data quality, integrity, and accuracy across systems.

• Collaborate with stakeholders to define data requirements and metadata standards.

• Support the design and implementation of data architecture and integration solutions.

• Manage data lineage, classification, and cataloging processes.

• Drive continuous improvement in data processes and tools.

• Ensure compliance with data protection regulations and financial services standards.

• Bachelors degree in Information Systems, Data Science, or a related field.

• Proven experience in data management within the financial services sector.

• Strong knowledge of data governance, data quality, and metadata management.

• Familiarity with data architecture and regulatory frameworks (e.g., BCBS 239, GDPR, POPIA).

• Proficiency in data management tools and technologies (e.g., Collibra, Informatica, Microsoft Purview).

• Excellent analytical, communication, and stakeholder engagement skills.

• Relevant certifications (e.g., DAMA, DCAM).

• Experience in change management and data-driven digital transformation.

Overview

Work with Us. Change the World.

At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations.

There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world.

We're one global team driven by our common purpose to deliver a better world. Join us.

AECOM is seeking a mid-level Environmental Data Manager to support our enterprise environmental data management system (EarthSoft EQuIS). The ideal candidate will have a strong understanding of environmental data and terminology, good communication skills, and the ability to collaborate with both technical and non-technical stakeholders. As a team Lead, you will be responsible for guiding a high-performing team toward achieving operational and strategic goals. You’ll serve as a mentor, problem-solver, and project driver—ensuring that team efforts align with broader organizational objectives. This role demands a balance of technical expertise, emotional intelligence, and leadership acumen.

This position offers the flexibility of a hybrid work schedule including both in-office and remote work options and will be located in Pretoria, South Africa (Centurion office).

• Management Responsibilities:
• Collaborate with cross-functional teams to ensure alignment with business goals.
• Lead, coach, and motivate a team of professionals to meet performance targets by fostering a culture of accountability, collaboration, and continuous improvement
• Conduct regular one-on-ones, performance reviews, and career development planning
• Set strategic direction and provide clear guidance to align team efforts with organizational goals.
• Cultivate a high-performance culture that values collaboration, inclusivity, and continuous improvement.
• Lead regular check-ins and performance reviews to support growth and accountability.
• Oversee financial planning, including budgeting, forecasting, and resource allocation.
• Drive talent development by identifying skill gaps and enabling upskills and career progression.
• Manage end-to-end project execution, ensuring timely delivery and quality outcomes.
• Contribute to business strategy, offering insights for growth and innovation.
• Mentor and coach team members for career growth
• Build and maintain strong relationships with internal and external stakeholders
• Support resource planning and allocation to ensure optimal team utilization.

• Technical Responsibilities:
• The ideal candidate will be able to understand requests from environmental subject matter experts.
• Gather, organize, and validate field data from environmental monitoring activities such as air, soil, and water quality assessments.
• Manage field and analytical data in relational database systems like EarthSoft EQuIS, Locus EIM, or other environmental databases.
• Conduct QA/QC for electronic data deliverables with laboratory analytical data to ensure quality.
• Generating standardized report output through software tools like EQuIS or EIM.
• Prepare environmental data summaries and compliance reports for submission to regulatory agencies.
• Utilize statistical tools and predictive modeling techniques to assess environmental impacts and forecast trends.
• Design and create dashboards and visualizations using platforms such as Power BI or EQuIS Enterprise.
• Ensure data meets reporting standards and guidelines set by local, state, and federal authorities.
• Responsible for generating Borelogs through multiple platforms like gINT, open source, or EQuIS.
• Supporting legacy data migrations to EQuIS/EIM as needed, ensuring proper formatting and compatibility.
• Collaborate with stakeholders, project managers, and team members to achieve project objectives efficiently.
• Provide technical support to field sampling teams and act as a liaison between the project staff, analytical laboratory, data validator, and GIS analysts.
• Research state and federal regulations necessary to manage action levels or clean-up criteria.

Minimum Requirements:

• Bachelor’s/master’s degree in environmental engineering, Environmental Science, or a related discipline plus ten (10) years of relevant experience in environmental data management or consulting, with hands-on experience in EQuIS, LOCUS EIM, ESdat, or similar databases or demonstrated equivalency of experience and/or education.
• Expertise and experience with environmental data and database systems (MS SQL Server, MS Access). Expertise with relational databases such as EarthSoft’s Environmental Quality Information System (EQuIS) /EIM/ ESdat. Ability to continually analyze data at all stages for problems, logic, and consistency concerning field data collection, analytical reporting, and other expertise on EQUIS sub-tools (Collect, Edge, ArcGIS).
• Assist with projects globally and task delivery with high quality and within deadlines. Managing data (geological, Field data, chemical laboratory data) for technical report writing and interpretation as required by the team. Maintaining and updating various project dashboards using the web-based EQuIS Enterprise system; and preparing report-ready data tables, charts, and figures for internal review and external client reports.
• Project management duties include coordinating field events. Using the sample registry and Sample Planning module, create EDDs and load to EQuIS to track event closure.
• Proficient in EQuIS Collect Module, create and deploy different categories of forms and train field personnel on the same.
• Expert level understanding of Office 365, Excel, Power Query & Power Automate.
• Should be good in Documentation, including Data Management SOPs, Process Maps, Work instructions, Activity Analysis, and Task effort estimation
• Use of visualization tools like Power BI to help management make effective decisions for the environmental domain is desirable but not essential
• Knowledge of digital tools like Power BI, R Studio, KNIME Analytics, SQL, and Python is a plus but not mandatory.
• Strong organizational skills, with experience prioritizing, time management, and managing multiple tasks.
• Effective communication skills to interact with multidisciplinary teams and clients.
• Expertise in applying Six-Sigma techniques/analysis to the environmental data management process.
• Strong attention to detail with excellent analytical, judgment, and problem-solving capabilities.
• Comfortable running meetings and presentations.

About AECOM

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status, AECOM benefits may include medical, dental, vision, life, AD&D, disability benefits, paid time off, leaves of absences, voluntary benefits, perks, flexible work options,well-being resources, employee assistance program, business travel insurance, service recognition awards, retirement savings plan, and employee stock purchase plan.

AECOM is the global infrastructure leader, committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities, we solve our clients’ complex challenges in water, environment, energy, transportation and buildings. Our teams partner with public- and private-sector clients to create innovative, sustainable and resilient solutions throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2024. Learn more at aecom.com.

What makes AECOM a great place to work

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting-edge technology and a network of experts, you’ll have the resources to make a real impact. Our award-winning training and development programs are designed to expand your technical expertise and leadership skills, helping you build the career you’ve always envisioned. Here, you’ll find a welcoming workplace built on respect, collaboration and community - where you have the freedom to grow in a world of opportunity.

As an Equal Opportunity Employer, we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines.