Graduate Analyst
- Recruiter
- We Are SSG
- Location
- Surrey
- Salary
- 22000.00 GBP Annual
- Posted
- 17 Jul 2018
- Closes
- 31 Jul 2018
- Sectors
- Accountancy
- Contract Type
- Permanent
- Hours
- Full Time
The role is heavily focused on data analysis and the candidate will be required to understand complex formulas and carry out extensive financial and performance reporting within the team.This role would suit an individual with strong analytical abilities combined with a high attention to detail and the ability to spot trends, errors and anomalies.
The department are all very detail focused, working with excel and other models.This role is going to suit someone who is logical, analytical, a whizz on Excel and enjoys data manipulation, and once training is completed enjoys working closely with the team but largely on their own projects, yet is a strong communicator both internally and externally. In terms of education we are looking for someone either with a degree or A Levels in Mathematics, Business Studies or Economics or equivalent.
- Liaise with customers to obtain all the required information needed to model asset value quotations.
- Use the information obtained in one of a number of financial models in order to produce an AV quotation for customers.
- Use market intelligence to maximise IRR's in conjunction with the Strategic Pricing Manager, the Head of Commercial, Development Director and the wider AV team.
- Handle customer and internal queries around AV quotations and asset adoption processes.
- Make changes and improvements to the data models with proficiency in advanced Excel functions (experience in Visual Basic for Applications is also beneficial but not a necessity).
- Ensure that data stored in databases is kept up to date, including accepting new sites and altering/cancelling won sites.
- Oversee the sending and receiving of monthly contracts.
- Oversee the administration of monthly developer and contracts.
- Liaise with other departments to ensure that all new contracts are returned before an AV for a network is paid.
- Produce reports/analysis for the management team as and when required.
- Provide analytical support to the rest of the team on spreadsheet/database issues.
- Support account managers, by providing analysis on specific customers or market segments
- Regulatory and fund reporting where required.
- Educated to degree or A Level level, preferably in the field of mathematics, business studies or economics;
- Excellent data manipulation and analysis capabilities;
- Advanced Excel skills including functions ("vlookup", "countif", "pivot table", etc);
- Basic Access/database skills;
- Ability to use own initiative and excellent at problem solving;
- Logical / analytical thinker;
- Excellent attention to detail
- Strong communication skills.