Trade Surveillance Data Business Analyst

Project overview

NatWest is a major UK retail bank, providing every day banking services to over 19 million customers. The banks expertise and services span retail, commercial and private banking.

AMS is a global workforce solutions partner committed to creating inclusive, dynamic, and future-ready workplaces. We help organisations adapt, grow, and thrive in an ever-evolving world by building, shaping, and optimising diverse talent strategies.

We partner with NatWest to deliver their contingent recruitment processes. Acting as an extension of their recruitment teams, we connect them with skilled interim and temporary professionals, fostering workplaces where everyone can contribute and succeed.

On behalf of NatWest, we are looking for a Trade Surveillance Data Business Analyst for an initial 9-month contract based in either London or Manchester. This role operates on a hybrid working model, with 2 days per week in the office.

Purpose of the role:

Review, validate, and assure venue data onboarding for market abuse trade surveillance, ensuring data quality, accurate mappings, transformation logic, and business rules. Use SQL and/or Python to perform pre- and post-development testing, providing evidence-based assurance that solutions meet surveillance requirements and support SME approval.

Responsibilities

The skills you'll need:

Next steps

There are plenty of reasons why NatWest is a great place to work in a temporary job; they are becoming a simpler Bank, which is more integrated and technology driven. You'll be helping to build a sustainable bank, committed to helping customers to succeed.

We will only accept workers operating via an Umbrella or PAYE engagement model.

If you are interested in applying for this position and meet the criteria outlined above, please click the link to apply and we will contact you with an update in due course.

AMS, a Recruitment Process Outsourcing Company, may in the delivery of some of its services be deemed to operate as an Employment Agency or an Employment Business

• Analyse venue source data, including trade, order and RFQ lifecycle events, to assess suitability and coverage for market abuse trade surveillance.
• Review and challenge Functional Specification Documents (FSDs), business filters, data mappings, transformation logic and data quality rules to ensure requirements are accurately defined.
• Use SQL and/or Python to validate business filters, mappings and transformations, identifying data gaps, reconciliation issues and potential surveillance risks before development.
• Conduct assurance testing of developed solutions, investigate defects, validate fixes and confirm outputs align with agreed requirements and source data.
• Document findings, maintain issue logs and collaborate with Business Analysts, Data Architects and Technology teams to resolve data quality and implementation issues.
• Validate data quality controls and reporting, ensuring completeness, accuracy and traceability of surveillance data through the SDML framework.
• Support data governance activities, including data glossary updates, impact assessments, stakeholder forums and the onboarding of new venue feeds and asset classes.
• Strong hands-on proficiency in SQL and/or Python, with the ability to independently write queries or scripts to interrogate, validate and reconcile datasets.
• Experience analysing trade and/or order data and understanding its use in market abuse surveillance.
• Experience reviewing FSDs, business filters, source-to-target mappings, transformation logic and data quality controls.
• Experience translating documented requirements into test cases and conducting data validation, UAT or post-development assurance testing.
• Strong analytical and problem-solving skills, with attention to detail and a clear evidence-based approach.
• Ability to document findings clearly, challenge requirements constructively and work collaboratively with BAs, Technology and surveillance stakeholders.
• Knowledge of data governance principles and practices, with the ability to maintain requirements-to-test traceability.
• Ability to work independently and as part of a team.

Project details

• Start: flexible
• Remote: hybrid
• Location: London, South East England, GB, GB
• Languages: English