Description
Job Purpose:
Analysis of Front Office trading and Back Office systems from a data sourcing perspective to ensure attribute coverage to drive accounting.
Data sourcing functional design for processing the incoming data feeds.
Data mapping/translation from source system feeds (which will include XML and CSV formats) to Microgen Accounting Hub data structures.
Work closely with the business accounting rules team to understand the data and events that are required from data sourcing to drive the accounting process.
Carry out test preparation and support project test phases.
For downstream feeds:
Analysis of downstream system feed requirements both from a data attribute perspective and functional behaviours.
Downstream extract functional design for producing the required feeds.
Data mapping/translation from Microgen Accounting Hub data structures to downstream feed formats.
Carry out test preparation and support project test phases.
To achieve the above, the business analyst will be required to liaise and co-ordinate with the various up and downstream IT and Business teams.
Knowledge/skills:
*Broad derivatives knowledge across Global Markets products (eg Equity derivatives, Equity Finance and FX and FX derivatives, Interest Rate Derivatives) from a trade attribute and life cycle event perspective, ie no knowledge required of pricing analytics or meaning of 'greek' risk measures.
*Experience of working on product control or financial control projects, ie Derivatives PnL explain, Regulatory Reporting, Sub-ledgers/General Ledgers, Accounting Rules set-up in settlement systems.
*Knowledge of trade flow from trade inception through to settlement through the various bank departments and applications.
*Must have at least 5 years experience in the financial services sector of which the last 3 years was in carrying out a project business analysis role.
Technical
*SQL - MS Access and Oracle
*MS Excel
*VBA
*Previous experience of Microgen Accounting Hub and/or OST Rules would be ideal.
Aston Carter Ltd is acting as an Employment Business in relation to this vacancy.