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 Senior Data Warehouse Developer to join our financial services client based in Centurion.
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.
What we are looking for:
- 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.
Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.
Desired Skills:
