Data Architect

Careers At Dlk Group; Gauteng; On-site; ZAR 500 000 - 1 200 000; Full time

Job summary

A leading financial services provider in Gauteng is seeking a Data Warehouse Analyst to translate business needs into actionable insights. The role requires strong skills in data warehousing, ETL processes, and BI tools like Power BI. Ideal candidates should have a background in a quantitative field, with 5-8 years of relevant experience. This position offers competitive remuneration and the chance to influence data-driven decisions.

Qualifications

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.

Responsibilities

• Collaborate with stakeholders to understand business needs and translate them into specific data requirements.
• Develop and maintain ETL processes to move data from source systems to the data warehouse.
• Design, develop, and maintain interactive dashboards using BI tools.

Skills

Data Warehousing

SQL

ETL

Power BI

Data Modeling

Problem-Solving

Critical Thinking

Education

Bachelor's degree in a quantitative field

Tools

Tableau

Snowflake

BigQuery

Job description

Data Warehouse Analyst (Centurion, Gauteng)

Salary: R500000 - R1200000

Posted today

Job Description

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. Visit us at

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

Role Purpose

The Data Warehouse Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Data Warehouse Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences.

Requirements

• Bachelor\'s degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• 5 years\' experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

Duties & Responsibilities

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
• Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentorship: Mentor junior analysts and provide guidance on best practices.

Skills and Competencies

• Data Warehousing
• SQL
• SSIS
• Power BI
• ETL
• Data Modeling
• Business Acumen
• Problem-Solving
• Critical Thinking

Senior Data Warehouse Developer

Posted today

Job Description

Employment Type
Contract

Experience
5 to 25 years

Salary
Negotiable

Job Published
08 October 2025

Job Reference No.
Job Description
The following description is a summary of responsibilities for a Senior Data Warehouse Developer. PBT Group is seeking an experienced professional to join our team in designing, developing, and maintaining enterprise-level data warehouse solutions — ensuring data integrity, accessibility, and performance across large-scale financial systems.

The ideal candidate will have a strong technical foundation in SQL, ETL/ELT development, and data modeling, with proven experience delivering reliable and scalable data warehouse solutions. The role also involves translating complex datasets into actionable insights through effective visualization and reporting tools such as Power BI.

Key Responsibilities

• Data Warehouse Development: Design, develop, and maintain robust data warehouse solutions.
• ETL/ELT: Develop and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
• Real-time data replication: Configure real-time data replication from source systems using tools such as Stelo SQDR or Qlik Replicate.
• Data quality checks, validations, and reconciliation to maintain accuracy and integrity.
• Convert legacy Excel reports into Power BI dashboards and reports.
• Data governance, security, and compliance best practices.
• Develop and document technical solutions that are scalable, maintainable, and reusable.

Reporting and Analytics

• Build interactive Power BI dashboards and reports aligned with business requirements.
• Translate technical data into clear, actionable insights for both technical and non-technical stakeholders.
• Ensure accurate data attribution and validation for reporting and cost analysis.
• Perform data analysis and visualization to support business decision-making.

Collaboration and Support

• Engage with business analysts, data scientists, and technical stakeholders to clarify data needs and design solutions.
• Participate in operational support and troubleshooting of existing data warehouse components.
• Provide mentorship and technical guidance to junior developers.
• Collaborate across teams to drive data-driven initiatives and process improvements.

Skills and Competencies

• Technical Expertise: Strong proficiency in MS SQL Server and T-SQL.
• ETL tools (SSIS, Azure Data Factory, Informatica, Talend).
• Data warehouse methodologies (Kimball, Inmon).
• Power BI for data visualization.
• Data replication tools (Stelo SQDR, Qlik Replicate).
• Cloud data platforms (Azure Synapse, AWS Redshift, BigQuery) advantageous.

Soft Skills

• Excellent analytical thinking and problem-solving abilities.
• Strong communication skills, both written and verbal.
• High attention to detail with a commitment to quality and accuracy.
• Effective time management and prioritization under tight deadlines.
• Collaborative team player with a proactive, solutions-driven mindset.

Qualifications and Experience

• Bachelor\'s degree in Computer Science, Information Systems, Mathematics, Economics, or related field.
• 5+ years\' experience as a Data Warehouse Developer or similar role.
• Proven experience in data modeling (star/snowflake schemas).
• Experience with data visualization tools (Power BI, Tableau, QlikView).
• Familiarity with version control systems (Git).
• Cloud certification (Azure, AWS, GCP) is advantageous.
• Experience with Python or PowerShell scripting beneficial.
• Exposure to big data technologies (Spark, Hadoop) advantageous.

Behavioural Competencies

• Examining and interpreting information critically
• Generating insights and innovative ideas
• Producing high-quality, accurate deliverables
• Articulating complex data clearly
• Collaborative and adaptive team approach
• Strong accountability and ownership mindset

Industries

• Insurance
• Financial Services

What other jobs are popular in this category?

Explore these high-demand roles to expand your search:

Didn't find the right job? Get Career Advice to find your ideal role.