Location:
Centurion, Gauteng
Contract Type:
Full Time
Experience Required:
5 to 10 years
Education Level:
Bachelor
Job Description
• 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.
Experience Required:
• Proven experience (5+ years) as a Data Warehouse Developer or in a similar role.
• 3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
• 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.
Skills, knowledge and abilities:
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and as part of a team.
• 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.
Experience Required:
• Proven experience (5+ years) as a Data Warehouse Developer or in a similar role.
• 3-year degree in Mathematics, Economics, Computer Science, Information Management or Statistics
• 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.
Skills, knowledge and abilities:
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and as part of a team.
Number of vacancies:
1
Company Description
Keo-Kutlwi Pty Ltd t/a k2 Human Capital consultancy is an HR company providing HR support including recruitment to other businesses.
View Company Profile
