Finance Data Analyst

  • Job Reference: 11862
  • Date Posted: 24 May 2021
  • Recruiter: Paul Mitchell Associates
  • Location: Leicester
  • Salary: £20,000 to £25,000
  • Bonus/Benefits: Holiday: 22 Days + STAT, KPI Bonus, Flexi-Start/Finish
  • Sector: Accountancy, Finance
  • Job Type: Permanent
  • Duration: Permanent
  • Work Hours: Full Time
  • Contact: Simon Hibbert
  • Email: office@paulmitchellassoc.co.uk
  • Telephone: +44 (0)116 254 9404

Job Description

11862 – Finance Data Analyst Job Spec

Location: Leicester

Summary

Our Client – a service sector group based in Leicester – is seeking an experienced Finance Data Analyst on a full-time permanent basis. Reporting to their Accounts Assistant, the successful candidate will provide invoicing and credit control support for all operational and commercial strategies;

  • To support timely, accurate & efficient invoicing / collection processes for the Company,
  • To monitor & validate all relevant commissions data (incl. consumption, costs & commission rates) & resolve data queries in a timely, efficient and accurate manner,
  • To support the maintenance & development of the invoicing systems / functions within the Contracts to Cash Process,
  • To create forecasts of future revenue using contracted revenue & pipeline sales,
  • To analyse & calculate monthly revenue figures. Compare / identify variances of actual revenue to budget / forecasts,
  • To provide administrative support where required.

Invoicing Duties

  • Support all invoicing functions & aspects within Contract to Cash to Renewals Process,
  • End-to-end Contract to Cash to renewals Process,
  • Ensure invoicing is completed in accordance with internal processes & Client SLA’s (incl. rates & discounts) within agreed timescales,
  • Ensure commission & invoice queries are raised / dealt with in a timely manner,
  • Validate monthly consumptions in preparation for monthly invoicing,
  • Ensure all contract pricing & commercial arrangements are checked / validated,
  • Ensure all significant invoicing adjustment transactions are approved before processing,
  • Maintain & develop close working relationships within the finance and support services departments, Consultants, Customer Service, Bill Validation and Procurement Teams,
  • Maintain client invoicing spreadsheets & produce client related reports,
  • Deal with foreign currencies & translate project-based costs to Client invoicing requirements,
  • Creation of SQL scripts to perform database queries from multiple tables,
  • Creating dashboards in Power BI to assist Stakeholders with visualisation of data.

Accounts Receivables Duties

  • Record all client / supplier remittances & receipts in subsidiary sales ledger and Sage Sales Ledger,
  • Bank reconciliation queries & unallocated cash,
  • Calculation & upload of invoicing & revenue journals,
  • Ensure all client balance adjustments are approved such as bad debt write-offs,
  • Support provision for bad debts policy with ad hoc analysis / bad debts forecasting,
  • Reconcile all invoicing related general ledger accounts for assigned projects & assigned client portfolios,
  • Ensure full and transparent digital records & audit trail of all client / supplier correspondence (incl. all invoicing, credit notes, queries and reminders) with links to all relevant documents issued,
  • Ensure debts are chased in line with the Company reminders cycle,
  • Create forecasts of future revenue using contracted revenue & pipeline sales,
  • Analyse & calculate monthly revenue figures. Compare & identify variances of actual revenue to budget / forecasts,
  • Validation & processing of Staff Upsell Commission payments for Payroll,
  • Support development and maintenance of necessary schedules and information documents for 3rd party audits and internal QA processes.

Additional Duties

  • Attend meetings as required,
  • Maintain & develop inter-team relationships,
  • Assist in implementation of relevant Company policies & procedures,
  • Support the wider team by performing other duties that may be required and any other minor duties as advised by the Line Manager from time to time.

KPI’s

  • To ensure all Renewals & New Contracts are checked and entered on monthly basis,
  • To ensure all Change of Tenancies are actioned within the agreed timescales,
  • Accuracy of validating invoicing data,
  • Timely production and update of reports and invoices,
  • Timely and accurate updating of company systems,
  • Timely resolution of queries,
  • Checking accuracy of Supplier contractual documents,
  • Timely production and update of revenue, forecast and budget figures,
  • Application of the Core Values,
  • Adherence to the Company and Team Standards, Policies and Procedures.

 

The Right Person

  • Graduate, Studying / Qualified ACICM, Data Analysis (BSC) or equivalent,
  • Solid high-volume AP / credit & data analysis experience within a corporate environment,
  • Understanding of and the application of audit controls – can take the lead in respect of Accounts Receivable audits tasks when requested,
  • Effective and proactive problem-solving skills – ability to determine a root cause of issues & recommend viable improvements,
  • Ability to create and maintain consistent repeatable processes,
  • An excellent attention to detail, able to work on own initiative with minimal supervision, able to fit into a dynamic and fast-moving accounting team within a larger organisation,
  • Strong IT skills incl. Microsoft Excel, SAGE, VLOOKUP, SUMIFS, Pivot Tables is preferred.

 

Package

  • Appointment Type: Permanent
  • Salary: £20,000 - £25,000 (subject to experience)
  • Annual KPI Bonus
  • Hours: Full-Time
  • Holiday 22 Days + Bank Holidays (rising in line with service up to 24 days)
  • 7.5hrs per day core hours (flexible start-finish times)
  • Benefits incl. 4% ERs / 4% EEs Pension, Perkbox  

If you – or someone you might know – are interested & think this opportunity may be suitable, APPLY ONLINE or call Paul Mitchell Associates (quoting ref: 11862) on 0116 254 9404.