Bi Developer Centurion

Swift International Human Resources; Gauteng; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading recruitment agency in South Africa is seeking a Business Intelligence Developer to develop and maintain a Business Intelligence System. The ideal candidate will have extensive experience in Python and R, along with strong skills in data warehousing and SQL databases. Responsibilities include engaging in report development, task management, and ensuring the relevance of the data reports. This role offers a monthly salary structure and requires good communication and project management skills.

Qualifications

• Experience with BI Reporting, preferably using Power BI.
• Strong understanding of data warehousing and database structures.
• Ability to create and read ERDs.

Responsibilities

• Develop a Business Intelligence System for project reporting.
• Engage with task owners for task resolution.
• Document report requirements and manage continuous feedback.

Skills

Python

R (programming language)

MS SQL

NoSQL

Microsoft Power Automate

Microsoft Forms

Microsoft Dataverse

Analytical skills

Project management skills

Good communication skills

Education

Diploma / Degree in Information Systems

Tools

Power BI

Azure cloud computing

Azure data lake and database

Azure analysis and integration services

Microsoft suite

Job description

Job Purpose :

Developing and maintaining a Business Intelligence System, reporting to assist in various projects.

Qualifications and Experience :

• Python
• R (programming language)
• MS SQL
• NoSQL
• Diploma / Degree in Information Systems
• BI Reporting (Power BI will be an added advantage)
• Data warehouse design
• Azure cloud computing – added advantage
• Azure data lake and database
• Azure analysis and integration services
• Microsoft suite

Beneficial Skills :

• Microsoft Power Automate
• Microsoft Forms
• Microsoft Dataverse
• Working knowledge of other BI technologies
• Ability to read and create Entity Relationship Diagrams (ERD)
• Project management skills
• Good communication skills
• Analytical skills (Information processing)
• Good understanding of IT Infrastructure
• Good understanding of Microsoft applications and SQL Databases
• Ability to take ownership of a BI problem or project from beginning to completion

Duties & Responsibilities

Data Set Development:

• Understanding of data requirements
• Knowledge of database structure and where relevant data resides
• Envision optimal structure for reporting
• Data warehousing appropriate to report requirements
• Knowledge of current dataset portfolio
• Ability to update / improve current data for various functions

Report Development:

• Understanding of report requirements
• Appropriate report UI development
• Documentation of report requirements and usage / explanation
• Continuous feedback / communication and confirmation of report relevance
• Knowledge of current reporting portfolio – ability to update / improve current reports for various functions

General and Task Management:

• Ability to take ownership of a task until its resolution.
• Engage with task owners to ensure the task has been completed in the desired way
• Update and maintain the task lists or boards used to keep track of tasks
• Consult or brainstorm on issue items where necessary
• Participate in planning for future discussions
• Understanding infrastructure required for company systems
• Basic working knowledge of different databases within the Company
• Learn a skill the company needs to accomplish a task
• Project management

R - R - Monthly