Support Analyst Programmer

DEPARTMENT/TEAM: Technology Team
LOCATION: London/Gibraltar
SUMMARY

• Provide support for delivery operations Excel spreadsheets, as part of a rota. • Design and amend delivery operations spreadsheets. • Conduct analysis, design, and implementation of delivery operations processes to produce delivery operations applications. • Build operations reports. • Provide support for live pricing systems and spreadsheets. • Design and develop live update pricing reports and screens. • Work with stakeholders to document their requirements and gain signoff. Work with colleagues to develop, test and deliver the requirement.

KNOWLEDGE, SKILLS AND EXPERIENCE

Essential

  • Microsoft Excel including (Advanced formula, VBA, Database connected queries, OLEDB, ADO linked sheets).
  • Working with RTD (Real Time Data) with live tick-based pricing feeds in Excel
  • Understanding of relational databases, in particular Microsoft SQL Server
  • Be able to undertake relational database
  • Able to develop SQL queries, views, stored procedures, and
  • Experience with ETL using SSIS and
  • Development of printable reports in a report
  • Low code App development ideally using

APPLY NOW