BI Developer - 2 Years Fixed Contract

SUMMARY:
An experienced business intelligence individual. Expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI. The incumbent Contributes to the strategy, vision, and governance of the BI and Data Analytics capability. He will provide strategic support and identify opportunities in existing business processes for building reports and dashboards. Function as an integrator between the business and technology to create business solutions.
Support define and manage best practices for our Data Warehouse. This may include payload design of source data, logical data modelling, implementation, metadata, and testing standards.

POSITION INFO:
Responsibilities

• 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 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). Honours /Master qualification will be advantages.
• 8 years of proven work experience as a Business Intelligence Specialist or similar role
• Certifications in Microsoft Stack, Power BI, and data warehousing technologies (e.g., Microsoft Certified: Azure Data Engineer Associate) are desirable.
• Work experience Microsoft Stack, expertise in data warehousing, data lake technologies, and Power BI development.
• Experience working in an agile and waterfall development environment.