Senior BI Analyst / Developer

Introduction

At iDbase Software , we are a technology-focused company delivering innovative data and software solutions. We value innovation, teamwork, accountability, and continuous learning , while creating a supportive environment where our people can grow, develop, and make an impact.

Description

Key Responsibilities

• Act as the senior technical authority for BI, setting best practices, standards, and design principles across the BI estate.

• Coordinate and guide a small team of BI Analysts, balancing hands-on delivery with review, mentoring, and technical direction.

• Remain an active contributor, owning and delivering complex, high-impact dashboards, reports, and data models.

• Review and assure BI outputs to ensure they meet agreed standards for accuracy, performance, usability, and consistency.

• Facilitate effective ways of working across the BI team, including prioritization, estimation, and delivery cadence.

• Support skills development and knowledge sharing to uplift overall team capability.

• Own the end-to-end delivery of BI solutions, from requirement definition through to deployment and ongoing enhancement.

• Partner closely with investment, risk, finance, and operations stakeholders to prioritize BI initiatives and manage demand.

• Translate complex business requirements into scalable, well-designed BI solutions.

• Act as a trusted advisor to senior stakeholders, using data and insights to influence decision-making.

• Oversee the design, build, and maintenance of dashboards and reports covering portfolio performance, cash flows, risk, and credit metrics.

• Drive standardization and reusability of reports, data models, and metrics across the organization.

• Ensure high levels of data accuracy, consistency, and transparency in all BI outputs.

• Champion automation of recurring reporting to improve efficiency and reduce operational risk.

• Work closely with IT and data engineering teams to shape data models, pipelines, and BI architecture.

• Define and enforce BI best practices, including data modelling standards, naming conventions, and documentation.

• Identify opportunities to improve BI tooling, processes, and performance.

• Stay abreast of developments in BI tools, analytics techniques, and data visualisation best practices, and apply them pragmatically.

Profile

Senior BI Analyst/Developer with 10+ years of BI, analytics, or data experience , preferably within financial services, asset management, or investment environments . They should have:

• Expert Power BI, Tableau, or Qlik experience.

• Strong advanced SQL and data validation skills.

• Solid Azure experience, particularly Synapse, Fabric and Data Factory .

• Strong data modelling, data warehousing and ETL/ELT experience.

• Experience with Power Query and advanced Excel .

• Experience building and optimizing BI solutions handling large datasets .

• Strong understanding of BI governance, data quality and reporting standards .

• Experience integrating BI with APIs and applications , including Power BI Embedded.

• Strong stakeholder management and business-facing communication skills.

• Ability to mentor and guide a small BI team while remaining hands-on.

• Ideally, knowledge of investment, asset management, portfolio performance and credit risk .

Best-fit profile: A hands-on BI leader who can design, build, optimize and govern enterprise BI solutions , while confidently partnering with senior business stakeholders and guiding other BI Analysts.

We offer

We are looking for a Senior BI Analyst/Developer to join our Engineering team in Cape Town . The ideal candidate will be a hands-on BI professional with 10+ years of experience , strong Power BI, SQL, Azure, data modelling and ETL skills, and the ability to guide a small BI team. You will work closely with business stakeholders to deliver trusted, scalable BI solutions and insights that support investment, risk, finance and operational decision-making. Experience in financial services or asset management will be highly advantageou