OutSystems Analyst Programmer

TN United Kingdom; London; On-site; GBP 40,000 - 65,000; Full time

Job summary

An established industry player in the Fuel Oil sector is seeking a Support Analyst Programmer with expertise in VBA and low-code app development. This exciting role involves designing and amending delivery operations spreadsheets, conducting analysis, and implementing processes to create efficient applications. You'll collaborate with stakeholders to document requirements and develop solutions that enhance operational efficiency. If you are passionate about leveraging technology to optimize processes and enjoy working in a dynamic environment, this opportunity is perfect for you.

Qualifications

• Proficiency in Microsoft Excel with advanced formulas and VBA.
• Experience with low-code app development using Outsystems.

Responsibilities

• Support delivery operations Excel spreadsheets as part of a rota.
• Design and develop live update pricing reports and screens.

Skills

Microsoft Excel

VBA

SQL Server

Outsystems

ETL processes (SSIS)

Power Query

Job description

Social network you want to login/join with:

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 using Outsystems. This role can be based in London or Gibraltar.

WHAT YOU’LL DO:

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

KNOWLEDGE, SKILLS, AND EXPERIENCE:

• Proficiency in Microsoft Excel, including advanced formulas, VBA, database-connected queries, OLEDB, and ADO linked sheets.
• Experience working with RTD (Real-Time Data) with live tick-based pricing feeds in Excel.
• Knowledge of Power Query.
• Understanding of relational databases, particularly Microsoft SQL Server.
• Ability to undertake relational database design.
• Develop SQL queries, views, stored procedures, and functions.
• Experience with ETL processes using SSIS and scripting.
• Development of printable reports using report writer tools.
• Experience with low-code app development, ideally using Outsystems.