Data Analyst Trainee

The successful candidate will be a recent STEM graduate with a keen interest in data and investment. They will provide key operational data support to the business. It is important to be a fast learner, but no prior knowledge or experience is required, just a clear desire and aptitude for working with data. Knowledge of python and SQL is a plus.

The role is based in the London office supporting the UK, Europe, Singapore and US offices. The role sits within the IT department and will be high pressured at times so it is fundamental that the candidate can deal with pressure, The candidate will be a self-starter and will support staff in person and remotely.

Investment20/20 Programme

You will join as a Graduate Analyst as part of the Investment20/20 one-year trainee programme.

You will be introduced to investment management, and you will gain industry knowledge, experience and develop relationships to progress your career and develop skills. As part of the Investment20/20 programme, you will have opportunities to meet and network with over 200 trainees across the industry and participate in socials and insight events.

Main Responsibilities – All training will be provided.

Main Responsibilities in the role:

• Supporting data applications including but not limited to:
  • Bloomberg
  • Portia and/or IBOR systems
  • Custodian applications/systems
  • FactSet

Supporting in-house systems:

• SQL Databases
• Python automation
• Excel Spreadsheets
• SharePoint
• Process and reconcile data between systems/clients/custodians/internally.

Assisting with the development of a new data warehouse:

• Understanding and collating business reporting requirements.
• Assisting with building new databases and their constituent tables.
• Use of python & ETL tools to develop ingestion, cleaning & validation of data.
• Produce Documentation and Reports as new processes are created.

Being a key point of contact for ad-hoc data related queries:

• Ability to investigate and resolve data and user queries/issues.
• Dealing with 3rd Party vendors to resolve issues/queries.
• Ability to work with users to identify issues and gather requirements.
• Manage user expectations and be able to work under pressure.
• Assist/manage with the annual IT SOC1 and IT Audits.

The candidate:

• Degree educated in a STEM field.
• Pro-active, logical and methodical thinker.
• Good communication, trouble shooting and problem-solving skills.
• Ability to deal with large amounts of data to a high degree of accuracy.
• Excellent mathematical ability with high level of accuracy.
• Ability and desire to work with new software and applications.
• Ability to troubleshoot and problem solve.
• Good time management skills and able to work to deadlines.
• Self-starter and well organised.
• Team player willing to go the extra mile.
• Knowledge of python & SQL, or a willingness to learn.
• Foundational knowledge of database concepts & data modelling.