Business Intelligence Developer

Neo Brokers (Pty) Ltd; Cape Town; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading company in Cape Town is seeking a BI Developer to design and maintain dashboards and manage data flows. This hybrid role requires a Bachelor's degree in Information Systems and a minimum of four years' experience in BI development and data analysis, with a focus on delivering actionable insights and collaborating with cross-functional teams. Proficiency in tools such as Power BI and SQL is essential, along with strong communication skills.

Benefits

Hybrid work model

Professional development opportunities

Qualifications

• Minimum 4 years of experience as a BI developer.
• High proficiency with SQL and database management.
• Experience in generating process documentation and reports.

Responsibilities

• Design, build, and maintain interactive dashboards and reports.
• Analyze trends and business KPIs to provide actionable insights.
• Administer and enhance BI tools, working with various databases.

Skills

Data Analysis

Stakeholder Collaboration

Dashboarding

Data Management

Communication

Analytical Skills

Education

Bachelor's degree in Information Systems

Tools

Power BI

SQL

Python

DevOps

Data Factory

T-SQL

Job description

BI Solution Development

Design, build, and maintain interactive dashboards, reports, and visualizations.

Develop and optimize ETL processes to consolidate data from multiple sources.

Build data models to support business intelligence and reporting needs.

Data Analysis & Insights

Analyze trends, patterns, and business KPIs to provide actionable insights.

Partner with business units to understand data needs and deliver meaningful analysis.

Present findings to stakeholders in a clear and concise manner.

Data Management & Governance

Ensure data accuracy, consistency, and quality across all BI outputs.

Enforce data governance and best practices in collaboration with data and IT teams.

Maintain data dictionaries and documentation for BI solutions.

Tool & System Management

Administer and enhance BI tools (e.g., Power BI, Tableau, Qlik, Looker, Google Analytics, Google Workspace).

Work with databases such as SQL Server, MySQL, PostgreSQL, or cloud data warehouses.

Automate recurring reports and improve reporting efficiency.

Stakeholder Collaboration

Collaborate with cross-functional teams including Finance, Marketing, Sales, and Operations.

Provide training or support to business users on BI tools and dashboards.

Drive awareness of requirements across business units and identify substandard systems processes through evaluation of real-time data.

Serve as a thought leader for technical business processes, developing systems prototypes that promote increased efficiency and productivity across multiple levels.

Minimum Requirements

• Bachelor's degree in Information Systems
• Minimum 4 years of experience as a BI developer responsible for:

• Dimensional modelling (Kimball Methodology)
• Data Modelling (Kimball Methodology)
• ELT / ETL
• Dataverse (Data Flows)
• Data Factory Pipeline Development
• Dashboarding and Reporting (PBI)
• Data Warehouse design (Kimball Methodology)
• Generating / Documenting technical specifications
• Effort Estimations
• Agile / Waterfall Delivery Environment

• Power BI
• DevOps
• SQL
• Data Factory
• Synapse
• Analysis Services
• T-SQL
• DAX
• M-Query
• Python

High proficiency with SQL and database management.

Experience in generating process documentation and reports.

Excellent communication skills, with an ability to translate data into actionable insights.

Proficient in MS Office, especially Excel (intermediate to advanced level).

Strong analytical skills and ability to interpret complex datasets.

Good communication skills to translate data into business language.

Advantages

• Purview Implementation / Master Data Management
• Machine Learning Model Development / Delivery
• MS Fabric Experience
• DP- Azure Data Engineering Associate
• DP- Enterprise Data Analyst
• PL- Power BI Data Analyst Associate

Based in Century City. Position is Hybrid.