Senior Business Intelligence Developer

Canvas Intelligence; Johannesburg; Hybrid; ZAR 600,000 - 800,000; Full time

Job summary

A leading Business Intelligence provider seeks a Senior Business Intelligence Developer responsible for data modeling, report creation, and analytical insights in Johannesburg. This hybrid role offers flexibility for remote work based on performance. Candidates should possess a Bachelor's degree, relevant Microsoft certifications, and strong backgrounds in data warehousing and BI technologies. The company champions innovation through effective data solutions to optimize business intelligence systems.

Qualifications

• Experience in data warehouse design and dimensional modelling.
• Proficient in data mining and analytical skills for insights.
• Ability to gather requirements and implement solutions.

Responsibilities

• Translate business needs into technical specifications.
• Design and deploy BI solutions including data warehousing.
• Evaluate and enhance existing BI systems.
• Collaborate for system integration and support data analytics platforms.

Skills

Data warehouse design

Database management systems

OLAP

ETL framework

Cloud technology

Microsoft Fabric

Python

Power BI

Microsoft BI Stack

Education

Bachelor's in computer science or informatics

Microsoft Certified Solutions Associate in Business Intelligence Development

Microsoft Certified Solutions Expert in Data Management & Analytics

Tools

Microsoft SQL

T-SQL

Power BI Desktop & Online

Data storage solutions

Job description

Canvas Intelligence (Pty) Ltd is a provider of comprehensive enterprise Business Intelligence (BI) solutions. Our focus is on helping companies strategically manage their financial, operational, and sales environments. With a team of experienced professionals and using key methodologies, we deliver market-leading BI solutions that are efficient, accurate, and cost-effective. Our offerings include building data warehouses, data lakes, central data repositories, and visualizing data through dashboards and Enterprise Control Towers, allowing companies to access real-time, visual data on any device. We also provide training and consultancy services for existing BI systems.

Role Description

This is a full-time Senior Business Intelligence Developer role with Canvas Intelligence. As a Senior Business Intelligence Developer, you will be responsible for tasks such as data modeling, Report and dashboard creation, and using your analytical skills to provide valuable insights to our clients. This is a hybrid role, with the majority of work located in Johannesburg and in office but with flexibility for remote work based on performance.

Responsibilities

• Translate business needs to technical specifications.
• Design, build and deploy BI solutions (e.g., data warehousing models)
• Evaluate and improve existing BI systems.
• Collaborate with teams to integrate systems.
• Develop and execute database queries and conduct analyses.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.
• Client Data Support
• Maintain and support data analytics platforms.
• Conduct unit testing and troubleshooting.

Qualifications

• Bachelor's in computer science or informatics or similar
• Microsoft Certified Solutions Associate in
• Business Intelligence Development
• Business Intelligence Reporting
• Microsoft Certified Solutions Expert in
• Data Management & Analytics

Skills and Experience

• Background in data warehouse design (e.g., dimensional modelling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Use of Cloud technology to build modern lakehouses in the medallion structure.
• Familiarity with BI technologies
• Microsoft Fabric
• Python
• Notebooks for Fabric, Synapse or Databricks
• Power BI
• Desktop &
• Online
• DAX
• Microsoft SQL
• T-SQL
• Microsoft BI Stack
• Storage Blob
• Integration Runtime
• Understanding of ERP, CRM and other business applications/business processes

Additional Experience

• Candidate must be able to gather own requirements from stakeholders, design, and implement solutions based on given requirements in an existing project.