Revenue Analyst

Job Description

Our Client - a successful well established service sector group based in Leicester - is seeking an experienced Analyst on a full-time permanent basis.

Role Overview
To oversee various revenue accounting responsibilities for multiple countries & companies. To analyse invoicing and revenue data & to report on any variances to forecasts or budgets. To ensure the accuracy and efficiency of all invoicing and revenue related processes. Constantly lookout for ways to streamline our processes. Support the revenue projects function in the design, test, and implementation of updates to existing and new systems. Significant Excel analysis and manipulation of data to support all revenue related processes.

Job Spec
Invoicing Process:
*Ensure invoicing is completed in accordance with internal processes and within agreed timescales
*Ensure commission and invoice queries are raised and dealt with in a timely manner
*Support all invoicing functions & gain a good understanding of the end-to-end Contract to Cash to Process

Revenue Process:
*Determining and processing appropriate contract updates, revenue adjustments, and other amendments in the Invoicing System
*To monitor and validate all relevant revenue data and resolve data queries in a timely, efficient and accurate manner
*Maintain necessary financial and control records along with supporting documentation related to revenue for audit
*Identify and compare variances of actual revenue and provisions to budget/forecasts
*Preparation of monthly accrued and deferred revenue balance sheet reconciliations
*Ensures that all revenue is accounted for in accordance with policies and accounting guidelines
*To create forecasts of future revenue using contracted revenue and pipeline sales
*To create and present revenue budgets and process necessary adjustments where required
*To prepare cash forecasts in line with the cash availability timings on Invoicing Facility and analysis of actual cash generation
*Supporting provision for bad debts policy with ad hoc analysis and bad debts forecasting
*Prepare ad hoc analysis, as needed
*Ability to deal with foreign currencies and to translate project based costs to Client invoicing requirements
*To complete Clients & Energy Suppliers Questionnaires as required
*Gathering of data for ONS Surveys and submission
*Upsells, New Sales, Losses, OG data collection & MI Reporting
*Validation and processing of Staff Upsell Commission payments for Payroll
*Creation of SQL scripts to perform database queries from multiple tables
*Creating dashboards in Power BI to assist Stakeholders with visualisation of data
*Development and maintenance of necessary schedules and information documents for 3rd party audits and internal QA processes

System and Process Development:
*Gaining a thorough understanding of the invoicing process and transactions and improving these processes where possible
*Supports the efforts in developing, implementing, and maintaining systems, procedures and policies for the group
*Identify system development needs and submit possible solutions and specification to Line Manager.
*Supports any assigned projects to ensure compliance and adherence with controls for internal policies and external regulations
*Participation in ad hoc projects to support business initiatives including assessment of new products, acquisitions, and new internal revenue reporting needs


The Right Person
*Graduate, Studying / Qualified ACICM, Data Analysis (BSC) or equivalent,
*Experience with a variety of invoice processes, as well as implementing and improving processes and systems
*Understanding of and the application of audit controls
*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,
*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: £23,000 - £28,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 NOW or call Paul Mitchell Associates (quoting our 5-digit job reference) on +44 (0)116 254 9404.

By applying to this vacancy, you consent to the processing of your data in accordance with Paul Mitchell Associates GDPR & Privacy Policy: https://paulmitchellassoc.co.uk/gdpr-privacy-policy/

If you do not consent, please DO NOT apply to this vacancy.