BI Analyst

Senior Business Intelligence Analyst

Location : Centurion, South Africa

Type : Full-Time (Hybrid)

Role Purpose :

The Senior Business Intelligence (BI) Analyst is responsible for transforming complex business needs into actionable insights through data. This role involves collaborating with stakeholders, analyzing data from various sources, and delivering clear, impactful reports and dashboards that support strategic decision-making. The successful candidate will have a strong command of data warehousing, ETL, reporting tools, and BI best practices.

Key Responsibilities :

Requirements Gathering : Work with stakeholders to define and document data and reporting needs.

Data Collection & Cleaning : Extract, validate, and clean data from multiple sources (e.g., databases, CRMs, analytics platforms).

Data Modeling & Warehousing : Design and maintain data models and scalable warehouse structures to support efficient querying and analytics.

ETL Development : Build and maintain ETL pipelines to load and transform data from source systems.

Data Analysis : Perform in-depth analysis to uncover patterns, trends, and actionable insights.

Dashboard & Report Development : Create user-friendly, dynamic dashboards and reports using modern BI tools.

Performance Monitoring : Track and optimize the performance of BI tools and reporting solutions.

Documentation : Maintain clear documentation of data sources, data models, ETL flows, and reporting processes.

Communication & Collaboration : Present findings and recommendations to both technical and non-technical stakeholders.

Mentoring : Provide guidance and mentorship to junior analysts and team members.

Continuous Learning : Stay updated on emerging BI trends, tools, and methodologies.

Technical Skills :

SQL – Writing complex queries for data extraction and analysis

ETL Tools – Building and maintaining automated data pipelines

Data Warehousing – Concepts, architecture, and tools (e.g., Snowflake, Redshift, BigQuery)

Data Modeling – Star and snowflake schema, dimensional modeling

BI Tools – Power BI, Tableau, Looker (dashboarding and data visualization)

Data Analysis – Trend identification, anomaly detection, insight generation

Scripting (Advantageous) – Python or R for data manipulation and analysis

Statistics (Advantageous) – Basic statistical methods and forecasting

Excel – Intermediate to advanced use for data review and analysis

Cloud Platforms (Advantageous) – Experience with cloud-based data environments

Soft Skills :

Strong business acumen and commercial awareness

Excellent verbal and written communication skills

Critical thinking and structured problem-solving

Team collaboration and cross-functional communication

Ability to simplify complex data for decision-makers

Experience & Qualifications :

Bachelor’s degree in Computer Science, Statistics, Mathematics, Business Analytics , or a related quantitative field

5 years of experience in business intelligence or data analytics roles

Strong understanding of data warehousing, ETL processes, and BI reporting

Proven experience with relational databases and SQL

Experience delivering insights and visualizations with BI tools

Prior exposure to cloud data warehousing and programming languages (Python / R) is advantageous