Junior Analyst (intermediate MS Excel skills essential)

Core-Asset Consulting Ltd; Dundee; On-site; GBP 25,000 - 35,000; Full time

Job summary

A financial services firm in Dundee is seeking an Investment Assistant. The ideal candidate will have strong MS Excel skills and experience in supporting investment teams. Responsibilities include data analysis, report delivery, and assisting with financial tasks. Competitive salary and wider benefits package offered.

Benefits

Highly competitive salary

Wider benefits package

Qualifications

• Strong IT skills, particularly MS Excel.
• Some experience in a similar position, or recent graduates with strong MS Excel.
• Attention to detail is essential.

Responsibilities

• Assist in various activities to support the investment team.
• Provide suitable data for research.
• Create dealing spreadsheets as required.
• Deliver monthly packs and other reports.
• Assist with ad hoc and annual tasks.

Skills

MS Excel

PowerPoint

FactSet

Data analysis

Interpersonal skills

Accuracy

Numeracy skills

Analytical ability

Job description

Job Description

We are working with our client, a financial services firm, on an excellent permanent opportunity for an Investment Assistant to join their team based in Dundee.The successful candidate will play a key role in supporting the investment team with various queries using MS Excel to provide suitable data and create impactful spreadsheets and reports.

We are delighted to receive applications from individuals who have strong MS Excel skills (pivot tables, vlookup, CAGR etc.) and an interest in moving into a financial services firm.

Skills/Experience

• Strong IT skills, particularly MS Excel (essential), PowerPoint, FactSet (desirable).
• Some experience in a similar position, perhaps with experience in administration, data analysis, or operations.Graduates with strong MS Excel skills will also be considered.
• Hard working and conscientious
• Accuracy - attention to detail is essential
• Clear analytical ability
• Strong numeracy skills
• Exceptional interpersonal skills
• Proactive, with ability to work on own initiative to meet deadlines
• Ability to multitask, quick to learn
• Team player - small team requires good co-operational skills; happy to assist in all tasks if needed

Core Responsibilities

• Assist in a broad range of activities to support the investment team.
• Responsible for provision of suitable data to assist research team, via excel and other systems
• Creation of dealing spreadsheets as required
• Provision of ESG data analysis to holdings using external systems
• Develop and maintain data relating to economic and macros indicators
• Delivery of monthly packs and other reports as needed by the team
• Creation and maintenance of various financial screens for the team
• Monitor parameters and characteristics of funds
• Assist in the delivery of ad hoc and annual tasks for the company's presentations

Benefits

• A highly competitive salary
• Wider Benefits package

Core-Asset Consulting is an equal opportunities recruiter and we welcome applications from everyone irrespective of age, disability, gender, gender identity or expression, race, colour, ethnic or national origin, sexual orientation, religion or belief, marital/civil partner status or pregnancy.

Job reference: 16175

To apply for this vacancy applicants must be eligible to work in the UK in accordance with the Immigration, Asylum and Nationality Act 2006.