BI Developer – Market Intelligence

CEF is a Schedule 2 state owned diversified energy company reporting to the Department of Mineral Resources and Energy. The Mandate of CEF is to contribute to the security of energy supply of South Africa and the Region through exploration, acquisition, development, marketing and strategic partnership. It is derived from the CEF Act (No 38 of 1977) and the Ministerial directives issued thereafter.

 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

Closing Date: 24 November 2024

NOTE: This is a re-advertisement position previously applied candidates are encouraged to re-apply:  The successful candidate/s for the advertised position/s will be required to undergo personnel suitability checks, which includes, criminal records, citizenship, financial checks, qualifications and previous employment (Reference checks). It is the responsibility of the applicant to make sure that foreign qualifications are evaluated by the South African Qualifications Authority and the evaluation certificate is attached to the application on submission. If you do not hear from the CEF SOC three months after the closing date of the advertisement, consider your application unsuccessful.  CEF SOC reserves the right to not fill this position. CEF SOC is an equal employment opportunity and affirmative action employer, and it is committed to the achievement and maintenance of diversity and equity in employment, especially in respect of race, gender and disability. Preference will be given to South African Citizens. This position will be filled in accordance with the CEF SOC Employment Equity Plan. 

This position will be filled in accordance with the CEF SOC Employment Equity Plan and preference will be given to females from previously disadvantaged individuals, especially Whites, Indians and Coloured.