Business Intelligence Developer

Key Responsibilities: 1. 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. 2. 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. 3. 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. 4. 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. 5. 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 thought leader for technical business processes, developing systems prototypes that promote increased efficiency and productivity on multiple levels Minimum Requirements Bachelors degree- 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, with focus being on excel- intermediate to super user Strong analytical skills and ability to interpret complex datasets. Good communication skills to translate data into business language. Advantageous Requirements Purview Implementation/Master Data Management Machine Learning Model Development/Delivery MS Fabric Experience DP-203 Azure Data Engineering Associate DP-500 Enterprise Data Analyst PL-300 Power BI Data Analyst Associate Based in Century City Position is Hybrid

Location: Cape Town City Centre, ZA

Posted Date: 6/21/2025