Sales information analyst job description

External (Corporate and Agency) Incentive Contract Analysis

 
Interpret and verify all aspects of agency and corporate incentive contracts and upload data into Sales Incentive System

Production and communication of monthly reports of Corporate and Agency contracts.

Analysis of corporate and agency performance against contractual obligations and advise account managers.

Audit final flown revenue figures of incentive deals assuring all flown revenue and sectors are accurate.

Provision of final deal revenue, sector figures and commentary to Corporates and Agencies.

External Incentive Payments

Calculate payment for all retrospective override rebates

Sales and Marketing Agreements payment authorisations confirmed in line with the external VAT invoices.
[cont right]
 
 

Produce all documentation for authorisation of payment by General Manager, Sales.

Process administration via Financial Department and ensure monies due are passed to the appropriate external contact within contractually agreed timeframe.

Verify calculation of payment due for each corporate and agency at the end of the deal period.

Compile monthly report of all Projected Payments due for the Financial Department for accrual of liability.

Liaise with external clients in connection to queries/explanation with respect to their payments.

Produce in depth documentation supporting all payments made for company internal and external audit.

Global Revenue Reporting
 Sales information analyst job description

Provision of Top line MIS reports for all Global/Bilateral Corporate and Agency contracted to company

Understand and interpret data from all global sales areas.

Interpret and provide agency and corporate revenue in line with locally/ globally negotiated contracts for all online
countries in network on a monthly basis.

Detailed revenue and passenger performance reports to all online country managers at agency level.

Maintenance of Sales Incentive Database

Ensure global structure of all travel agencies is correct referencing assignment rules and updating working tables
within Viggo to keep structure valid.

Structure all managed agencies globally to reflect account mangers` responsibility and accountability.

Maintain specific structures of managed accounts in line with Sales Incentive Targeting Schemes

Analysis of system data feed on a monthly basis validating consistency and reliability.

Data integrity sweeps of the system on a monthly basis utilising SQL query tool to avoid reporting conflicts that could affect revenue and passenger figures.

Problem analysis, proposals of solutions and decision-making.

Knowledge of whole system process and logic.

Update all documentation in line with any additions made to look up tables, user flags, processes.

Constantly monitor all `housekeeping` processes and schedules are administered and adhered to maintain consistency and accuracy.

MIS and data analysis
Sales information analyst job description

Provision and analysis of scheduled and ad hoc MIS reports required by Senior Sales Management and their teams

Extract, expand, link, reconcile, analyse and interpret all relevant sales and commercial data in line with global sales teams requests.

In depth analysis of Revenue Accounts data used within Sales Information to ensure accurate revenue reports.
 
Liaising between Sales Information and Revenue Accounts with respect to anomalies found which affect the external and internal reports produced by Sales Information and working with the relevant personnel within Revenue Accounts to resolve.

Detailed investigative reconciliation of revenue for Sales Managers globally on an ad-hoc basis

Assisting Sales Managers in ad-hoc project work.

Provision of scheduled and ad-hoc market share performance reports for Sales management team.

Compile yearly and monthly market share reports for account managers, using Market Impact and GSI statistics to facilitate
both incentive implementation and yearly account reviews.

Load monthly GSI data when received.

Requirements

Educated to A Level Maths or equivalent.

Attention to detail and high level of accuracy is vital.

Competent in Microsoft Office with advanced knowledge of Microsoft Excel

Strong analytical, numerical and problem solving ability.

Ability to use initiative plus organise and prioritise workload.

Commercial awareness and an understanding of commercial deal tendering process.

Ability to quickly understand technical issues

Ability to be proactive: suggest ways of improvement, be solution oriented

Ability to work calmly, unsupervised under pressure and remain objective.

Present and communicate clearly and effectively with all levels of management.

Basic GDS knowledge.

 Sales information analyst job description

free-job-descriptions.com provides a free database of real job descriptions for use in writing jd`s, recruitment and job search.