Johannesburg: Data Warehouse Developer

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. Follow for the Latest Vacancies Join Psybergate Careers Channel here: