This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Associate Director Product Control Business Re-Engineering & Automation
United Kingdom, London Employment contract · Job Posted May 04, 2026
Job offer has expired
Job Link Share
Job Description
You will be joining a unique dual-competency role at the intersection of Product Control and hands-on technical delivery, acting as the primary re-engineering and automation partner for the Macro PC function across FX, Flow Rates, Structured Rates, and Commodities. This position offers the opportunity to drive meaningful transformation within RBC's Product Control Infrastructure, leading process change, building automation solutions, and aligning the business to standardised frameworks in preparation for onboarding to PLANET, RBC's centralised reporting platform. You will combine deep Product Control expertise with strong technical capabilities to design and deliver Python and VBA-based automation solutions that stabilise the existing EUC landscape and progressively eliminate manual dependency as processes migrate to the centralised platform.
Job Responsibility
Lead data validation and business requirements definition for Macro PC onboarding onto PLANET
Support testing, UAT, and data quality validation for platform onboarding and BAU release cycles
Design and build Python and VBA-based automation solutions to reduce manual effort
Lead re-engineering of Macro PC workflows to ensure compatibility with centralised platform data flows
Assess, catalogue, and prioritise the Macro PC EUC landscape for stabilisation or elimination
Work closely with the SOP/BPM team to translate newly drafted standards into actionable operational change
Build trusted working relationships with Macro PC controllers and stakeholders
Share knowledge of platform capabilities with Macro PC teams
Requirements
Demonstrable experience in a Product Control, Finance Change, or Finance Transformation role within a capital markets environment
Strong understanding of Macro products (FX, Rates, and Commodities) and the associated P&L and balance sheet reporting lifecycle
Hands-on proficiency in Python, including pandas, with the ability to write end-to-end data extraction, transformation, and reconciliation scripts independently
Hands-on proficiency in VBA for Excel and Access automation, with the ability to assess, refactor, and document legacy EUC tools to production standard
Experience auditing and rationalising an EUC landscape, including cataloguing tools, assessing risk, and delivering structured remediation or elimination plans
Experience implementing process change in line with documented SOPs and standards, with the ability to interpret process documentation and drive adoption with the business
Nice to have
Experience in a Finance Change, PC COO, or Business Analysis role supporting a major system migration or centralised reporting platform onboarding programme
Familiarity with BPM frameworks sufficient to interpret and implement documented standards effectively
Experience defining and executing an EUC-to-platform migration roadmap in a regulated financial environment
Accounting qualification not essential but experience gained within a Product Control department highly desirable
Familiarity with SQL to interrogate source systems, validate data flows, and support upstream analysis
Comfortable with other transformation tools such as Power Query, Power Automate, or equivalent as the situation demands
What we offer
A comprehensive Total Rewards Program including bonuses, flexible benefits and competitive compensation
Leaders who support your development through coaching and managing opportunities
Opportunities to work with the best in the field
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
A world-class training program in financial services