Senior Business IntelligenceAnalyst (Data Modeller)

HR Genie; Pretoria; Hybrid; ZAR 500,000 - 800,000; Full time

Job summary

A prominent recruitment agency in South Africa is seeking a Senior Business Intelligence Analyst. In this hybrid role, you will gather and analyze data, develop reports, and drive strategic decision-making using BI tools. The ideal candidate will have a Bachelor’s degree, 5-8 years of experience, and proficiency in SQL and data visualization tools. This position offers a 6-month contract based in Centurion, combining both on-site and remote work.

Qualifications

• 5-8 years of experience in business intelligence or data analysis.
• Strong understanding of data warehousing concepts and ETL processes.
• Proficiency in SQL with experience working with relational databases.

Responsibilities

• Collaborate with stakeholders to gather business needs and translate into data requirements.
• Identify, collect, and clean data from various sources ensuring accuracy.
• Conduct in-depth data analysis to identify trends and insights.

Skills

Data Analysis

Data Warehousing

Data Visualization

Reporting

Education

Bachelor's degree in a quantitative field

Tools

SQL

Tableau

Power BI

Looker

Job description

Centurion | 6 months contract to start | Hybrid 2 days on site in Centurion

Role Purpose :

The Senior Business Intelligence (BI) Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Senior BI Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences.

Responsibilities and work outputs :

• Requirements Gathering : Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation : Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing : Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes : Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation : Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development : Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Performance Monitoring : Monitor the performance of BI solutions and identify areas for improvement.
• Documentation : Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication : Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning : Stay up to date with the latest BI trends, tools, and techniques.
• Mentorship : Mentor junior analysts and provide guidance on best practices.

Key Skills :

Data Analysis

Data Warehousing

Data Visualization

Reporting

Experience and Qualifications :

Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.

5-8 years of experience in business intelligence or data analysis.

Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.

Proficiency in SQL and experience working with relational databases.

Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).

Strong analytical and problem-solving skills.

Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.

Ability to work independently and as part of a team.

Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.

Experience with scripting languages (e.g., Python, R) is a plus.

Knowledge of statistical methods and techniques is a plus