Banner Default Image

Programme Analyst

  • Location

    West End, London

  • Sector:

    Information Technology

  • Job type:

    Contracts

  • Salary:

    £30 - £35 per hour

  • Job ref:

    5130176_1581426243

  • Published:

    18 days ago

  • Duration:

    1 Month +

  • Start date:

    20-02-2024

  • Expiry date:

    12-03-2020

We have an exciting opportunity for a Programme Analyst to join our busy offices based in Kensington on a temporary basis for 1 month with the possibility of an extension. We are looking for someone to start ASAP, working 36 hours per week, at £30 p/h PAYE.

As the Programme Analyst, your main duties will include:

  • You will be expected to produce regular data extracts from operational databases and case management systems using Transact-SQL (Microsoft Dialect SQL) and manipulate those data using advanced EXCEL features, VBA Scripts and Macros.

To be successful for this Programme Analyst post you will need to have:

  • You will have a strong programming/computer science background preferably with a degree in maths, physics, engineering or computer science or in another stem or social sciences discipline with a significant mathematical/statistical component.
  • You will be a fluent SQL query writer with a solid understanding of the underlying principles of data design and management. You will be able to immediately take ownership of a legacy codebase and be able to optimise existing code and write new code to allow quarterly, monthly and weekly reporting to be fully automated.
  • At interview, you will be expected to demonstrate fluency with the most frequently used SQL query statements including select, where, order, join, insert and case statements and be able to explain how they are used in practical contexts.
  • You will be fluent and expect to be immediately productive in a modern scripting language preferably Microsoft VBA, however, if you have a strong Python (or similar) skills with exposure to VBA, strong MS office skills and a willingness to learn on the job we will also consider your application favourably.
  • At interview you will be expected to demonstrate fluency in using scripting languages to filter, tokenize, arrange, splice, join and order large and complex data sets and give examples of how you have done this in previous roles or projects.
  • You will have a good understanding of statistics, being able to calculate correlations, regressions and analysis of variance and explain the statistical validity of your findings to colleagues and other stakeholders.
  • You will have a strong programming/computer science background preferably with a degree in maths, physics, engineering or computer science or in another stem or social sciences discipline with a significant mathematical/statistical component.
  • You will be a fluent SQL query writer with a solid understanding of the underlying principles of data design and management. You will be able to immediately take ownership of a legacy codebase and be able to optimise existing code and write new code to allow quarterly, monthly and weekly reporting to be fully automated.
  • At interview, you will be expected to demonstrate fluency with the most frequently used SQL query statements including select, where, order, join, insert and case statements and be able to explain how they are used in practical contexts.
  • You will be fluent and expect to be immediately productive in a modern scripting language preferably Microsoft VBA, however, if you have a strong Python (or similar) skills with exposure to VBA, strong MS office skills and a willingness to learn on the job we will also consider your application favourably.
  • At interview you will be expected to demonstrate fluency in using scripting languages to filter, tokenize, arrange, splice, join and order large and complex data sets and give examples of how you have done this in previous roles or projects.
  • You will have a good understanding of statistics, being able to calculate correlations, regressions and analysis of variance and explain the statistical validity of your findings to colleagues and other stakeholders.

121 Jobs is acting as an Employment Business in relation to this vacancy.