BI Developer – Market Intelligence at SA: Central Energy Fund

REQUIRED MINIMUM QUALIFICATIONS AND EXPERIENCE

• Minimum 6-8 years of Business Analytics with 3 to 5 years specific experience as a BI Developer and at Specialist/ supervisory level
•  Matric, Bachelor’s Degree (NQF Level 7) degree in qualification in Finance / Data science, Any additional qualification specific to energy sector is desirable
• Honours (NQF Level 8) or postgraduate diploma (NQF Level 8) as an added advantage.
• Experience with designing and developing BI reports based on needs analysis
• Experience with SQL, ETL processes and data warehousing concepts
• Experience integrating data from multiple sources (including financial databases, CRM systems and market research platforms)
• Experience with predictive modelling and statistical analysis techniques

DESIRED ADDITIONAL SKILLS/ COMPETENCIES

• Expert in BI tools
• Advanced Excel
• Critical Reasoning skills
• Process automation skills
• Basic statistical analysis skills
• Business Acumen
• Software and programming languages (Desirable)

KEY PERFORMANCE INDICATORS

 BI Report development

• Design, develop, and maintain comprehensive BI reports and dashboards that consolidate data from multiple internal and external sources.
• Integrate diverse datasets (e.g., financial, market, operational) to create a holistic view of market trends, investment performance, and portfolio analytics.
• Ensure data integrity and consistency across all reports, utilizing data cleansing and transformation processes where necessary.

Data Integration and Management

• Extract, load, and integrate data from multiple sources such as financial databases (e.g., Bloomberg, Capital IQ), internal CRM systems, and external market reports.
• Build data pipelines and automate data integration processes to streamline reporting and analysis.
• Maintain data storage systems and ensure the accuracy and availability of data for reporting and analysis purposes.

Advanced Analytics and Insights

• Perform advanced data analysis to provide insights into market trends, industry dynamics, and economic factors that influence investment decisions.
• Use data visualization tools (e.g., Power BI, Tableau) to present complex data in an easily understandable format for stakeholders.
• Develop key performance indicators (KPIs) and metrics that track the performance of the firm’s investments and market positioning

Support to investment team

• Work closely with investment teams to understand their information needs and develop tailored BI solutions to support deal origination, due diligence, and portfolio management.
• Provide real-time data insights that help inform investment strategies and identify emerging opportunities or risks.
• Support decision-making by delivering ad-hoc analyses and customized BI reports as requested by senior leadership.

Data governance and quality assurance

• Implement data governance practices to ensure data accuracy, reliability, and security in all BI reports and dashboards.
• Perform regular quality checks on data and reports to maintain high standards of reporting integrity.
• Ensure continuous improvement through technology and tools optimisation