Data Analyst

Job Title: Data Analyst
Contract Type: Permanent
Location: City of London, London
Salary: £50000 - £65000 per annum + package
Reference: BBBH6213_1495553591
Contact Name: Jamie Allen
Contact Email: jallen@venquis.com
Job Published: May 23, 2017 16:33

Job Description

Role: Data Analyst / Technical Analyst

Industry: Asset Management

Reports to: Development Manager


We are looking for a technical/data analyst who is technically inclined and is interested in learning how to write transformations using desktop tools. The candidate must have financial industry experience and knowledge of trade life cycle and back office operations. The bulk of the work is to transform from one xml format to another which often takes the form of industry standard messages such as fpML, FIX and ISO 20022/15022.


  • Analyse business, system and data requirements.
  • Collaborate with Developers, Team Leads, Architects, Business Analysts, Project Managers and Testers.
  • Working with examples will not give you enough information to write a transformation you will need to source all the possible data values and understand the business logic behind those values.
  • The tool used in the role is GUI based and supports the construction of re-usable components that model XML documents and their mappings. You will need to build these components when new transformations are required and you will need to manage these requirements when either the source or target changes.
  • The tool has an inbuilt testing framework which needs to grow to cover any scenario that the transformations cover.
  • The transformations are checked into source control where they effectively become available for a developer to add the transformation into the integration pipeline.
  • Contribute towards the estimating process

Extensive knowledge and proven track record in project delivery using:

  • Data Analysis
  • Financial messaging standards, including fpML, ISO20022, FIX
  • Relational Databases (Oracle, Sybase)
  • SQL Queries
  • XML, XSD and CSV
  • Build and integration tools (e.g. Maven, Jenkins)
  • Unit Testing, Regression Testing and Code Coverage

Exposure to and good understanding of:

  • Fund management/Investment banking
  • Portfolio Management, Order Management and Trading Systems
  • Equity, Bonds and OTC instruments and lifecycles
  • Middle and back office functions

Social stream