Assistant Analyst

Recruiter
ACS Performance
Location
East Sussex, UK
Salary
Competitive
Posted
22 Aug 2019
Closes
26 Aug 2019
Ref
1220264015
Sector
Accountancy
Contract Type
Permanent
Hours
Full Time
MAIN DUTIES & RESPONSIBILITIES:

Collate data to prepare monthly Exec Packs and KPI Packs
extract and audit data from Syspro using both Excel and Crystal, to be collated in various report packs highlighting progress of all aspects of business against Key Performance Indicators - for example:
sales targets by portfolio
customer complaints within target
stockholding charts
purchasing targets
H&S accident data.
work to deadlines - Exec Pack 1st of month: KPI Pack 10th of month.You will be required to update, collate and distribute these report packs on time to various managers and directors within the company.

Create and maintain Crystal Reports issued to all departments
produce reports as requested, extracting data using the SQL data tables within Syspro (accounting & manufacturing software) on any aspect of the business - for example:
sales reports by product, portfolio, country
production reports listing orders by division or warehouse location of stock
purchasing reports highlighting low level or high value stock items
financial reports for accounts, customers exceeding credit limits etc
summary level reports for directors and managers.
reports to be ad hoc or set up schedules to run automatically via email at any time interval to either one member or a group of staff.
update relevant reports annually for new financial year and any other changes as required and maintain the auto-email scheduler.
assist with upgrades of software as required
Create and accurately maintain various excel spreadsheets recording any aspect of business performance, for example:
turnover and stock charts
sales by country reports
mould machine and tooling utilisation charts
HMRC EC Sales & Intrastat online returns
Scrap reports
OEE & Resource analysis
assist other staff to utilise software effectively
Audit of internal departmental procedures
Accounts Payable - to audit expense, currency and credit card claims all within company approved limits; invoice approval and purchase order value within staff approval limits; etc.
Accounts Receivable - audit customer credit limits being adhered to; credit notes approved according to limits; new accounts set up in both Syspro and Goldmine according to company procedure; etc.
Other Audits as required - for example customer returns and complaints data being correctly allocated; stock bills of material include correct labour and overhead recovery rates; etc.
Use of SQL
create SQL Views to facilitate report writing for any of the above
correct erroneous data highlighted on exception reports using SQL stored procedures.ACS are recruiting for an Assistant Analyst. If you feel that you have the skills and experience required in this advertisement to be an Assistant Analyst, please submit your CV including an outline of your experience as an Assistant Analyst. It is always a good idea to include a covering letter outlining your experience as an Assistant Analyst with your application as this will enhance your chances of selection and improve your prospects of landing the Assistant Analyst role you desire

Similar jobs

Similar jobs