Analyst

Recruiter
Personnel Selection
Location
Newhaven, UK
Salary
Competitive
Posted
21 Aug 2019
Closes
25 Aug 2019
Ref
1240289534
Sector
Accountancy
Contract Type
Permanent
Hours
Full Time
This is an extraordinary opportunity for an experienced analyst looking for a fresh challenging, your role will be to work in a fast paced, extremely successful manufacturing business extracting, collating and undertaking audit data for inclusion in various monthly, quarterly and annual reports and to create, maintain and schedule numerous reports using Crystal Reports (SQL based and business information management software).

• 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:

•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.

• HMRC EC Sales & Intrastat online returns

• Create SQL Views to facilitate report writing for any of the above

• Correct erroneous data highlighted on exception reports using SQL stored procedures.

*** FULL JOB DESCRIPTION AVAILABLE UPON APPLICATION""""

Education/Qualifications

A Level or equivalent in Maths / Finance / Business Studies

Knowledge/Experience

Financial / Manufacturing background

Auditing procedures

Analyst / Data Manager

Skills/Abilities

MS Excel Advanced(including charts, lookup tables, pivot tables, presentation / report formatting skills)

MS Office

Attention to detail

Accuracy

Reconciliation

Crystal Reports (or similar SQL table based report writing software)

SQL Database Skills (create Views, use Stored Procedures)

Similar jobs

Similar jobs