Warehouse Developer

Psybergate (Pty) Ltd; Knysna; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A leading IT company in South Africa is seeking a Data Warehouse Developer for a permanent role. The successful candidate will be responsible for designing, developing, and maintaining ETL processes and data integration. The role requires strong experience with Azure Data Factory and SQL, alongside a solid understanding of Data Warehouse architectures. This position offers an opportunity to work in a dynamic environment where mentoring and collaboration are key. Candidates should have at least 6 years of experience in Data Analytics/Business Intelligence.

Qualifications

• Minimum 6 years' IT experience, with 4+ years in Data Analytics / Business Intelligence.
• Proven experience managing Data Projects.
• Strong understanding of Data Warehouse architectures and supporting areas.

Responsibilities

• Design, develop, and maintain ETL processes, data integration, data warehouses.
• Develop BI solutions using SQL and ETL scripting on the Microsoft BI Stack.
• Coordinate team efforts to achieve business objectives under the Lead Developer.

Skills

Data Warehousing

Modelling

ETL Development

SQL / Database Programming

Power BI

SSAS / SSRS

Education

3 - 4 year IT qualification in Software Development

Relevant Microsoft certification in the Data space

Tools

Azure Data Factory

Synapse Pipelines

SSIS

SQL Server

Power BI

Job description

Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.

We are looking for a Data Warehouse Developer to join our financial services client based in Sandton on a permanent role.

A skilled Full Stack Data Warehouse Developer responsible for designing, developing, and maintaining ETL processes, data integration, data warehouses, performance tuning, and business intelligence reporting.

What You Will Be Doing

• Participate in the analysis, design, development, troubleshooting, and support of the enterprise reporting and analytics platform.
• Design, construct, test, and implement reporting, visualization, and dashboard processes, including drill-down functionality.
• Develop BI solutions using SQL, ETL scripting (ADF/Synapse Pipelines), business intelligence tools, database programming, and reporting tools on the Microsoft BI Stack.
• Integrate data from diverse source systems (In-House, Vendor-based, On-premises, Cloud-based, and Office 365).
• Collaborate with the DevOps team and participate in testing of database-related changes and application updates.
• Maintain data model schema and hierarchy within the data warehouse and reporting systems.
• Apply database tuning techniques to improve solution performance.
• Coordinate team efforts to achieve strategic and operational business objectives under the Lead Developer.
• Ensure business continuity documentation through Azure DevOps.
• Enforce database security standards and adherence by junior team members.
• Review code and oversee quality of BI solutions by junior developers.
• Mentor Junior and Intermediate team members.
• Drive implementation of innovative technologies in the Data space in consultation with the Lead Developer and Enterprise Architecture team.

What We Are Looking For

• 3 - 4 year IT qualification in Software Development.
• Relevant Microsoft certification in the Data space.
• Minimum 6 years' IT experience, with 4+ years in Data Analytics / Business Intelligence.
• Proven experience managing Data Projects.
• Strong experience with Azure Data Factory / Synapse Pipelines.
• Experience with SSIS, SSAS, SQL Server, and Power BI.
• Knowledge of Data Transformation Services and File Transfer Protocol.
• Strong understanding of Data Warehouse architectures and supporting areas (Data Transformation, Modelling, Reporting).
• Experience in dashboard design, reporting, and business intelligence solutions.
• Understanding of insurance/accounting principles is advantageous.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and manage multiple tasks simultaneously.
• Team player with mentoring capability.

Please note if you do not hear from us within 3 weeks, consider your application unsuccessful.

Desired Skills

• Data Warehousing
• Modelling
• ETL Development
• SQL / Database Programming
• Power BI
• SSAS / SSRS