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
Keep copies of job descriptions for positions you apply to - they're useful for interview prep.
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
Centurion: Financial Manager posted by Network Finance
Company and Job Description: As Financial Manager, you will play a pivotal leadership role in steering financial strategy, ensuring compliance,…
View JobJohannesburg: Credit Facilitator posted by Hire Resolve
Job Title: Credit FacilitatorLocation: Johannesburg (Onsite)Contract Type: Permanent, Full-timeIndustry: Direct Selling / FMCG / RetailSalary: Market...
View JobWestern Cape: Group Financial Accountant posted by Persona Staff
Key Responsibilities:Compile and review monthly management accounts from trial balance to financial statementsPresent financial reports and performance...
View JobJohannesburg North: Financial Manager posted by Network Finance
Our client is a leading player in the mining industry, known for operational excellence, strong financial performance, and a commitment…
View JobJohannesburg: M&A Associate posted by Hire Resolve
A leading Pan-African investment bank and asset manager is looking for an experienced M&A Associate with a strong background in…
View JobDurban: Advanced Technical Assistant posted by Hire Resolve
A well-established and reputable financial services organisation is seeking a highly skilled Advanced Technical Assistant to join its dynamic team.…
View Job
Browse Employers
Job Alerts