Data Analytics Apprentice - 18449

Recruiter
Sumitomo Mitsui Banking Corporation Europe Ltd
Location
99, Queen Victoria Street, London, EC4V 4EH
Salary
£365.40 per week
Posted
11 Jul 2019
Closes
10 Aug 2019
Ref
VAC001556536
Specialism
IT
Sector
Unspecified
Role Type
Apprenticeship, Higher
Start Date
August
Duration
Permanent
Thisrolehas been created to develop Computer Aided Auditing Tools (CAATs) to provide greater insight into operational controls by analysing all data to identify anomalies.

The Audit Department at SMBA (London based) is an independent, objective control function undertaking audits across Europe, Middle East and Africa (EMEA) region.

In addition to their internal audit responsibilities for SMBCE/SMBC, they are responsible for the audit of a number of subsidiary companies in the EMEA region including: JSC Sumitomo Mitsui RUS Bank, Moscow, SMBC Nikko Capital Markets Ltd, London and SMBC Aviation Capital, Dublin.

Main role and responsibilities:
  • Establish an understanding of the credit data stored within GBR, and other key bank systems to enable targeted extracts to be built
  • Develop regular reports focussed on each Front Office area to provide auditors insight into the portfolio held
  • Interpret specific queries from the Audit Team and develop new reports to answer them
  • Prepare an ongoing analysis to identify trends in credit quality and performance of regular tasks
  • Support the regular reporting from the Audit Department


Requirements and prospects

Desired skills

  • Thesuccessful applicantmust have strong communication skills, both written and verbal and be able to interpret data
  • The successful applicant will haveareasonable knowledge of IT
  • Basic SQL is desirable
  • Prior use of ACL
  • Anunderstanding of Oracle, sequel server databases anddatabase structures would be an advantage


Personal qualities

  • Youwill be inquisitive and keen to learn
  • You will have the ability to understand and interpret requirements from the business auditors
  • Use this information to create data for further analysis in order to identify control weaknesses
  • Youwill have a natural ability to think analytically
  • You will be a proactive learner who is not afraid to ask questions when you face challenges


Desired qualifications

  • Aminimum of two A-levels in either maths or an IT related subject (equivalent qualifications accepted)
  • GCSE or equivalent in maths at grade 4/C or above


Future prospects

92% of QA Apprentices secure permanent employment after finishing their apprenticeship. Additionally there may be opportunities to undertake further apprenticeship training as many of our programs offer on-going development tracks.

Things to consider

Important Information:

QA's apprenticeships are funded by the Education & Skills Funding Agency (ESFA), an executive agency of the Department for Education.

To be eligible for a Government funded apprenticeship you must have lived in the UK or European Economic Area (EEA) for the last 3 consecutive years.

The Apprenticeship National Minimum Wage guide (ANMW): https://www.gov.uk/national-minimum-wage-rates

Similar jobs

More searches like this

Similar jobs