At a Glance
- Tasks: Manage and process trade data using advanced Excel models.
- Company: Global investment specialist with a focus on financial services.
- Benefits: Competitive salary, potential for permanent role, and hands-on experience.
- Other info: Opportunity for career growth in a collaborative office setting.
- Why this job: Join a dynamic team and enhance your finance skills in a thriving environment.
- Qualifications: Strong Excel skills and basic understanding of accounting principles required.
The predicted salary is between 30000 - 30000 £ per year.
We are working with a global investment specialist that provides specialized financial services to its clients. They are looking for a Finance Analyst to join their team in their London office.
Your Role:
- Developing and maintaining robust excel models to process the trade data
- Apply accounting logic to generate DR/CR journal entries from trade data
- Reconcile trade related entries with the general ledger
- Collaborate with the accounting team to ensure proper data mapping between Excel files and the accounting system
- Support data quality checks and help implement error-handling procedures within the excel files
Your Skill:
- Strong proficiency in excel is very key, including: Advanced formulas (eg. Vlookup, Index/Match, Sumifs), Pivot Tables and data transformation
- Basic VBA (not key but would be desirable)
- Have basic understanding of accounting principles especially double-entry bookkeeping
- Be a part qualified candidate or have equivalent work experience
Finance Analyst employer: Trace | Expert Accountancy & Finance Recruitment
Join a dynamic global investment specialist in London, where you will thrive in a collaborative and innovative work culture. With a focus on employee growth, the company offers opportunities for professional development and the potential for permanent employment after your initial contract. Enjoy the benefits of working in a vibrant city, surrounded by industry leaders, while contributing to impactful financial services.
Contact Details:
Trace | Expert Accountancy & Finance Recruitment Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Finance Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the finance industry, especially those working in investment firms. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your Excel skills! During interviews, be ready to demonstrate your advanced Excel knowledge. Maybe even bring along a sample model you've created to showcase your abilities.
✨Tip Number 3
Prepare for technical questions! Brush up on accounting principles and be ready to discuss how you would handle trade data processing. This shows you're not just a numbers person but also understand the bigger picture.
✨Tip Number 4
Apply through our website! We make it super easy for you to find and apply for roles like the Finance Analyst position. Plus, it helps us keep track of your application and get back to you quicker!
We think you need these skills to ace Finance Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Finance Analyst role. Highlight your advanced Excel skills and any relevant experience in managing trade data. We want to see how you fit into our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about finance and how your skills align with our needs. Let us know what excites you about working with a global investment specialist.
Showcase Your Excel Skills:Since advanced Excel skills are key for this role, consider including specific examples of how you've used Excel in past roles. We love seeing practical applications of your skills, so don’t hold back!
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep everything organised and ensures your application gets the attention it deserves!
How to prepare for a job interview at Trace | Expert Accountancy & Finance Recruitment
✨Master Your Excel Skills
Since the role requires advanced Excel skills, make sure you brush up on your formulas, Pivot Tables, and data transformation techniques. Practise using VLOOKUP, INDEX/MATCH, and SUMIFS to ensure you're confident in demonstrating these during the interview.
✨Know Your Accounting Principles
Familiarise yourself with basic accounting principles, especially double-entry bookkeeping. Be prepared to discuss how these principles apply to the role and give examples of how you've used them in past experiences.
✨Prepare for Data Scenarios
Think about potential scenarios where you might need to reconcile trade-related entries or handle data quality checks. Prepare to explain your thought process and any relevant experiences that showcase your problem-solving skills.
✨Show Your Collaborative Spirit
This role involves working closely with the accounting team, so be ready to talk about your teamwork experiences. Highlight instances where you've collaborated effectively to achieve a common goal, especially in a finance context.
