Business Intelligence Developer (Permanent & Contract)

Swan IT is searching for a BI Developer to join our client in the financial industry based in Pretoria. There are contract and permanent positions available for a BI Developer.

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. As a BI Developer, you will be 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.

Responsibilities:

• Contributes to the strategy, vision, and governance of the BI and Data Analytics capability.


• Drive best practices, iterative improvement, and innovation at the strategic deployment level.


• 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 the implementation of the centre Balance Score Card (BSC) project and initiatives.


• 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.


• Support to set standards and ways of working with data across the entities, through collaboratively way.


• 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.


• 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.


• Provide guidance, training, and problem-solving assistance to other team members.


• Tracks, monitors and analyses performance and production issues, and implements improvements.


• Engage with both internal and external stakeholders to identify and evaluate performance barriers in order to continuously improve service delivery.


• Work in collaboration with various teams to ensure timeous delivery of the work.


• Contribute to the compilation of centre budget and manage project expenditure related to functional area.


• Build and maintain positive and value-adding relationships with relevant internal/external stakeholders.


• Scan the environment to ensure a clear understanding of stakeholder needs.


• Contribute to the compilation of centre budget and manage project expenditure related to functional area.

Requirements:

• Bachelor's degree in Computer Science, Information Systems or related


• Any certifications in Microsoft Stack, Power BI, and data warehousing technologies will be highly beneficial.


• At least 8 years of experience as a BI Specialist or similar


• Experience in working with/in SQL Server, Azure Data Warehouse, Azure Data Lake, Azure Synapse Analytics, and Power BI.

Please apply in the first instance to find out more about this exciting opportunity!