Business Intelligence (BI) Engineer

Agile People; Johannesburg; On-site; ZAR 300,000 - 600,000; Full time

Job summary

An established industry player is seeking a skilled Business Intelligence Analyst to drive data-driven decision-making. In this dynamic role, you'll collaborate with senior leadership to align BI strategies with business objectives while delivering high-quality BI solutions. Your expertise in Power BI will be crucial as you develop dashboards and reports that provide actionable insights. With a focus on data integrity and governance, you'll lead end-to-end BI projects and engage with clients to refine their data needs. If you are passionate about transforming data into meaningful insights and thrive in a fast-paced environment, this opportunity is perfect for you.

Qualifications

• 3+ years in BI, Data Engineering, or Data Analytics roles with advanced SQL skills.
• Experience with ETL processes and cloud-based data platforms like Azure.

Responsibilities

• Deliver scalable BI solutions and conduct data analysis for actionable insights.
• Lead BI projects from requirement gathering to deployment and maintenance.

Skills

SQL Server Management Studio (SSMS)

ETL Development

Data Analysis

Power BI

Analytical Skills

Problem-Solving Skills

Education

Bachelor’s degree in Data Science

Certifications in Business Intelligence

Tools

Power BI

Azure Data Factory

Jira

Confluence

Job description

OBJECTIVES (main duties and responsibilities)

• Collaborate closely with senior leadership to align BI strategies with business objectives.
• Deliver high-quality, scalable BI solutions that provide actionable insights to clients.
• Lead end-to-end BI projects, including requirement gathering, design, development, deployment, and ongoing maintenance.
• Conduct data analysis and translate findings into meaningful dashboards and reports using Power BI.
• Develop and optimise ETL processes and data pipelines to ensure efficient data flow and transformation.
• Work across multiple departments within AgrigateOne (AG1) to gain a comprehensive understanding of data sources and business operations.
• Effectively prioritise and manage multiple BI initiatives, ensuring timely and high-quality delivery.
• Engage with clients to understand their data needs, create dashboard mock-ups, and refine requirements.
• Maintain comprehensive project documentation, including Confluence documentation and Jira ticketing for project tracking.
• Ensure data integrity, security, and governance best practices are upheld.

ROLE REQUIREMENTS

Formal Qualifications

• Bachelor’s degree in Data Science, Computer Science, Business Analytics, Information Systems, or a related field.
• Relevant certifications in Business Intelligence, Data Engineering, or Analytics (e.g., Microsoft Certified : Azure Data Engineer, Power BI Certification) are beneficial.

Knowledge, Skills & Experience

• Minimum 3 years of experience in a BI, Data Engineering, or Data Analytics role.
• Advanced proficiency in SQL Server Management Studio (SSMS) and database management.
• Strong experience with ETL development, data transformation, and pipeline management.
• Expertise in Power BI, including DAX, Power Query, and visualization best practices.
• Solid understanding of data warehousing concepts and architecture.
• Strong analytical and problem-solving skills with a detail-oriented mindset.
• Experience with cloud-based data platforms, preferably Microsoft Azure (Azure Data Factory, Azure Synapse, or similar tools).
• Ability to communicate complex data concepts effectively to both technical and non-technical stakeholders.

Job Related Experience

• Experience working under tight deadlines and managing multiple priorities.
• Ability to work independently as a self-starter while contributing to a team-oriented environment.
• Strong understanding of business process flows, data governance, and documentation best practices