Job Description
PBT Group is seeking an experienced Senior Data Warehouse Developer to join our team. This role plays a key part 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.
- Develop and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
- Configure real-time data replication from source systems using tools such as Stelo SQDR or Qlik Replicate.
- Perform data quality checks, validations, and reconciliation to maintain accuracy and integrity.
- Convert legacy Excel reports into Power BI dashboards and reports.
- Implement 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 (2022) and T-SQL.
- Experience with ETL tools (SSIS, Azure Data Factory, Informatica, Talend).
- Solid understanding of data warehouse methodologies (Kimball, Inmon).
- Intermediate to advanced experience with Power BI for data visualization.
- Exposure to data replication tools (e.g., Stelo SQDR, Qlik Replicate).
- Data transformation, modeling, and integration experience.
- Knowledge of cloud data platforms (Azure Synapse, AWS Redshift, BigQuery) advantageous.
- SQL, T-SQL, SSIS, Power BI, ETL, ELT, familiar with Cloud
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.
* 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 received any feedback after 2 weeks, please consider you application as unsuccessful.
Qualifications and Experience
- Bachelors 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
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About Other Insurance Jobs in Gauteng
The Other Insurance (OI) industry is a significant sector in Gauteng, South Africa, offering a range of career opportunities for professionals with the right skills and experience. Typically, OI roles are in demand across various industries, including financial services, technology, and manufacturing, as companies seek to manage and mitigate risks associated with their operations.
Generally, OI specialists in Gauteng can expect salaries that vary widely depending on factors such as level of experience, company size, and industry sector. While broad salary ranges cannot be provided due to the variable nature of these factors, it is common for experienced OI professionals to earn between R600 000 and R1 200 000 per annum, while entry-level roles may start at around R300 000 to R500 000 per annum. However, salaries can fluctuate depending on individual circumstances.
Common skills required for OI roles in Gauteng include expertise in financial management, risk analysis, data interpretation, communication, and project management. Other essential skills often include proficiency in insurance software, analytical thinking, problem-solving, and the ability to work under pressure. Many OI professionals also hold relevant certifications or degrees in fields such as actuarial science, business administration, or economics.
The financial services sector is a significant employer of OI professionals in Gauteng, with other industries such as technology and manufacturing also commonly hiring for these roles. Other sectors that may employ OI specialists include healthcare, construction, and logistics. In terms of career development, many OI professionals in Gauteng progress to senior roles within their current organisations or move into related fields such as risk management, auditing, or claims handling.
For those seeking a career in OI, it is essential to develop a broad range of skills and experience, often through formal education and training. Many OI professionals in Gauteng have pursued certifications such as the Fellow of the Institute of Actuaries (FIA) or the Chartered Insurance Practitioner (CIP). Building strong relationships with clients, colleagues, and stakeholders is also crucial for success in this field.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Always arrive 10-15 minutes early for interviews to show punctuality and reliability.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Cape Town City Centre: Financial Manager
This role involves: Preparing accurate and timely monthly, quarterly, and annual reports and management accounts Managing year-end audit process and…
View JobJohannesburg: Sales Engineer
A dynamic and growing company supplying technical products and services to the mining and manufacturing sectors is seeking an experienced…
View JobCape Town City Centre: Automation Engineer
Job Description: PLC programming HMI and Scada design Perform Factory Acceptance Testing Design and implementation of automation systems Database automation...
View JobCenturion: Estimator
Our client is a well-established international projects and infrastructure business specialising in exhibitions, large-scale builds, interiors, and...
View JobCenturion: Financial Accountant
As a newly qualified CA(SA), youll join a high-performing finance team within a property development environment that values strategic thinking,…
View JobJohannesburg: Newly Qualified CA(SA)
This is an exceptional opportunity for a technically strong individual who is ready to move beyond pure audit or technical…
View Job
Browse Employers
Job Alerts