S25-409 Oracle Financial Systems Assistant Analyst (LC5-6)

Lancashire Constabulary; Preston; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A regional law enforcement agency in Preston is seeking an Oracle Financial Systems Assistant Analyst. The role involves managing the financial systems, resolving Oracle module issues, and producing management information. Ideal candidates will be methodical thinkers with skills in Excel and SQL, and will have opportunities for hybrid working. Benefits include generous annual leave, pension schemes, and more.

Benefits

25 - 31 days annual leave plus 8 bank holidays

Local Government Pension Scheme

Sick pay provisions

Generous maternity/paternity leave

Discounts via the Blue Light Scheme

Access to on-site gyms

Cycle to work scheme

Health and Wellbeing Centre support

Qualifications

• Methodical thinker with problem-solving capabilities is essential.
• Experience or knowledge in financial systems or software development.
• Ability to analyze data using formulas and create reports.

Responsibilities

• Liaise with system provider for user system issues.
• Investigate and resolve system issues across all ORACLE Modules.
• Quality assure management information and statistical data.

Skills

Microsoft Excel

SQL Programming

Visual Basic for Applications

Problem-solving

Analytical thinking

Job description

Applications are invited for the post of Oracle Financial Systems Assistant Analyst, within the recently formed Financial Systems Team in Finance based at Hutton Headquarters.

The Financial Systems Team is a recently created team because we have taken ownership of managing, maintaining & developing our own Financial System. This has opened a vast range of development opportunities in the Finance Team to develop skills in ICT including using Microsoft Excel to analyse data using formulas and create Pivot tables and writing Macros using Visual Basic for Applications. As well as learning to programme using SQL to help you use Oracle Developer & Blitz Reporting to query the database and create reports.

All in all, Oracle is one big puzzle. If you are a methodical thinker, like problem solving, can think outside the box, produce new ideas, and would like to develop your skills in finance or see yourself as a software developer then the Financial Systems Team is a good place to be.

Key Responsibilities

• Liaise with system provider in respect of user system issues and Constabulary requirements where necessary.
• Investigate and resolve system issues across all ORACLE Modules including Accounts Receivable, Accounts Payable, General Ledger, Cash Management, Debt Collection, Procurement, I Procurement, Systems Administration and Fixed Asset.
• Provide a system admin role ensuring accuracy and quality assurance of functions and activities within each of the modules outlined above.
• Produce and quality assure management information and statistical data in response to internal and external requirements. This will involve the extraction of data from Oracle or associated systems using standard and ad hoc reporting methods and the processing of this data using Microsoft Excel and Oracle SQL.
• Assist the review Oracle Financials System functionality / procedures in response to new legislation, statutory requirements or Force policy.

Please see the attached job specification for further details.

Vetting And Medical

Please be aware, as a condition of your appointment you must undergo and pass Recruitment Vetting (RV). Please be aware there is a minimum 3 year UK residency requirement for Recruitment vetting and you must be 18 years old at the point of applying. Successful applicants will also be subject to a medical assessment.

Please note, candidates successful at shortlisting will be required to undertake an assessment as part of the interview process. This will consist of an Excel test.

Benefits

• 25 - 31 days annual leave (role dependant) plus 8 bank holidays pro rata
• Local Government Pension Scheme with contributions from 5.5% to 12.5% depending on your salary
• Sick pay provisions
• Generous maternity / paternity and adoption leave entitlements
• Option to become a member of the onsite unions
• Discounts from various retailers via the Blue Light Scheme
• Access to on-site-gyms – HQ
• Cycle to work scheme
• Support from our Health and Wellbeing Centre including Welfare Officers, Counselling, Physiotherapy and Mental Health Peer Supporters
• Hybrid / Agile working (role dependant)

Artificial Intelligence (AI) Assistance Disclaimer

Whist we would encourage applicants to not use AI in order to provide their examples within the application form, we accept that candidates may use AI to provide general guidance and inspiration during the completion of the form.

By utilising this functionality, you acknowledge and agree to the following:

• AI-generated content is provided for illustrative purposes only and does not constitute professional, legal, or personal experience.
• You remain fully responsible for the accuracy, authenticity, and originality of all information submitted in your application.
• The inclusion of AI-generated suggestions does not imply endorsement or guarantee of the appropriateness, completeness, or effectiveness.
• The organisation accepts no liability for any consequences, direct or indirect, arising from the use of AI-generated content within this form.

Applicants are encouraged to carefully review and personalise all responses to ensure they accurately reflect their individual experiences, qualifications, and intentions.

Before you complete the online application, we would advise you to read the attached Information and Guidance documents.

Closing date: Friday 5th December 2025 at 10am.