Finance Analyst (12 Month Fixed Term Contract)

Lloyds; City of Edinburgh; On-site; GBP 28,000 - 38,000; Full time

Benefits offered by this job

Minimum 22 days holiday

Flexible working options

Family leave

Pension scheme

Private medical insurance

Share plans

Employee discounts

Job summary

Lloyds Banking Group in Edinburgh seeks a Finance Control & Reporting professional for a 12-month fixed-term contract within Central Finance. You will post journals, run reconciliations, and provide month-end analysis. The role emphasizes automation using Power Query and Excel, plus improving data quality and controls.

You will collaborate with Ledger Control, FDAO, Prism, Finance Platforms and business teams to ensure accurate data transfer, reporting, and governance, working a 35-hour week.

Qualifications

• Strong stakeholder management.
• Accountancy degree completed within the last two years with ACCA/CIMA exemptions.
• Or be a part-qualified accountant with few exams remaining.
• Passion for financial control and a questioning approach.
• Team player.

Responsibilities

• Prepare and post finance journals.
• Perform balance sheet reconciliations and substantiation.
• Produce reporting and analysis for month-end and daily processes.
• Identify opportunities to reduce manual effort in reporting and reconciliation.
• Develop and maintain Power Query and Excel automation solutions.
• Use macros to streamline journal workflows.
• Support data enrichment and process improvement initiatives.
• Investigate and resolve finance data and reporting issues.
• Deliver control checks to ensure accuracy and governance.

Skills

Stakeholder management

Financial control

Team player

Problem solving

Attention to detail

Education

Accountancy degree

ACCA exemptions

CIMA exemptions

Part-qualified accountant

Tools

Power Query

Excel

Macros

Job description

• At Lloyds Banking Group, we have a clear purpose; to help Britain prosper and to become the best Financial Services provider for our customers
• Through our brands, our Group has a relationship with just about every household and community in the UK. We underpin the lives of millions of individuals and businesses and play a key role in helping to build a growing UK economy
• You’ll join us in Central Finance – Control & Reporting a team of c200 colleagues within the Finance Division, providing centralised support and expertise to the rest of Finance and the Business
• This role is a 12 month fixed term contract supporting the CB Financial Control team in Group Finance Support responsible for the financial control activity, reconciliation and basis of substantiation of data on a monthly basis
• Prepare and post finance journals
• Perform balance sheet reconciliations and substantiation activities
• Produce reporting and analysis to support month-end and daily finance processes
• Identify opportunities to reduce manual effort within reporting and reconciliation processes
• Develop and maintain Power Query and Excel-based automation solutions
• Use macros and automation tools to streamline journal preparation and approval workflows
• Support data enrichment and process improvement initiatives
• Investigate and resolve finance data and reporting issues
• Deliver control checks to ensure processes remain accurate and appropriately controlled
• Support change initiatives, including implementation of new finance processes and corrective journal activity
• Carry out maintenance & documentation of key EUDAs and end-user databases that support the Term Deposits control environment
• Support monthly flash and final reporting by analysing balance sheet, P&L and average balance movements and providing commentary on significant variances
• Work closely with Ledger Control, FDAO, Prism, Finance Platforms and Business teams to ensure source system data is accurately transferred, reported and controlled
• 35 hours per week

Benefits

• A generous holiday allowance: You’ll be eligible for a minimum of 22 days holiday (excluding bank holidays), rising to 30 days based on length of service and grade.
• A flexible way of working: Whether you want flexibility over your location or when you log on, together we can create an approach that works for you and for the business.
• Family leave: Up to 63 weeks of maternity or adoption leave. Statutory maternity or adoption pay is available for 39 weeks, and 20 weeks will be enhanced to the equivalent of full pay. Partners can have six weeks of fully paid paternity leave.
• Flex cash: This is 4% of your basic salary and can be used to spend on the benefits of your choice, or you can choose to take it as a cash top up in your monthly salary.
• Health insurance: Our company funded Private Medical Benefit provides all colleagues with access to good quality medical care, including accommodation, nursing care and specialist advice.
• Colleague Offers: Get discounts on everything from electrical items to cinema tickets and weekly food shopping. You can share this benefit with up to ten family members or friends.
• Financial products: Take advantage of our great financial products, some at a discounted rate, including current accounts, home and car insurance and loans.
• Share plans: Participate in Sharematch and receive matching shares of up to £45 a month from the company, and you can choose to participate in Sharesave, our combined savings and share option plan.
• Pension: We offer a generous pension plan, with all joiners being automatically enrolled in our ‘Your Tomorrow’ scheme. You can decide how much you save and get a say in where your contributions are invested.

Requirements

Strong stakeholder managementAccountancy degree completed within the last two years, with ACCA or CIMA exemptions leaving you with only six exams to complete; or already a part-qualified accountant with fewer than six exams remainingPassion for Financial control and questioning approachTeam player