Vacancy Details

Specialist Financial Modelling and Business Intelligence 2024/01/31   JHB Sandton

Job Ref #: CEF-24
Industry: Project Management
Job Type: Permanent
Salary: Market Related


Description:

To develop and maintain frameworks and digital platforms for financial modeling and business intelligence to support the evaluation, monitoring, and reporting of investments and project-related performance. (Financial modeling is the primary function of this role, whereas business intelligence is the secondary function to support project controls. These functions collectively provide CEF with real-time insights for optimal decision-making)

Requirements:

REQUIRED MINIMUM QUALIFICATIONS AND EXPERIENCE

 

  • Minimum 6 – 8 years (of which 3-5 years must have been a Specialist/ Supervisor) in Portfolio Management / Project Management / Investment Management with relevant experience, preferably in the Energy, Oil & Gas, and/or Mining Industries.
  • Matric (NQF Level 4) and Bachelor’s degree/ BTech (NQF Level 7) in Engineering / Quantity Surveying / Construction Management / Business Management / Commerce
  • Honours (NQF Level 8) or post graduate diploma (NQF Level 8) as an added advantage.
  • Portfolio Management / Project Management / Investment Management with relevant experience, preferably in the Energy, Oil & Gas, and/or Mining Industries.
  • Proven experience in developing, interpreting, and analysing financial models (Projects and Investment) that inform investment decisions.
  • Proven experience in writing and analysing reports and/or submissions intended for shareholders and key stakeholders to inform and recommend business decisions.
  • Professional Qualification, Accreditation, or Membership as a Financial Modelling and Valuation Analyst (FMVA) or Commercial Banking and Credit Analyst or equivalent with a recognized professional body (i.e., CFI, CFA, etc.)

 

DESIRED ADDITIONAL SKILLS/ COMPETENCIES

  • Understanding project systems, external and internal governance systems, and applicable legislation and regulations.
  • Computer literacy and experience using MS Office Suite / Project Online / SharePoint / Office 365 toolsets to support Project delivery.
  • Ability to track project metrics and advise on business decisions.
  • Complete understanding of relevant company financial reports, procedures for payments, monthly cash flow reports, project reporting, and project reporting experience.
  • Demonstrated ability to develop and manage transparent and effective reporting systems.

KEY PERFORMANCE INDICATORS 

Financial Perspective

  •  Research, benchmark, recommend, and implement (if approved) comprehensive budget, forecast solutions, etc.
  • Estimate project portfolio and projections.
  • Analyze and present financial and accounting information when evaluating initiatives, projects, transactions, and/or investments.
  • Balance portfolio between profit-making and non-profit-making initiatives, projects, transactions, and/or investments.
  • Plan, monitor, and report initiatives, projects, transactions, and/or investments; ·   Assess the strategic fit and/or align project portfolio with strategic requirements.
  • Update and periodically archive financial models after each earnings rollout or other similar corporate actions.
  • Assess viability and ‘do-ability’ and/or desktop analysis of initiatives, projects, transactions, and/or investments and make recommendations to GM: Project Management Unit.
  • Pilot project with clear scope and deliverables

Internal Business Process Perspective – Financial Modelling

  • Research, assess, and develop (if approved) financial models (in relevant platforms) based on historical information and benchmark with other available industry-specific operating metrics and make recommendations.
  • Ensure that the latest best practices/ benchmarks are used in developing Financial Models for analysis of initiatives, projects, transactions, and/or investments and make recommendations to relevant stakeholders.
  • Conduct scenario analysis based on microeconomic and macroeconomic factors to assess business risk.
  • Analyze and identify data required to support model tracking.
  • Evaluate companies using various financial valuation methods, such as DCF, comparable company analysis, and capital structure analysis.
  • Ensure the new models’ accuracy while enhancing the quality of existing models; ·      Recommend and implement process improvement measures.
  • Identify key financial and non-financial risks and advise mitigation plans.
  • Conduct scenario and sensitivity analysis with the intent to support investment activities; and
  • Update    the    financial    models    after    each acquisition, partnership, earnings rollout/dividend pay-outs and/or other similar corporate events.

 Internal Business Processes Perspective – Business Intelligence

 

Internal Business Processes Perspective – Business Intelligence

  • Research, assess, and develop (if approved) Business Intelligence (BI) platforms/solutions/systems.
  • Collaborate with team members and/or cross functional teams and/or external consultants and specialists for the purpose of collecting data and executing the company’s mission.
  • Analyse business requirements and processes and make recommendations to executive management for implementation.
  • Provide reports through office applications to improve business processes.
  • Create and maintain documentation that includes the design, requirements and user manuals.
  • Identify the development needs for the purpose of streamlining and improving the operations of collaborative projects and joint ventures for efficiency and profitability.
  • Ensure that the BI platforms/solutions/systems are-

o Providing accurate and up-to-date schedules, including budgets, cash flows, and resource plans

o Complying with the quality standards set, including ensuring that technical support and guidance is provided

o Regularly updated, including conducting regular quality checks and ensuring that corrective action is undertaken

Internal Business Process Perspective – Performance Management 

Research, assess, and develop (if approved) Business Intelligence (BI) platforms/solutions/systems for:

  • Hosting CEF’s Project Systems (i.e., frameworks, guidelines, processes, policies, standard operating procedures (SOPs), templates, and tools)
  • Templates for different types of Projects (Contracts, Processes, Concept Reports, Business Case templates
  • Tracking the performance of each project at various phases and raising concerns to the GM: Project Management Unit (GM: PMU) and respective Project Leads
  • Archiving system (SharePoint & Power BI) for Project Management In liaison with various stakeholders:
  • Analyse the project portfolio (monitor the sequencing of current and proposed projects, note relationships or interdependencies between projects, scope, etc.) and formulate recommendations regarding project schedule, funding, and optimization to maximize the benefits best realized.
  • Administer a dashboard to track the performance of each project at various phases; and create platforms for knowledge management.

Internal Business Processes Perspective – Project Management

  • As a significant lever, will be responsible for driving and implementing sustainable change and directly supporting the Project Managers to monitor project milestones or KPIs /dashboards.
  • Project Specific Support for projects implemented under other General Managers (GMs), · Project Scheduling and Controlling support (MS Projects, Primavera).
  • Performing site inspections to obtain an understanding of the major assets, how they are being used with the business, and for discussion of future plans for the assets.
  • Assess, monitor and reports:
  • timing and quality of cash flows, debt-service coverage ratios

 

 Internal Business Process Perspective – Business Analysis Planning

  • Assist in performing financial benchmark that includes reporting of major performance indicators.
  • Identifying critical assumptions and facts that underline valuation estimates and provides alternative approaches as required.
  • Creating progressive financial models that capture the future operating, investing and financing activities, and helps clients determine future profitability, financial position, and risk.
  • Preparing robust business planning or transaction models by applying detailed understanding of commercial practicalities, accounting and finance knowledge, technical ability, quantitative analysis, and logic

Stakeholder Management Perspective

  • Collaborate with external and internal stakeholders, valuation consultants and prepare:
  • Annual valuation of “target company” and perform audit financial modelling, business intelligence and reporting.
  • Quality strategic inputs in relevant management.
  • Convey compelling motivations for collaborative projects and associated funding applications.
  • Advise and provide professional support to designated project and other parties to execute on their accountabilities within guidelines set by GM Projects
  • Maintain professional contact with finance teams on an ongoing regular basis to understand underlying operating environment issues and events on site to enable the formulation of value-added financial/accounting and reporting advice.

Learning & Growth Perspective

  • Identify skills and/or knowledge gaps and identify courses, workshops, training events for continuous improvement.
  • Strive to meet performance objectives by understanding the importance and urgency of tasks/projects, and by applying knowledge, skills and experience toward task accomplishment to the benefit of the team, department and/or organization.
  • Ensure levels of self-knowledge, -skill and -competence are in place to meet financial modelling and business intelligence objectives, and to contribute meaningfully toward organisational goals.

 

Closing Date: 14 February 2024

NOTE: 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. 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. 

A competency test will be conducted as part of the selection process in form presentation.



Back