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
LPUK LeasePlan UK Ltd is an excellent employer, offering a dynamic work culture in the vibrant city of Bristol. Employees benefit from a competitive salary and a comprehensive benefits package, including a pension scheme and wellness programs, while also enjoying ample opportunities for professional growth and development within the procurement field.
StudySmarter Expert Advice🤫
We think this is how you could land Treasury & Reporting Analyst
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like LPUK LeasePlan UK Ltd. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Treasury & Reporting Analyst
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to LPUK LeasePlan UK Ltd.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on LPUK LeasePlan UK Ltd's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at LPUK LeasePlan UK Ltd
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with LPUK LeasePlan UK Ltd.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at LPUK LeasePlan UK Ltd will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former LPUK LeasePlan UK Ltd employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.