Senior 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 Senior Data Warehouse Developer to join our financial services client based in Centurion.

POSITION INFO:
What you will be doing:

• Develop Power BI solutions, working from high level technical requirements in line with business requirements.
• Quality assurance checks on all new Power BI project functionality and business requirements.
• Produce documentation for code written.
• Configure real-time replication of data from source system to the Data Warehouse, using tools like Stelo SQDR
• Partake in a roster of Operational Support, troubleshooting errors, and data queries on existing reporting.
• Basic interaction and collaboration with technical stakeholders to identify data sources, find data definitions for
• master and meta data as well as formulate and implement solutions.
• Promote the use of existing enterprise and divisional data standards to enhance data quality, ensure constant
• compliance and adherence to data governance principles.
• Promote reusability, maintainability, reliability, and scalability in design and development of data solutions.
• Process live and confidential data according to specified guidelines.
• Convert Legacy Excel reports to PowerBI
• Development and design of professional reports and dashboards to support various stakeholders within the company.
• Testing, debugging and reconciliation of data to source data to ensure data integrity.
• Ensure accuracy and integrity of data and its attribution to costs incurred by business.
• Communicate progress, including easily understandable representation of the data.
• Pro-active in suggesting for opportunities as well as making analytical observations on any aspect that would be beneficial to business.
• Design, develop, and implement robust and scalable data warehouse solutions.
• Develop, maintain, and optimize ETL/ELT processes to ensure efficient data extraction, transformation, and loading.
• Collaborate with stakeholders, including business analysts and data scientists, to understand data requirements and translate them into technical specifications.
• Ensure data quality, accuracy, and consistency across all data warehouse components.
• Monitor and optimize data warehouse performance, troubleshooting issues as they arise.
• Implement data governance and security best practices.
• Provide technical guidance and mentorship to junior developers.
• Stay updated with industry trends and emerging technologies in data warehousing and analytics.

• Completed BSc degree in Mathematics, Economics, Computer Science, Information Management or Statistics or other related fields
• 5 years proven experience as a Data Warehouse Developer or in a similar role.
• Introductory Cloud Certification - Desirable
• Strong proficiency in SQL and experience with various relational and non-relational databases.
• Extensive experience with ETL/ELT tools and methodologies (e.g., SSIS, Data Factory, Informatica, Talend,
• etc.).
• Solid understanding of data warehousing concepts, including Kimball and Inmon methodologies.
• Experience with data modeling (dimensional modeling, snowflake, star schemas).
• Familiarity with cloud data platforms (e.g., Azure Synapse, AWS Redshift, Google BigQuery) is a plus.
• Experience with data visualization tools (e.g., Power BI, Tableau) is beneficial.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and as part of a team.