Senior BI Developer MMH251028-9

MomentumBellville, Western Cape, South Africa

21 hours ago

Job description

Momentum Bellville, Western Cape, South Africa

Role Purpose

Design, build and maintain scalable Business Intelligence (BI) solutions that enable reliable reporting, data integration, and data analytics. Lead the redevelopment of the existing data warehouse and migration from on‑premises systems to cloud‑based environments. The Senior BI Developer ensures data integrity, performance optimisation, and alignment under the direction of the BI Manager. Serve as the team lead for the BI development team, supporting and guiding BI developers in best practices for data modelling, ETL / ELT processes and BI solution delivery. Collaborate closely with the BI manager, data analyst and business stakeholders to deliver modern, efficient, and scalable BI solutions that drive business value and enable data‑driven decision making.

Qualifications

Valid Matric or Equivalent
Bachelor’s degree in Computer science, Information Systems, Data Science, Business Analytics, Statistics, Engineering, or an equivalent quantitative qualification.
Postgraduate qualifications or master’s degree in quantitative discipline (advantageous)
Relevant BI certifications in Microsoft Power BI, Azure Data Engineer, Azure Synapse Analytics, or SQL Server (advantageous)
Certification or training in data warehousing, data modelling, or ETL development (advantageous)

Knowledge

Strong understanding of business intelligence and data analytics systems, processes, and lifecycle management.

In‑depth knowledge of data warehousing principles, dimensional modelling (Kimball / Inmon), and ETL / ELT methodologies.

Proficiency in SQL and familiarity with Microsoft Azure ecosystem (Data Factory, Synapse, Databricks, and Fabric).

Understanding of business processes and KPIs across operational and financial domains.

Knowledge of System Development Lifecycle (SDLC) and BI delivery frameworks (Agile or hybrid).

Awareness of data governance, metadata management, and information security practices within enterprise BI environments.

Skills

Advanced SQL development for data extraction, transformation, and performance optimisation.

ETL design and implementation using Sybase or Azure Data Factory.

Data modelling and semantic model design for Power BI and reporting environments.

Power BI dataset and dashboard development, including DAX optimisation and data refresh scheduling.

Strong analytical thinking and problem‑solving capability.

Excellent communication skills, able to translate technical solutions into business‑friendly terms.

High attention to detail, data accuracy, and solution documentation.

Ability to mentor BI Developers and collaborate effectively within cross‑functional teams.

Experience

Minimum of 7 years of relevant experience in Business Intelligence, Data Engineering, or Data warehouse development, ideally within the financial services or corporate sector.

Strong proficiency in SQL and database management.

Proficient in Power BI and / or other Data Visualisation tools, like QlikView and Tableau, etc.

Proven experience developing BI solutions and transitioning data assets to cloud.

Strong analytical and problem‑solving skills with the ability to interpret complex data sets.

Hands‑on experience building and optimising ETL / ELT pipelines and data models for reporting and analytics.

Strong track record in SQL performance tuning, data validation, and report automation.

Experience working in an agile development environment.

Experience collaborating with Data Analysts and BI Managers to deliver enterprise‑level reporting and analytics solutions.

Exposure to Microsoft Fabric, Azure Synapse, or Databricks is advantageous.

Duties and Responsibilities

Lead the migration of existing on‑premise data assets and processes to cloud environment, ensuring seamless transition and adherence to governance standards.

BI Solution Development : Design, build, and maintain scalable BI solutions that support both operational and strategic business needs, ensuring reliability, performance, efficiency and scalability.

Database & ETL Development : Develop and optimise SQL queries, procedures, and scripts within the internal environments. Manage ETL / ELT processes to ensure efficient and secure data movement across systems.

Data Integration : Integrate data from multiple sources into a unified, trusted repository to support enterprise analytics and reporting.

Data Modelling & Architecture : Develop and maintain robust data models (relational, dimensional, and tabular) to support analytics, Power BI reporting, analytical dashboards and self‑service BI initiatives.

BI Reporting & Visualisation : Develop and publish Power BI, Cognos, or SQL‑based reports to meet operational and strategic information needs. Optimise report performance through efficient queries, caching, and data model tuning. Collaborate with Data Analysts to design intuitive dashboards that effectively communicate key insights to business users. Implement and maintain Power BI semantic models and data refresh schedules, ensuring alignment with data governance and accuracy standards.

Performance Optimisation : Evaluate, enhance, and troubleshoot BI systems to improve query performance, scalability, and data refresh efficiency.

Collaboration & Support : Work closely with the BI Manager, Data Analysts, and BI Developers to translate business requirements into effective technical designs and solutions.

Data Quality & Validation : Implement data validation and reconciliation processes to ensure accuracy, completeness, and consistency across BI environments.

Documentation : Maintain comprehensive technical documentation, including data flow diagrams, ETL logic, metadata, and model definitions for transparency and reproducibility.

Automation & Innovation : Identify opportunities to automate BI workflows, enhance data processes, and adopt emerging Azure tools and Fabric capabilities.

Technical Mentorship : Provide technical guidance, peer review, and knowledge sharing for BI Developers, ensuring adherence to BI development standards and best practices.

Data Governance & Compliance : Support the implementation of data governance policies, ensuring that all BI development aligns with security, privacy, and compliance frameworks defined by the BI Manager.

Client

Provide authoritative technical expertise and BI development support to internal business stakeholders.

Collaborate with business units and BI manager to understand reporting, data and integration requirements, translating them into effective BI and data solutions.

Ensure the accuracy, reliability, and performance of BI deliverables including dashboards, datasets and reports.

Support the BI manager in stakeholder engagements by explaining BI capabilities, data model design, and system enhancements that improve reporting efficiency.

Partner with the Senior Data Analyst to ensure models, metrics and dashboards align with analytical and business reporting needs.

Maintain professionalism, responsiveness and data confidentiality when supporting business areas and executives with BI outputs.

People

Lead a team of data professionals and maintain a high impact culture.

Act as a technical mentor and subject matter expert for BI Developers, providing guidance on data modelling, ETL design, SQL optimisation, and Power BI dataset development.

Support the BI Manager in cultivating a collaborative, high‑performance BI team culture focused on innovation, accuracy, and technical excellence.

Promote knowledge sharing and skills development by contributing to BI standards documentation, peer code reviews, and internal learning sessions.

Encourage innovation and continuous improvement, exploring new technologies and approaches within systems.

Demonstrate professionalism, accountability, and technical leadership in all project interactions and cross‑functional collaborations.

Foster strong working relationships with Data Analysts, Developers, and business teams to ensure BI solutions meet organisational needs.

Stay current with emerging BI technologies and cloud advancements to strengthen team capability and support organisational modernization goals.

Finance

Deliver accurate and efficient BI solutions that support financial reporting, budgeting, forecasting, and performance tracking.

Develop cost‑efficient data pipelines and BI processes that optimise infrastructure usage across different environments.

Support the BI Manager in ensuring the accuracy and completeness of financial datasets used in executive dashboards and KPI reporting.

Implement automated data refreshes, reconciliation processes, and validation checks to improve the timeliness and reliability of financial reporting.

Identify and implement opportunities to reduce data processing costs and improve system performance efficiency through query optimisation and resource management.

Contribute to financial and operational insight by maintaining data structures that enable reliable financial metrics and self‑service reporting.

Ensure all BI assets related to financial information comply with internal data governance, security, and audit requirements.

As an applicant, please verify the legitimacy of this job advert on our company career page.

#J-18808-Ljbffr

Create a job alert for this search

Senior Bi Developer • Bellville, Western Cape, South Africa

Related jobs

Promoted

Senior BI Developer

Communicate ITCape Town, Western Cape, South Africa

We have an incredible opportunity for a Senior BI Developer to join our esteemed client's team.This role requires someone with exceptional skills and expertise in Business Intelligence.Apply now an...Show moreLast updated: 30+ days ago

Promoted

Bi Developer

Open Box SoftwareWorkFromHome, Western Cape, South Africa

Open Box Software is an internationally focused consulting company that specialises in business and software consulting services. We have a young team of highly talented individuals who are driven t...Show moreLast updated: 1 day ago

Promoted

SQL Developer / BI Developer

Elite Search & SelectionCape Town, Western Cape, South Africa

Exciting opportunity for a SQL Developer / BI Developer - Intermediate to Senior (3 - 5 years relevant work experience).The company has been operating within the medical industry for over 100 years...Show moreLast updated: 30+ days ago

Promoted

Intermediate BI Developer

Communicate ITCape Town, Western Cape, South Africa

Are you prepared to harness the power of Business Intelligence and sculpt our organization's future? We are in search of an Intermediate BI Developer with abilities to rival those of the most formi...Show moreLast updated: 30+ days ago

Promoted

Senior Bi Developer Cape Town : Northern Suburbs

Communicate ITCape Town, Western Cape, South Africa

Promoted

BI Developer

Top RecruitmentCape Town, Western Cape, South Africa

The BI Developer will design and develop data sets and reports for business analytic requirements, using Apache Airflow, Google BigQuery, and Google Looker Studio. The BI Developer will assist in fo...Show moreLast updated: 30+ days ago

Promoted

BI Developer (Mid-level)

Open Box SoftwareCape Town, Western Cape, South Africa

Get AI-powered advice on this job and more exclusive features.Open Box Software is an internationally focused consulting company that specializes in business and software consulting services.We hav...Show moreLast updated: 30+ days ago

Promoted

Senior Bi Developer

WatersEdge SolutionsCape Town, Western Cape, South Africa

Location : Remote / Hybrid (South Africa).SaaS | Data Science | Analytics.WatersEdge Solutions is hiring an experienced Senior BI Developer to join a high-impact data science team building enterpris...Show moreLast updated: 11 days ago

Promoted

BI (Business Intelligence) Developer

E&D RecruitersSomerset West, South Africa

BI (Business Intelligence) Developer.Bachelorâs degree in Data Science, Engineering, Programming or similar discipline. At least 1 year of relevant work experience in BI Development or related fie...Show moreLast updated: 30+ days ago

Promoted

BI Developer

PRR RecruitmentCape Town, South Africa

Bachelor’s degree in Data Science, Engineering, Programming or similar discipline.At least 1 year of relevant work experience in BI Development or related fields. Experience with development of BI t...Show moreLast updated: 30+ days ago

Promoted

Senior Business Intelligence Developer

wePlaceCape Town, South Africa

You will work in the IT solutions team within an Insure (Short-term Administration) company.You will be responsible for analysing, designing and building BI solutions that enable operations and bus...Show moreLast updated: 21 days ago

Promoted

Senior BI Developer

WatersEdge SolutionsCape Town, South Africa

SaaS | Data Science | Analytics.WatersEdge Solutions is hiring an experienced.BI infrastructure and delivering insights that matter. If you’re passionate about Power BI, data modelling, and defining...Show moreLast updated: 30+ days ago

Promoted

Bi Developer Cape Town : Northern Suburbs

Communicate ITCape Town, Western Cape, South Africa

Promoted

Senior Data & BI Developer

Network RecruitmentCape Town, South Africa

Strong SQL Server skills (SQL, T-SQL, SSIS, and SSRS).Proven expertise in Power BI (DAX, Power Query, and dashboard / report design). Hands-on experience building cloud data solutions in Microsoft Azu...Show moreLast updated: 4 days ago

Promoted

Intermediate BI Developer

EQPLUS TECHNOLOGIES PTY LTDCape Town, Western Cape, South Africa

Location : Western Cape, Cape Town.Intermediate BI Developer (Data Scientist).The successful candidate will leverage tools such as AWS QuickSight and Power BI to transform raw data into actionable i...Show moreLast updated: 16 days ago

Promoted

Senior BI Engineer- CPT

Xcede GroupCape Town, Western Cape, South Africa

Business Intelligence Engineer.We are on the search for a Business Intelligence Engineer that will be responsible for developing, deploying and maintaining BI interfaces. We want you to manage our c...Show moreLast updated: 30+ days ago

Promoted

Senior Business Intelligence Developer

Golden RuleCape Town, South Africa

You will work in the IT solutions team within an Asset Management company.You will be responsible for analysing, designing and building BI solutions that enable operations and business strategic go...Show moreLast updated: 19 days ago

Promoted

Intermediate BI Engineer

BETSoftwareCape Town, Western Cape, South Africa

Design, Development and Reporting : .Ensures the Design, development and maintenance of Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.R...Show moreLast updated: 16 days ago