BI Developer - 2 Years Fixed Contract

Mashesha Consulting; Pretoria; On-site; ZAR 800,000 - 1,200,000; Full time

Job summary

A consulting firm specializing in data solutions is seeking a Business Intelligence Specialist in Pretoria. The role involves designing data warehouse solutions, implementing ETL processes, and optimizing SQL queries. Candidates should have at least 8 years of experience and relevant certifications in the Microsoft Stack and Power BI. This position provides an opportunity to collaborate with stakeholders in an agile environment, focusing on delivering quality data solutions.

Qualifications

• 8+ years of experience as a Business Intelligence Specialist or similar role.
• Certifications in Microsoft Stack and Power BI are desirable.
• Experience in agile and waterfall development environments.

Responsibilities

• Support the design and development of data warehouse solutions.
• Collaborate with stakeholders to understand data requirements.
• Design and implement ETL processes ensuring data quality.
• Develop and test BI solutions such as databases and reports.
• Implement data governance and security measures.

Skills

Data modeling

SQL Server

Azure Data Warehouse

Power BI

ETL processes

Data governance

Education

Bachelor's Degree in Computer Science

Honours or Master’s qualifications

Tools

Microsoft Power BI

SQL Server Integration Services (SSIS)

Azure Data Factory

Job description

Responsibilities

• Support the design and development of data warehouse solutions using the 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.
• Develop and test BI solutions such as databases, data warehouses, queries, views, reports, and perform data conversions, imports, and exports within and between internal and external Auditees.
• Oversee end-to-end ownership of data projects and 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.
• 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.
• Implement data governance and security measures within the data warehouse environment, ensuring compliance and data privacy.
• Monitor and optimize data warehouse performance, addressing bottlenecks and recommending scalability improvements.
• Maintain the quality of the Metadata Repository by managing data entries.
• Contribute to the development of data and information quality metrics.
• Provide guidance, training, and support to team members.
• Track and analyze performance issues and implement improvements.

Requirements

• Bachelor's Degree in Computer Science, Information Systems, or a related field (NQF 7). Honours or Master’s qualifications are advantageous.
• At least 8 years of proven experience as a Business Intelligence Specialist or similar role.
• Certifications in Microsoft Stack, Power BI, and data warehousing (e.g., Microsoft Certified: Azure Data Engineer Associate) are desirable.
• Experience with Microsoft Stack, data warehousing, data lake technologies, and Power BI development.
• Experience working in agile and waterfall development environments.