Job Description

SUMMARY:
-
POSITION INFO:
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