About the position
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.
We are looking for a Full Stack 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.
Follow for the Latest Vacancies
Join Psybergate Careers Channel here: Psybergate Careers
Desired Skills:
- Data Warehousing
- Modelling
- ETL Development
- SQL / Database Programming
- Power BI
- SSAS / SSRS
