Data Warehouse Developer

SUMMARY:
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.

POSITION INFO:

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.