Finance BI Analyst & Power BI Report Developer

SUMMARY:
-

POSITION INFO:

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.

Ideal Candidate Profile

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

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

* If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.