Data Warehouse Developer

SUMMARY:
-

POSITION INFO:

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

• 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