BI Analyst

Parvana; Cape Town; On-site; ZAR 750,000 - 1,000,000; Full time

Job summary

Parvana in Cape Town seeks a skilled BI professional to design, build, and optimize interactive dashboards for investment, risk, and operations teams. You will drive data-driven insights, automate recurring reporting, and collaborate with IT to ensure data pipeline integrity.

The role requires advanced SQL, data modeling, ETL experience, and strong Excel skills (Power Query/VBA). Experience with Snowflake is a plus in a dynamic, hybrid work setting.

Qualifications

• Advanced BI tool skills: Power BI, Tableau or Qlik.
• Strong SQL, data modeling and ETL workflow experience.
• Advanced Excel skills including Power Query and VBA.

Responsibilities

• Designing, building, and maintaining interactive BI dashboards and reports for investment, risk, and operations teams.
• Tracking portfolio performance, cash flows, and credit risk metrics via data-driven insights.
• Improving reporting speed, accuracy, and transparency by automating recurring processes.
• Maintaining data accuracy while partnering with IT/engineering to optimize pipelines and working with investment professionals to turn requirements into technical solutions.
• Conducting specific analyses to address investment, market, and performance questions.

Skills

Power BI

Tableau

Qlik

SQL

Data modeling

ETL

Excel (Power Query/VBA)

Snowflake

Tools

Snowflake

Job description

Cape Town, South Africa | Posted on 11/08/2026

Location: Cape Town | Work Type: Hybrid | Job ID: J107248 | Contract Duration: 12 months (renewable)

About our client:

Our client is a global investment advisory firm focusing on long-term value creation through investment strategies. They work with a diverse group of institutional partners and pride themselves on their collaborative, sustainable, inclusive culture and performance. You are welcome to go into the office daily or to take advantage of their hybrid in-office / remote benefit. This company places significant investment in employee wellness, their benefits which are on top of generous basic salaries, are industry leading in their generosity. Our client is large, offering fantastic career development opportunities but also very dynamic, they track as many metrics as possible in order to continuously improve - they spare no expense on the tools to do so. Automation, AI and R&D are pillars of their business framework which ensures you should never be at risk of falling behind or getting stuck working with old legacy software. Culturally they are very cosmopolitan and diverse, you will be working with the best globally.

What you will be doing:

• Designing, building, and maintaining interactive BI dashboards and reports for investment, risk, and operations teams.
• Tracking portfolio performance, cash flows, and credit risk metrics via data-driven insights.
• Improving reporting speed, accuracy, and transparency by automating recurring processes.
• Maintaining data accuracy while partnering with IT/engineering to optimize pipelines and working with investment professionals to turn requirements into technical solutions.
• Conducting specific analyses to address investment, market, and performance questions.

What our client is looking for:

• Advanced skills in BI tools (Power BI, Tableau, or Qlik), strong SQL capabilities, data modeling expertise, ETL workflow experience, and advanced Excel skills (including Power Query/VBA).
• Experience with Snowflake is considered an advantage.
• An analytical, detail-oriented self-starter who can effectively communicate complex technical concepts to non-technical stakeholders and manage multiple priorities.

Investment Advisory, Business Intelligence, Dashboards, SQL, ETL, Power BI, Tableau, Financial Reporting, Asset Management, Automation, Data Analytics