Finance Systems Analyst

Job details

General information



Vacancy location


UK, South East, London

Vacancy details


Since being founded in 1966 Lockton has grown to become the world’s largest privately owned insurance broker and is today the 10th largest insurance broker in the world, with revenues in excess of $1.7bn.

Lockton is a dynamic and entrepreneurial organisation that embraces its uncommonly independent status. The company best demonstrates its entrepreneurial culture in the empowerment of its Associates to act quickly, learn fast and provide the right solutions for their clients. We are now seeking individuals who will thrive in this type of atmosphere.

In line with the firm’s strategy, the Finance department is developing and enhancing its capabilities and we are now looking to recruit a Finance Systems Analyst to join our dynamic and expanding team. 

  • The role is in the newly formed FP&A/ finance change & systems team under the new Head of FP&A and will be pivotal in creating the tools and data extracts that Lockton need to analyse their extensive data
  • Revenue analysis will be a key task for the new team involving design and creation of new data warehouse sources, so strong liaison with IT will be required
  • The business is diverse so an eye for detail will be required
  • Systems administration tasks will be to ensure data integrity, ensuring all systems are updated and one version of the truth is evident across all platforms
  • This is an exciting time to be part of the firm’s Finance department and we expect new joiners to actively contribute to the development of the team.

Key responsibilities of the role:

  • Create and maintain the administration processes around all Finance core systems, including: Insight Software – CXO Cockpit (MDX), Oracle PBCS – Essbase & MDX, PeopleSoft – SQL Queries, Excel models – VBA & advanced Excel skill set
  • Ensure all systems reconcile exactly to each other
  • Liaison with IT in the UK and US to ensure system changes are validated and reconciled
  • As the Finance team evolves and the FP&A function is embedded and matures, there will be projects that arise from time to time which will involve deep involvement
  • Providing access to and analysis of revenue data
  • Providing cost analysis, specifically employee analysis and statistics
  • Building and maintaining reporting packs for Finance stakeholders
  • Build and maintain KPI tables
  • Responding to business requests for additional information in conjunction with other member of the finance team
  • Automating and constantly challenging standard business tasks

Candidate Profile

Candidates should have evidence of skills in:

  • MDX & VBA knowledge – essential
  • Advanced Excel - essential
  • Oracle EPBCS/PBCS or Hyperion Planning experience – highly desirable
  • PeopleSoft – desirable
  • Accounting and finance related exposure gained in industry or in practice
  • Proven ability to drive changes and implement new policies / processes
  • Demonstrable ability to work well as a team
  • High attention to detail and being proactive and self-motivated
  • Experience of working in a high paced deadline driven environment
  • Preferable exposure to Financial Services but strong Non-Financial Services considered
  • Good academic background, with strong A levels
  • Educated to degree standard – preferable, but not essential