On behalf of our client in the Fuel Oil sector we are recruiting a Support Analyst Programmer experienced with VBA and low code app development Outsystems. This role can be based in London or Gibraltar.
WHAT YOU’LL DO:
• 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
• 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
• Powerquery.
• Understanding of relational databases, in particular Microsoft SQL Server
• Be able to undertake relational database design.
• Able to develop SQL queries, views, stored procedures, and functions.
• Experience with ETL using SSIS and scripting.
• Development of printable reports in a report writer.
• Low code App development ideally using Outsystems.