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:

• Bachelors 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