283 Data Warehousing jobs in South Africa
Data Warehousing Specialist | Centurion
Posted 3 days ago
Job Viewed
Job Description
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.
Data warehousing specialist | centurion
Posted today
Job Viewed
Job Description
Data warehousing specialist | centurion
Posted today
Job Viewed
Job Description
Data Management
Posted today
Job Viewed
Job Description
About the Role
We are seeking a highly skilled and motivated Data Management & Business Intelligence (BI) Specialist to join our team on a full-time basis.
The successful candidate will be responsible for designing, implementing, and maintaining enterprise-grade data management frameworks and BI solutions, following globally recognized standards such as the DAMA Data Management Body of Knowledge (DMBOK).
This role requires both strategic insight and technical execution to ensure data quality, governance, and accessibility across the organization.
Key Responsibilities
- Develop, maintain, and optimize data models, ensuring alignment with business processes and analytics needs.
- Oversee data governance frameworks, ensuring compliance with policies, standards, and regulatory requirements.
- Design and manage data warehouses for reporting, analytics, and operational intelligence.
- Implement and monitor data management practices covering data lifecycle, quality, architecture, and metadata.
- Collaborate with cross-functional teams (IT, analytics, business units) to drive data-driven decision-making.
- Maintain documentation, data dictionaries, and data lineage mapping.
- Evaluate and implement BI tools and technologies for enhanced business reporting and visualization.
Qualifications & Certifications (Mandatory)
Candidates must hold recognized certifications aligned with the Data Management and BI professional body of knowledge, including:
Data Modeling Certificate
Data Management Professional Certificate
Data Warehouse Certificate
Data Governance Certificate
Additional advantageous certifications:
- DAMA Certified Data Management Professional (CDMP)
- Microsoft Power BI, Tableau, or similar BI platform certifications
- ISO 8000 / ISO 38505 awareness
Experience & Skills
- Minimum 3–5 years of experience in data management, BI, or related domains.
- Proven experience in data modeling (conceptual, logical, physical).
- Strong knowledge of ETL processes, data warehousing, and reporting systems.
- Hands-on experience with SQL, Python, or data visualization tools.
- Understanding of data governance frameworks and metadata management.
- Excellent analytical, problem-solving, and communication skills.
Why Join Us
- Long-term career opportunity with a 5-year full-time position.
- Work with advanced enterprise data management tools and frameworks.
- Join a forward-thinking organization committed to data excellence and innovation.
- Opportunities for continuous professional development and certification advancement.
Application Process
Interested candidates should submit:
- A detailed CV
- Copies of relevant certifications
Job Types: Full-time, Permanent
Pay: From R40 000,00 per month
Work Location: In person
Manager, Data Management
Posted 10 days ago
Job Viewed
Job Description
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.
Responsibilities- 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.
Specialist, Data Management
Posted 11 days ago
Job Viewed
Job Description
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.
Qualifications- 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.
Data Management Analyst
Posted 14 days ago
Job Viewed
Job Description
Summary
Our client relies on the timeliness and accuracy of the data received from external vendors. This role encompasses the receipt, processing and delivery of all market data, and the activities that transform and provide this information to end users.
Position Info- Recruiter: Guardian Recruiting
- Job Ref: CPT /CB
- Date posted: Saturday, September 27, 2025
- Location: Cape Town, South Africa
- Daily retrieval, validation, reconciliation and preparation of data.
- Data storage, auditing and control.
- Responding to data related queries.
- Feeding back to key stakeholders including the Research and Development team, Analysts and other users of data.
- Communication with data vendors and providers.
- Analysis and requirements gathering for enhancements.
- Formulating techniques for quality data collection.
- Bachelor's degree in a related field (Computer Science, Data Science, Statistics and Finance) or equivalent work experience.
- Data Science Qualification (Advantageous).
- SQL Certification (Advantageous).
- 1-3 years’ experience.
- Strong MS SQL experience.
- Experience working with financial instruments.
- Experience working with Bloomberg (Advantageous).
- Software Development Life Cycle (SDLC) experience (Advantageous).
- Experience working in an Agile environment (Advantageous).
- Power BI experience (Advantageous).
- This role requires staff to work one of two shifts (which will alternate between team members). Our client’s ordinary hours of work are 7.5 hours plus a 1-hour lunch break. The morning shift ordinarily starts at 06:00 and the evening shift ordinarily ends at 16:45.
- Overtime is required from time-to-time should there be system issues or data delivery issues.
Daily retrieval, validation, reconciliation and preparation of data. Data storage, auditing and control. Responding to data related queries. Feeding back to key stakeholders including the Research and Development team, Analysts and other users of data. Communication with data vendors and providers. Analysis and requirements gathering for enhancements. Formulating techniques for quality data collection.
Key Competencies, Skills & Attributes- Good understanding of Microsoft Office products.
- Able to run and check data processes and data integrity.
- Has knowledge of financial instruments.
- Must maintain relationships with external service providers.
- Identifying and resolving data issues and keeping track of progress through issue tracking software.
- Ability to safeguard integrity of sensitive data.
- Communicates clearly and politely, both verbally and in writing, to obtain information.
- Quick learner.
- Self-motivated.
- Pays attention to detail.
- Able to work independently but also be a team player.
- Uses initiative, is pro-active and possesses problem solving skills.
- Not afraid to challenge the status-quo.
- Work irregular hours.
Please note that by submitting your application for this career opportunity, you agree that Guardian Recruiting may use your application for the purpose of the recruitment and selection of the said position, and this information may be shared with the relevant stakeholders in the business. Only short-listed candidates will be contacted. If you have not heard back within two weeks, please assume that your application was unsuccessful. All job postings are in accordance with our client's BEE requirements. Please only send certificates when requested to do so.
Additional- Referrals increase your chances of interviewing at ExecutivePlacements.com - The JOB Portal.
Be The First To Know
About the latest Data warehousing Jobs in South Africa !
Data Management Analyst
Posted 16 days ago
Job Viewed
Job Description
- Bachelor's degree in a related field (Computer Science, Data Science, Statistics and Finance) or equivalent work experience.
- Data Science Qualification (Advantageous).
- SQL Certification (Advantageous).
EXPERIENCE
- 1-3 years experience.
- Strong MS SQL experience.
- Experience working with financial instruments.
- Experience working with Bloomberg (Advantageous).
- Software Development Life Cycle (SDLC) experience (Advantageous).
- Experience working in an Agile environment (Advantageous).
- Power BI experience (Advantageous).
- This role requires staff to work one of two shifts (which will alternate between team members). Our clients ordinary hours of work are 7.5 hours plus a 1-hour lunch break. The morning shift ordinarily starts at 06:00 and the evening shift ordinarily ends at 16:45.
- Overtime is required from time-to-time should there be system issues or data delivery issues.
CORE RESPONSIBILITIES
Daily retrieval, validation, reconciliation and preparation of data.
Data storage, auditing and control.
Responding to data related queries.
Feeding back to key stakeholders including the Research and Development team, Analysts and other users of data.
Communication with data vendors and providers.
Analysis and requirements gathering for enhancements.
Formulating techniques for quality data collection.
KEY COMPETENCIES, SKILLS & ATTRIBUTES
- Good understanding of Microsoft Office products.
- Able to run and check data processes and data integrity.
- Has knowledge of financial instruments.
- Must maintain relationships with external service providers.
- Identifying and resolving data issues and keeping track of progress through issue tracking software.
- Ability to safeguard integrity of sensitive data.
- Communicates clearly and politely, both verbally and in writing, to obtain information.
- Quick learner.
- Self-motivated.
- Pays attention to detail.
- Able to work independently but also be a team player.
- Uses initiative, is pro-active and possesses problem solving skills.
- Not afraid to challenge the status-quo.
- Work irregular hours.
Please note that only short-listed candidates will be contacted.
Should you not have heard back within a two-week period, please assume that your application was unsuccessful.
All job postings are in accordance with our client's BEE requirements. Please only send certifi cates when requested to do so.
Manager, Data Management
Posted today
Job Viewed
Job Description
Job Overview
Business Segment: Personal & Private Banking
Location: ZA, GP, Johannesburg, 30 Baker Street
Job Type: Full-time
Job Ref ID: A-0002
Date Posted: 9/2/2025
Job Description
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.
Qualifications
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.
Additional Information
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
Please note: All our recruitment processes comply with the applicable local laws and regulations. We will never ask for money or any from of payment as part of our recruitment process. If you experience this, please contact our Fraud line on or
Executive: Data Management
Posted today
Job Viewed
Job Description
Company Description
INTEGRITY TRUCKING AND CONSTRUCTION SERVICES INC is a reputable construction company based in Balko, Oklahoma. The company is dedicated to delivering high-quality construction services to its clients. With a strong emphasis on integrity and excellence, the company aims to meet the diverse needs of its customers while maintaining high standards of safety and efficiency.
Role Description
This is a full-time hybrid role for an Executive: Data Management & Analytics, located in the Johannesburg Metropolitan Area with some work-from-home flexibility. The candidate will be responsible for overseeing data management processes, analyzing large datasets, developing data strategies, and providing actionable insights to drive business decisions. Daily tasks include managing data systems, conducting data quality assessments, ensuring data security, and collaborating with various departments to implement data solutions.
Qualifications
- Experience in Data Management and Governance
- Proficiency in Data Analysis, Data Visualization, and Business Intelligence tools
- Skills in Data Warehousing and Data Architecture
- Competence in Statistical Analysis and Predictive Analytics
- Strong problem-solving abilities and detail orientation
- Excellent communication and collaboration skills
- Ability to work independently and in a team in a hybrid environment
- Advanced degree in Data Science, Computer Science, Statistics, Information Systems, or related field
- Experience in the construction industry is a plus