At a Glance
- Tasks: Manage cashflows, funding streams, and produce insightful reports for stakeholders.
- Company: Join Ayvens UK, a dynamic company focused on finance and innovation.
- Benefits: Enjoy competitive pay, pension scheme, gym membership, and generous leave policies.
- Other info: Flexible work-life balance with opportunities for personal development and community involvement.
- Why this job: Make an impact in finance while developing your skills in a supportive environment.
- Qualifications: Proficient in Excel, with experience in SAS, VBA, or SQL preferred.
The predicted salary is between 35000 - 45000 £ per year.
Treasury & Reporting within Ayvens UK is responsible for managing funding and interest rate risks, banking and cashflows, and for providing management information across the business and into the Ayvens group.
Key Purpose
- Monitor cash position and use this to help manage monthly funding streams.
- Oversee production of MI for internal and external stakeholders and assist in monthly processes for the various funding sources.
- Use funding and markets insight to help set and maintain interest rates at the appropriate levels.
Key Accountabilities
- Cashflow
- Upkeep of the daily cashflow spreadsheet.
- Monitor cashflow levels and correct as appropriate.
- Assisting in the management and administration of all funding schemes.
- Enter new loans into relevant reporting tools and ensure cashflows are posted correctly in finance systems.
- Produce monthly and quarterly reports on the funding schemes.
- Ensure interest rates are set and maintained at appropriate levels.
- Assist with the management of interest rate charts and COBF tables.
- Projects
- Provide expert support to various finance functions through development and upkeep of existing reports and spreadsheets using SAS, VBA and SQL.
- Ad-hoc modelling and analysis of large data sets to inform ALD strategy.
- Develop reports and processes to improve and ensure data integrity within finance.
- Assist with the development and upkeep of the finance SharePoint site.
- Assist in the creation and improvement of the monthly Fleet and Orderbank reporting to UK and international stakeholders.
- Assist in the production of the Treasury Committee pack.
- Banking administration of current bank accounts and finance payment and DD solutions.
- Assist in the development of banking systems/processes.
- Reporting
- Assist in the creation and improvement of the monthly Fleet and Orderbank reporting.
Skills, Experience & Background
- Proficient in Microsoft Office (Excel) to advanced level with experience of working with large datasets.
- Experience in SAS, Visual Basic, VBA or SQL preferred.
- Self-starter with the ability to take initiative and work pro-actively, ideally with experience of process improvement.
- Experience of financial reporting and/or having worked in a finance department preferred.
- Strong numeric and analytical skills with the ability to interpret complex financial data and trends.
- Proactive attitude with proven ability in taking ownership for resolving problems and queries.
- Excellent communication and interpersonal skills, with the ability to effectively communicate financial concepts to non-finance stakeholders.
- Proven ability to work collaboratively in a fast-paced environment and effectively manage multiple priorities.
- Planning, prioritising and meeting deadlines in a fast-paced and complex environment.
What we offer
- Competitive remuneration package including contributory pension scheme, annual salary review and bonus scheme, GAYE scheme, employee referral scheme (£1,000).
- Retail discounts programme.
- GymFlex membership options, Cycle to Work scheme.
- Health & Wellbeing: life assurance, health assessment options, travel, dental, critical illness and personal accident insurance.
- Time Off & Work-Life Balance: 25 days’ annual leave + an additional Celebration Day, 37.5-hour week, Monday-to-Friday, no weekends, holiday buy & sell scheme, volunteer days, time for personal development and study support (where applicable).
- Workplace & On-Site Facilities: free parking, EV charging points, bike storage & shower facilities, complimentary breakfast, staff and social events.
We are committed to building a diverse, inclusive, enjoyable and authentic workplace. Studies have shown that women and people of colour are less likely to apply for an opportunity unless they exactly meet the criteria specified. We encourage you to apply regardless if your experience doesn’t exactly align.
Treasury & Reporting Analyst employer: LPUK LeasePlan UK Ltd
Ayvens UK is an exceptional employer that prioritises employee well-being and professional growth, offering a competitive remuneration package alongside a range of benefits such as a contributory pension scheme, annual salary reviews, and a generous holiday allowance. Our inclusive work culture fosters collaboration and innovation, providing opportunities for personal development and the chance to engage in meaningful projects within a supportive environment. Located in a vibrant area, we also offer excellent on-site facilities, including free parking and gym membership options, making it an ideal place for those seeking a rewarding career in finance.
StudySmarter Expert Advice🤫
We think this is how you could land Treasury & Reporting Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the finance sector, especially those who work in treasury or reporting. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Prepare for interviews by brushing up on your financial concepts and data analysis skills. Be ready to discuss how you've used tools like SAS, VBA, or SQL in past roles. We want to see your analytical prowess in action!
✨Tip Number 3
Showcase your problem-solving skills! Think of examples where you took the initiative to improve processes or resolve issues. This will highlight your proactive attitude, which is key for a Treasury & Reporting Analyst.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our team at Ayvens UK.
We think you need these skills to ace Treasury & Reporting Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences mentioned in the job description. Highlight your proficiency in Microsoft Office, especially Excel, and any experience with SAS, VBA, or SQL. We want to see how you can bring value to our Treasury & Reporting team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the role and how your background aligns with our needs. Don’t forget to mention your proactive attitude and problem-solving skills – we love that!
Showcase Your Analytical Skills:Since this role involves interpreting complex financial data, make sure to include examples of how you've successfully managed large datasets or improved processes in previous roles. We’re looking for those strong numeric and analytical skills!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team at StudySmarter!
How to prepare for a job interview at LPUK LeasePlan UK Ltd
✨Know Your Numbers
As a Treasury & Reporting Analyst, you'll be dealing with cashflows and interest rates. Brush up on your financial metrics and be ready to discuss how you would monitor and manage these aspects. Familiarise yourself with key terms and concepts that are relevant to the role.
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in Microsoft Excel, SAS, VBA, or SQL during the interview. Prepare examples of how you've used these tools to analyse data or improve processes in previous roles. This will demonstrate your capability to handle large datasets effectively.
✨Communicate Clearly
You’ll need to explain complex financial concepts to non-finance stakeholders. Practice articulating your thoughts clearly and concisely. Consider preparing a few scenarios where you successfully communicated financial information in an understandable way.
✨Be Proactive and Problem-Solving
The role requires a proactive attitude and ownership of tasks. Think of instances where you identified a problem and took the initiative to resolve it. Be ready to share these examples to show that you can thrive in a fast-paced environment.