Associate Director responsible for Product Control automation solutions at RBC. Leading transformative initiatives for Macro products with strong technical capabilities using Python and VBA.
Responsibilities
Lead data validation and business requirements definition for Macro PC onboarding onto PLANET, RBC’s centralised reporting platform, covering FX, Flow Rates, Structured Rates, and Commodities, identifying gaps and remediation actions.
Support testing, UAT, and data quality validation for platform onboarding and BAU release cycles, ensuring P&L, balance sheet, and reporting outputs are accurate and complete.
Design and build Python and VBA-based automation solutions to reduce manual effort and improve control across EUC processes during the platform transition.
Lead re-engineering of Macro PC workflows to ensure compatibility with centralised platform data flows, booking conventions, and reporting hierarchies.
Assess, catalogue, and prioritise the Macro PC EUC landscape for stabilisation or elimination, defining and executing an EUC elimination roadmap over time.
Work closely with the SOP/BPM team to translate newly drafted standards into actionable operational change within Macro PC, identifying and closing gaps between current practice and agreed standards.
Build trusted working relationships with Macro PC controllers and stakeholders, facilitating workshops and discovery sessions to drive collaborative process redesign.
Share knowledge of platform capabilities with Macro PC teams and support the development of runbooks and training materials in collaboration with the BPM team.
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.
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.
Benefits
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.
Job title
Associate Director – Product Control Business Re-Engineering & Automation
Director of Engineering leading a team to enhance user experience at Spotify. Collaborating with cross - functional teams to define goals and deliver impactful solutions in a dynamic environment.
Azure Integration Developer enhancing API wrappers and cloud - based integrations with Outlook. Supporting a financial services organization in a fast - paced technical environment.
Engineering Technician III responsible for highway construction material quality assurance. Overseeing testing and inspections to ensure compliance with industry standards and specifications.
Head of Software Development leading a team in cloud transformation projects for a manufacturing software company. Overseeing technical excellence and modern engineering practices in a hybrid work environment.
Product Developer at Twelve, leading product development for beauty, wellness, and lifestyle merchandise. Collaborating with clients and creative teams to deliver high - quality products.
Formation en alternance pour devenir Développeur d’Applications. 100% prise en charge, formation à distance en collaboration avec des entreprises partenaires à Niort.
Power BI / Power Apps Developer designing and maintaining business solutions in the Public Sector. Collaborating with teams to integrate data sources and provide actionable insights from actionable data.
Statistical Programmer II at Syneos Health working with SAS for drug development analysis. Collaborating in hybrid settings involving statistical programming for clinical solutions to enhance healthcare outcomes.
Sr Statistical Programmer developing statistical programming for clinical trials at Syneos Health. Collaborating with cross - functional teams and managing multiple projects in a hybrid work environment.
Head of IT Products & Engineering at McMillan Shakespeare overseeing the transformation to product - led engineering. Responsible for strategic direction and execution in AI - assisted development.