Job Details

Finance Data Analyst

Saint Asaph, Leicestershire, United Kingdom, £20,000 - £25,000 , Permanent

Posted: 8 hours ago


11862 - Data Analyst / Finance Analyst Job Spec
Location: Leicester

Our Client - a service sector group based in Leicester - is seeking an experienced 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.

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.

*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 (phone number removed).

Paul Mitchell Associates is acting as an Employment Agency in relation to this vacancy.

By applying to this vacancy you are consenting to Paul Mitchell Associates contacting you and processing your data in line with our Privacy Policy under GDPR (General Data Protection Regulations).

If you do not consent to Paul Mitchell Associates contacting you and processing your data in line with GDPR please DO NOT apply.

For further information relating to our Privacy Policy please visit our website

Job Details

Saint Asaph, Leicestershire, United Kingdom
£20,000 - £25,000