Finance BI Analyst

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.

• 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.

• 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.

• 5+ years’ relevant BI or analytics experience.
• Experience with in 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.

• Degree or Diploma in:
  • Information Systems
  • Information Technology
  • Business Intelligence
  • Data Science
  • Finance
  • Business Analysis
  • or related field

• 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

• Permanent position
• Based in Cape Town
• Onsite / primarily onsite environment