Corporate Finance and Modelling Analyst

Purpose of the role

In onesentence, describe the overall purpose of this job.

To supportthe Senior Financial Modeler and wider Corporate Finance / FP&A teams byproviding analysis and insight from the SGN Strategic Model.


List the keyresponsibilities of the job (no more than 5).

Running scenarios in the SGN Strategic Model, analysing variances and reporting findings to stakeholders
Maintenance and development of the SGN Strategic Model including new model build
Ad hoc support to Treasury/Corporate Finance/FP&A teams to ensure common assumption sets / outputs are adhered to across the board


Knowledge,Skills and Experience

Describewhat, if any, academic qualifications/certifications are essential in this job?

Numerate degree (Finance/Maths/Engineering)
An understanding of accounting/finance principles is required but a recognised accounting qualification is not essential


Describewhat technical skills and job knowledge/experience are essential in this job?

Strong Excel skills with a grounding in the fundamentals of Best Practice financial modelling
Desire to learn advanced technical Excel/Modelling skills
Strong communication skills with the ability to describe complex financial information to non-finance staff and senior managers
Good personal work management skills to manage multiple demands for different stakeholders including ad hoc requests.


Previouslength of experience required in similar role?

2-3 years' experience in a corporate finance / financial modelling environment


In terms ofskills, qualifications, job knowledge and experience, what are the keydifferences between... A. This job and the one above it? And B. This job and theone below it?


A - The roleabove this is differentiated by a higher level of technical modellingskills/experience, in depth commercial experience and experience in internal/externalstakeholder management/negotiation. This role will predominantly be fed tasksthrough the senior modelling manager.
B - There isno role below this.




Problem Solving & Complexity
Generallyspeaking, what are the typical problems encountered in this job? Pleasehighlight one of the below options and provide further details-

Regularly non-routine / complex, with solutions requiring analysis, experience and knowledge.


Furtherdetails of the above.


Describe atypical problem that the job holder is expected to deal with themselves.

Ad hocanalysis requests with short deadlines are common requiring modelling scenariosto be ran quickly but with an attention to detail. All work will be reviewedwith the senior modelling manager but the role requires the ability to sensecheck outputs independently and follow governance procedures themselves avoidthe need for re-runs.


Describe atypical problem that the job holder will need to seek advice on.

TheStrategic Model is complex with many dependencies between data from differentsources. The job holder will need to seek advice from the wider teams to ensurethat specific analysis requests have not overlooked input requirements forother teams of will have unforeseen consequences/conflicts with existingassumption sets.


Describe atypical problem that the job holder will need to escalate for someone else todeal with.

Requestconflicts from different stakeholders are common and should be escalated to thesenior modelling manager to manage priorities and agree workable timelines. Therole often requires data input from other teams which may require a level ofstakeholder management behold the remit of this role.


What is themost difficult aspect of this job?



Does thisjob require someone who can think strategically / tactically?
At first,no. but it is expected that the role will develop over time as knowledge grows toone where they can make their own recommendations.

Impact of role

If the job holder 'gets thingsvery right, or very wrong', how far reaching would this be inside SGN?

The output of the Strategic Modelsis used directly by senior executives for short term strategic decision making.
However there are strictgovernance processes in place to ensure activity is reviewed and comparedagainst other analysis to avoid material error impacts.


If the job holder 'gets thingsvery right, or very wrong', how far reaching would this be outside SGN?

We regularly send versions of thestrategic model, or specific output data to shareholder analyst teams and themodel outputs are regularly used in presentations to the board/shareholders. This role will nothave direct contact with shareholders, but their analysis will impactinformation that they receive. Again strict governance processes are in placeto minimize material error.

To what extent does the job directly contribute to departmental/company objectives?

The role directly supportsregular ofgem submissions such as the RFPR, the annual budget process andplanning activity such as the 15 year plan.

What timeframe does this jobmainly operate within (i.e. does it deal mainly with current, day-to-dayissues, or deal regularly with long term change or strategic issues?)
The role mainly deals with longerterm strategic analysis, but will be involved in the annual budget settingprocess and recurring annual ofgem reporting.


Describe the most impactfuldecision(s) the job holder will typically make.
Analysis carried out by this rolewill be used directly in decision making by senior management.

Does therole have accountability for the performance and results of multiple relatedunits? Please specify how many.
No. theywill be accountable only for their own performance and results.






Influence/ working relationships.

Who does thejob holder interact with within the business on a regular basis?
Regularinteraction with Regulatory finance teams, tax, treasury and FP&A to ensurethe most up-to-date input data and assumptions are maintained in the strategicmodel.


Who does thejob holder interact with outside the business on a regular basis?
No regularoutside interaction.

How does the job holder interactwith these stakeholders and to what level? (For example, are they exchanging information, building rapport,enhancing SGN reputation, handling complaints, influencing and persuading, conductingcomplex negotiations?)
This is aninternally facing role which relies on building good working relationships withdifferent team across finance to ensure that information requests are addressedpromptly and ensuring different stakeholders appreciate their impact on theoverall modelling process. A level of negotiation/influencing may be requiredto ensure interim deadlines are met by data providers, or conflicting requestsare prioritized appropriately, but the senior modeling manager will help withthis.


Resource - Who /what are theyresponsible for? (Use real numbers, values and examples if possible)

How many, ifany, people does the job holder manage / supervise? Please provide their jobtitles. (if none, please state None)
None

Ifapplicable, describe at what level this management / supervision is undertaken(e.g. do they deal with quality control, work allocation and planning,coaching, recruitment, 'hard' people management issues such as sicknessabsence, conduct, capability etc.?) (if none, please state None)
n/a

What valuebudget does the job holder set, manage or spend? (if none, please state 0)
0

What assets/ equipment does the job holder manage or control? (if none, please stateNone)
None

What levelof projects does the job holder manage or control? (if none, please stateNone)
None