Bi Developer Pretoria - Pretoria
Mashesha Consulting
This role requires an experienced and highly skilled senior business intelligence specialist with expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI. The incumbent will serve as the technical expert responsible for designing, developing, and maintaining robust and scalable business intelligence solutions using Microsoft technologies such as SQL Server, Azure Data Warehouse, Azure Data Lake, and Power BI. Collaborate with cross functional teams to gather requirements, architect data warehouse and data lake solutions, create insightful reports and visualizations, and deliver actionable insights to meet stakeholder needs. Support with the design and development of data warehouse solutions using Microsoft Stack, including SQL Server, Azure Data Warehouse, and Azure Synapse Analytics. Collaborate with business stakeholders to understand their data requirements and translate them into scalable and efficient data models that support reporting, analytics, and data integration. Design and implement ETL processes to extract, transform, and load data from various sources into the data warehouse, ensuring data quality, consistency, and integrity. Designs, develops, and tests BI solutions such as databases, data warehouses, queries and views, reports, and performs data conversions, imports, and exports of data within and between internal (AGSA) and external Auditees. Oversee end-to-end ownership of data projects and independently collaborate with business stakeholders in an agile environment to solve business problems. Develop and maintain data transformation workflows using tools such as SQL Server Integration Services (SSIS) or Azure Data Factory. Support with Optimize SQL queries and stored procedures for data retrieval and analysis, ensuring efficient performance and adherence to best practices. Create visually appealing and interactive reports, dashboards, and visualizations using Microsoft Power BI, enabling stakeholders to derive actionable insights from the data warehouse. Implement data governance and security measures within the data warehouse environment, ensuring compliance with regulatory requirements and maintaining data privacy. Monitor and optimize the performance of the data warehouse, identifying and addressing bottlenecks, and recommending improvements for scalability and efficiency. Maintains the quality of the Metadata Repository by adding, modifying, and deleting data. Provides input to the development of data/information quality metrics. Provide guidance, training, and problem-solving assistance to other team members. Tracks, monitors and analyses performance and production issues, and implements improvements. Bachelor's/ Degree in Computer Science, Information Systems, or a related field (NQF 7). Relevant certifications in Microsoft Stack, Power BI, and data warehousing technologies (e.g., Microsoft Certified: Azure Data Engineer Associate) are desirable. 8 years of proven work experience as a Business Intelligence Specialist or similar role, with a focus on the Microsoft Stack, expertise in data warehousing, data lake technologies, and Power BI development. Experience in working with/in SQL Server, Azure Data Warehouse, Azure Data Lake, Azure Synapse Analytics, and Power BI. Experience working in an agile and waterfall development environment R1 200 000 per annum, TCTC
Apply Now
Facebook
WhatsappRelated Jobs
Senior Sql Developer Pretoria - Pretoria
Datacentrix
...
Bi Developer Pretoria - Pretoria
Salt
...
Data Engineer Pretoria - South Africa
Datafin IT Recruitment
...
Software Engineer Tshwane (Pretoria) - South Africa
Kamo Placements CC
...
Data Architect Pretoria - Pretoria
Linkfields Innovations
...