Bi Analyst Cape Town

IQbusiness; Cape Town; On-site; ZAR 420,000 - 720,000; Full time

Job summary

IQbusiness in Cape Town seeks a BI Analyst on a 12-month contract, based in Welgemoed. You will develop reports and dashboards, build star schemas, and work with an international team.

Responsibilities include maintaining BI platforms, data modeling, testing releases, and training users; requires 3+ years BI experience, SQL and Python, and English; French desirable.

Qualifications

• Bachelor’s degree in Computer Science or equivalent required.
• 3+ years BI experience with ETL and data visualization.
• Strong SQL skills and Python programming.
• Experience with Salesforce, Tableau, CRM Analytics or Snowflake desirable.
• Ability to work with end users and translate requirements into solutions.

Responsibilities

• Provide analysis, reports and dashboards using BI technologies.
• Build star schemas when needed and reconcile with the data source.
• Analyze the requirements and propose the best reporting solution to the users.
• Maintain the existing platforms and monitor the data loadings.
• Support the users and train them.

Skills

SQL

Python

ETL

Visualization

Data modeling

End-user collaboration

Analytical thinking

Communication

English

Education

Bachelor's degree in Computer Science

Tools

Tableau

Salesforce

CRM Analytics

Snowflake

Job description

BI Analyst Position

We are seeking to appoint a BI Analyst in a 12-month contract, to collaborate with an international team and work from our offices in Welgemoed (Northern suburbs of Cape Town).

Job Mission:

• Provide analysis, reports and dashboards using BI technologies.
• Build star schemas when needed and reconcile with the data source.
• Analyse the requirements and propose the best reporting solution to the users.
• Maintain the existing platforms and monitor the data loadings.
• Support the users and train them.

Key Activities and Accountabilities:

• Ensure maintenance of the BI platform, including users’ management.
• Monitor the processes and data flows and bug fixing.
• New Release testing.
• Document, design, implement and reconcile solutions.
• Enrich the existing data model based on changes happening in the sources.
• Work in collaboration with the BI team and the end users to propose the best analytics to meet the needs.
• Take ownership on user stories, update them upon the progress, and share updates with the rest of the team.
• Log the time based on the activities.

Education:
At least bachelor’s degree in computer science.

Experience:

• 3+ years of experience of BI solutions, including ETL and visualisation tools.
• 3+ years of experience with SQL and a programming language, ideally Python.
• 2+ years working with end users to define requirements and propose solutions.
• Experience with one of the following: Salesforce, Tableau, CRM Analytics, Python, Snowflake.

Competencies:

• English is a must and French is highly desirable.
• Ability to work with end users to define requirements and identify solutions.
• Excellent analytical and problem-solving skills.
• Excellent visualization skills.
• Excellent communication skills.

Please note that this is a full-time, office-based position.