Desk workflow Engineer- VBA required

The TP ICAP Group is a world leading provider of market infrastructure.

Our purpose is to provide clients with access to global financial and commodities markets, improving price discovery, liquidity, and distribution of data, through responsible and innovative solutions.

Through our people and technology, we connect clients to superior liquidity and data solutions.

The Group is home to a stable of premium brands. Collectively, TP ICAP is the largest interdealer broker in the world by revenue, the number one Energy & Commodities broker in the world, the world’s leading provider of OTC data, and an award winning all-to-all trading platform.

Founded in London in 1866, the Group operates from more than 60 offices in 28 countries. We are 5,300 people strong.  We work as one to achieve our vision of being the world’s most trusted, innovative, liquidity and data solutions specialist.

Role Overview

This role sits within Equities Technology in Hong Kong and supports a suite of business-critical Excel/VBA macros used by front-office users. The macro estate covers confirmation generation, confirmation template management, basket management, email generation, and other desk-facing workflow automation. The developer works directly with the business to scope enhancement requests (most commonly confirmation template enhancements and other functionality enhancements), reproduce defects, and deliver controlled changes to live operational tooling without disrupting day-to-day trading and post-trade workflows.

Modernisation toward type- and memory-safe Rust implementations is ongoing in parallel, including user-facing desktop applications. The active Rust scope supports operations users in producing automated HKTR ISO 20022 XML files for the Hong Kong Trade Repository.

Role Responsibilities

• Maintain and enhance the existing suite of Excel/VBA macros covering confirmation generation, confirmation template management, basket management, email generation, and related operational automation; the routine pattern of work is confirmation template enhancements and other functionality enhancements.
• Work directly with front-office and operations users to scope enhancement requests, reproduce defects, and deliver controlled, behaviour-preserving changes to live business workflows.
• Analyse legacy VBA logic, workbook formulas, templates, and embedded business rules to extract and document the operational rules driving confirmation, basket, and email outputs.
• Contribute to the migration of selected spreadsheet workflows onto the desk's desktop application replacement for the macro as those workflows are prioritised for modernisation.
• Develop and maintain Rust application code, including domain libraries, persistence, runtime services, and user-facing functionality.
• Hold Rust code to the team's engineering standards: fully typed, strictly memory-safe, no panics, unsafe forbidden, with typed errors and explicit domain models.
• Work with hybrid local/cloud datastores for persistence, query, and lineage use cases.
• Document assumptions, reconcile generated outputs, and support auditability across legacy macros, regulatory XML artefacts, and modern application state.
• Collaborate with traders, operations, compliance, and technology stakeholders to translate operational requirements into controlled deliverables.

Experience / Competences

Essential

• Solid Excel/VBA development experience, including maintaining production macros, enhancing template-driven outputs, and supporting business users who depend on Excel-based tooling.
• Practical experience modifying legacy macro estates safely; recognising embedded business rules, workbook coupling, Named Ranges, and the operational consequences of behavioural change.
• Reasonable experience with C# and Windows Forms, including maintaining and enhancing production desktop applications that integrate with trader workflows, and supporting the users who depend on them.
• Track record working directly with non-technical business users in time-sensitive operational environments, including scoping changes, documenting assumptions, and explaining trade-offs in plain language.

Desired

• Strong data-modelling instincts; the ability to identify real domain concepts and model them explicitly rather than relying on strings, generic JSON, loosely typed maps, or spreadsheet conventions.
• Solid Rust development experience covering ownership, typed error handling, async-aware code, and safe refactoring in larger codebases, comfortable working to strict standards (fully typed, strictly memory-safe, no panics, unsafe forbidden).
• Experience with TypeScript and functional programming patterns in TypeScript.
• Experience using agentic coding tools, including context engineering through instruction files and memory, scoped tool permissions and hooks, subagent delegation, and verification guardrails.
• Experience with confirmation workflows, basket management, email automation, trade lifecycle events, or other equities front-office / middle-office workflows.
• Experience working with Jira and Gitlab, or similar ticket-tracking and hosted-git platforms.
• Familiarity with Bloomberg Desktop API or similar market-data desktop integrations.
• Experience supporting regulated or audited financial-services workflows where traceability, reproducibility, and operational evidence matter.
• Familiarity with FINOS CDM, ISDA DRR, or similar industry frameworks for trade representation and regulatory reporting.
• Familiarity with event-driven architecture, message bus patterns, and FDC3.

Job Band and Level

• Manager, 6

Not The Perfect Fit?

Concerned that you may not meet the criteria precisely? At TP ICAP, we wholeheartedly believe in fostering inclusivity and cultivating a work environment where everyone can flourish, regardless of your personal or professional background. If you are enthusiastic about this role but find that your experience doesn't align perfectly with every aspect of the job description, we strongly encourage you to apply. You may be the ideal candidate for this position or another opportunity within our organisation. Our dedicated Talent Acquisition team is here to assist you in recognising how your unique skills and abilities can be a valuable contribution. Don't hesitate to take the leap and explore the possibilities. Your potential is what truly matters to us.

Company Statement

We know that the best innovation happens when diverse people with different perspectives and skills work together in an inclusive atmosphere. That's why we're building a culture where everyone plays a part in making people feel welcome, ready and willing to contribute. TP ICAP Accord - our Employee Network - is a central to this. As well as representing specific groups, TP ICAP Accord helps increase awareness, collaboration, shares best practice, and holds our firm to account for driving continuous cultural improvement. 

Location