Finance BI Analyst, Cape Town

Finance BI Analyst job vacancy in Cape Town. PBT Group is seeking a skilled and business-focused Finance BI Analyst&Power BI Report Developer to join a dynamic data and analytics environment supporting finance reporting and decision-making capabilities.

This role combines Business Intelligence analysis with hands-on Power BI development, requiring someone who can engage with finance stakeholders, gather and document reporting requirements, and translate those requirements into high-quality dashboards, reports, and data-driven insights.

The successful candidate will work closely with business, BI, and data teams to deliver scalable reporting solutions aligned to enterprise standards, governance, and best practices.

We are looking for a BIBA-style professional with strong Power BI development capability— someone comfortable operating between business stakeholders and technical teams while delivering high-quality reporting and analytics solutions.

Key Responsibilities:

Finance Reporting&Business Analysis

Engage with finance stakeholders to gather, analyse, and document reporting requirements.

Translate business needs into technical specifications and reporting solutions.

Support reporting areas including:

Management reporting

Budget vs Actual analysis

Revenue and profitability reporting

Cost analysis

Customer and supplier reporting

Inventory and working capital reporting

Facilitate workshops and requirement gathering sessions.

Document KPIs, business definitions, calculations, and reporting logic.

Power BI Development

Design, develop, and maintain Power BI dashboards and reports.

Build and maintain efficient data models using best-practice modelling techniques.

Develop DAX measures, calculations, and calculated columns.

Use Power Query for data transformation and ETL-related activities.

Implement interactive visualisations and reporting functionality.

Optimise report performance, refresh times, and usability.

Data Quality&Governance

Perform data validation, reconciliation, and quality assurance checks.

Maintain report documentation, metadata, and data lineage.

Apply governance standards, version control, and documentation practices.

Implement Row-Level Security (RLS) and workspace governance where required.

Collaboration&Support

Work closely with data engineering, BI, and business teams.

Provide user support and troubleshooting for reporting issues.

Conduct report walkthroughs, user training, and knowledge-sharing sessions.

Contribute to continuous improvement initiatives within the BI environment.

Required Experience&Skills: Essential:

3+ years’ experience in:

Business Intelligence

Power BI Development

Business Analysis

Data Analytics / Reporting

Strong Power BI experience including:

Data modelling

DAX

Power Query

Dashboard development

Strong SQL querying and data manipulation skills.

Experience gathering and documenting business requirements.

Understanding of:

Star schema / snowflake schema modelling

Data visualisation best practices

ETL and data warehousing concepts

Ability to translate business requirements into reporting solutions.

Strong communication and stakeholder engagement skills.

Preferred:

5+ years’ relevant BI or analytics experience.

Experience within finance reporting environments.

Experience with:

Power BI Service

Workspace administration

Row-Level Security

Data governance

Exposure to Azure data services such as:

Azure Data Factory

Azure Synapse

Microsoft Power BI certification advantageous.

Qualifications:

Degree or Diploma in:

Information Systems

Information Technology

Business Intelligence

Data Science

Finance

Business Analysis

or related field

Key Competencies:

Strong analytical and problem-solving ability

Attention to detail

Strong communication and stakeholder management

Ability to work independently and collaboratively

Time management and prioritisation skills

Adaptability in a fast-paced environment

Strong documentation and reporting capability

Location&Employment Type:

Permanent position

Based in Cape Town

Onsite / primarily onsite environment

#J-18808-Ljbffr