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
, 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
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
Skills
==========
Data WarehousingSQLSSISPower BIExtract Transform Load (ETL)Data Modeling
Industries
==============
InsuranceFinancial Services
Beware of fraud agents! do not pay money to get a job
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.