Careers

Group Planning Analyst

ROLE DETAILS

Job Title Group Planning Analyst
Line manager Senior Group Accountant (Financial Planning, Control and Analysis)
Location Edinburgh
Department Finance Corporate

PURPOSE OF ROLE

This role is a key part of the team responsible for responsible for the preparation of high quality, transparent and reliable management and Board-level corporate financial information used to support decision making, short to mid-range financial planning and control for the Group, external debt raising and debt management processes and merger and acquisition/business development activity.

The role exists to support the Senior Group Accountant (Financial Planning, Control and Analysis) and the team to:

  1. Deliver management information, budgets, forecasts and other decision support information which:
    1. Focuses on adding value
    2. Enables optimal decision making
    3. Demonstrates clear financial control
    4. Is clear, concise, timely and materially accurate
  2. Monitor group liquidity under multiple scenarios and recommend remedial actions
  3. Provide financial modelling support for any capital raising activity (both debt and equity). Provide support for any subsequent debt facility compliance. Liaise with external advisors (bankers, accountants) as required.
  4. Take responsibility for the preparation of financial forecasts for projects such as acquisitions, disposals, farm-ins and farm-outs and their integration into Group forecasts to support Board and funding decisions and processes
  5. Both support and challenge internal stakeholders to quality control any financial information being provided, ensuring adherence to Group policies and procedures

The role will be part of team of two Group Planning Analysts led by the Senior Group Accountant (Financial Planning, Control and Analysis) to enable effective delivery of the above objectives and who will jointly perform all the tasks below.

The role is fully empowered to operate with a high degree of autonomy and judgement where performance demonstrated capability.

PRINCIPLE DUTIES

  • Influencing and collaborative working
    • Use influence to coordinate activities of cross functional teams to ensure any deadlines are met
    • Actively cultivate an enthusiasm for change, innovation and continuous improvement through constructive challenge and positive engagement
  • Project/Task Management and Delivery
    • Be proactive and look to identify the needs of the business, raise with manager and as a team develop appropriate work plans and deliverables
    • Seek to identify problems and challenges in advance and lead finding solutions
  • Annual Corporate Budget
    • Assist the Senior Group Accountant (Financial Planning, Control and Analysis) in the planning and co-ordination of the Annual Budget process
    • Be responsible for the preparation of the budget templates used to consolidate the asset, project and department/office budgets
    • Produce summary schedules for inclusion in the presentations and papers for the Executive Committee and Board
  • Quarterly Performance Reviews (“QPR”)
  • Take responsibility for the preparation of the templates used to gather the finance inputs to the QPR process and develop/maintain them to ensure they continue to be fit for purpose
  • Provide support in the preparation of the Corporate Finance section of the QPR report
  • Group Forecast
    • Co-ordinate and challenge all of the inputs needed to run the Group Forecast
    • Update and maintain the Group Forecast Model(s) in Excel (current + 5 years forward) for different scenarios as required for monthly reporting, budgeting/quarterly forecasting, corporate cashflow submission to lenders and ad-hoc requirements including transactions and working capital reports
    • Reconcile the outputs from the Group Forecast Model(s) to ensure accuracy (to be reviewed by the Senior Group Accountant (Financial Planning, Control and Analysis))
    • Seek to continually develop and improve the Group Forecast Model(s)
  • Group Monthly Financial Report (“GMFR”)
    • Run and reconcile the monthly actuals file and ensure the report captures all controllable costs for Actual v Budget v Forecast reporting
    • Be responsible for the preparation of the GMFR and other related reporting supported by the Senior Group Accountant (Financial Planning, Control and Analysis)
  • Debt Redetermination and associated Liquidity Tests
    • Run and assess the impact of technical and economic assumptions on the borrowing base amount, liquidity test and corporate headroom during redeterminations and on an ad-hoc basis as required
  • Corporate/Banking Headroom Monitoring
    • Assist with monitoring of debt facility covenants or applicable facility tests and corporate minimum liquidity buffers
    • Track the value, trigger and expected timing of commitments
    • Help prepare and provide regular funding updates to the CFO/ExCo/Board
  • Year End/Interim
    • Provide input to the Going Concern and Viability Statement papers for the Board/Audit Committee and capital expenditure guidance and analysis for the markets
  • Corporate Budget Monitoring/Revisions
    • Co-ordinate revisions through to approval in line with procedures and maintain the approvals register
    • Pro-actively track actuals/forecast against the corporate budget to ensure that timely action is taken so that commitments do not breach approvals
    • With input from the Senior Group Accountant (Financial Planning, Control and Analysis), review higher value revisions prior to approval to ensure quality and material accuracy
  • Project Work
    • As assigned i.e. transactions decision support, portfolio management cashflow forecasting
    • Working capital reports
    • Integration of any acquisitions into the Group’s budgeting, forecasting and reporting processes
  • Procedures
    • Update Planning procedures to ensure they are fit for purpose
    • Identify, initiate and implement improvements once agreed with the Senior Group Accountant (Financial Planning, Control and Analysis) to maximise value and efficiency
  • Active participation in Finance Management Team meetings and decisions as well as in Project Meetings
  • General assistance as required to Group Treasurer and Planning Manager, Director of Finance, Chief Finance Officer/ExCo/ Board

EDUCATION/EXPERIENCE/SKILLS REQUIRED

Education

  • Qualified or near qualified accountant with relevant experience in similar roles, a high level of natural systems and IT literacy and previous exposure to corporate transactional work

Relevant Experience/Skills

  • Essential:
    • A highly developed natural aptitude for IT and systems particularly Excel and Microsoft Office applications generally. The candidate will be required to maintain/develop sets of linked spreadsheets, PowerPoint and Word files and interrogate/ manipulate data effectively.
    • Strong financial modelling skills – building financial models from the ground up, developing reasoned and logical forecasting assumptions and assessing modelling results for reasonableness
    • A full appreciation of the impact of corporate transactions throughout the income statement, cashflow and balance sheet
    • A desire for efficient processes and automation
    • Pro-active person with a desire to deliver high quality work on time whilst juggling multiple, and often conflicting, priorities and who strives to improve what we do in order to maximise value and efficiency
    • Excellent communicator who can operate effectively at all levels of the business
    • Relevant experience to apply to budgeting and forecasting at a Group corporate level
  • Highly desirable:
    • Oil and gas industry knowledge
    • Experience in corporate transactions and working capital reports or the financial processes surrounding listed company circulars/prospectuses and working capital reports.
    • Multi-currency accounting
    • Group accounting experience
    • Listed company exposure
  • Preferred but not essential:
    • Corporate audit experience
  • To support our multi-country locations, conversational competence in French or Spanish would be advantageous, but is not essential. At Cairn, our aim is to continually create and sustain a culture-rich nimble working environment where diversity and inclusion are hugely valued.
  • Applicants must have the right to work in the UK without sponsorship.

Company Values and High Performing Behaviours

Values

  • Respect
  • Relationships
  • Responsibility

High Performing Behaviours

  • Be Entrepreneurial
  • Be Empowered
  • Be Collaborative
  • Be Safe
  • Be Focused
  • Be Open
  • Be a Leader 

APPLY FOR THIS ROLE