BI Analyst
- Centurion, Gauteng
- Permanent
- Full-time
-POSITION INFO:Senior Business Intelligence AnalystLocation: 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 analysisETL Tools - Building and maintaining automated data pipelinesData Warehousing - Concepts, architecture, and tools (e.g., Snowflake, Redshift, BigQuery)Data Modeling - Star and snowflake schema, dimensional modelingBI Tools - Power BI, Tableau, Looker (dashboarding and data visualization)Data Analysis - Trend identification, anomaly detection, insight generationScripting (Advantageous) - Python or R for data manipulation and analysisStatistics (Advantageous) - Basic statistical methods and forecastingExcel - Intermediate to advanced use for data review and analysisCloud Platforms (Advantageous) - Experience with cloud-based data environmentsSoft Skills:Strong business acumen and commercial awarenessExcellent verbal and written communication skillsCritical thinking and structured problem-solvingTeam collaboration and cross-functional communicationAbility to simplify complex data for decision-makersExperience & Qualifications:Bachelor's degree in Computer Science, Statistics, Mathematics, Business Analytics, or a related quantitative field5 years of experience in business intelligence or data analytics rolesStrong understanding of data warehousing, ETL processes, and BI reportingProven experience with relational databases and SQLExperience delivering insights and visualizations with BI toolsPrior exposure to cloud data warehousing and programming languages (Python/R) is advantageous
ExecutivePlacements.com