Technical Business Analyst - Transaction Reporting (SQL / C# / Python)

ace has partnered with a prestigious, leading global financial institution to appoint an experienced Transaction Reporting Change & Release Lead to own the end-to-end lifecycle of UK/EU transaction reporting change from regulatory interpretation through to controlled production deployment.

This is a hybrid technical business analyst & hands-on SQL/development role. You will act as the bridge between Compliance, Operations, Risk and Technology, translating regulatory requirements into actionable change specifications, governing release delivery, and strengthening production controls. A core objective is reducing key person dependency by standardising documentation, runbooks, knowledge transfer, and repeatable release processes.

Please note this role requires presence in the client’s London office (days to be confirmed).

Responsibilities

Change, Release & Governance

• Own and manage the end-to-end lifecycle of UK/EU transaction reporting changes: regulatory interpretation, impact assessment, prioritisation, build/test coordination, production deployment.
• Govern reporting logic changes across reporting platforms and upstream systems, leading release planning, change prioritisation, and delivery timelines aligned to regulatory and business deadlines.
• Ensure all changes follow formal governance and approval processes (e.g., CAB, go/no-go decisions), with strong evidence capture and audit trails.
• Act as the key liaison across Compliance, COO, Technology, Operations, Risk, and external ARMs/vendors.

Technology & Processes

• Partner with developers and architecture to build a detailed understanding of transaction reporting infrastructure, data flows, dependencies, and the existing build/test/release process.
• Translate regulatory and business requirements into actionable delivery artefacts: requirements, functional specs, rules, validation logic, and acceptance criteria.
• Reduce key person dependency through improved documentation, knowledge sharing, and clearer cross-functional understanding of reporting systems and logic.
• Support the design and rollout of more robust, scalable and repeatable release processes for reporting change.

Transaction Reporting SME

• Act as an SME on UK/EU reporting requirements including ARMs, reportable fields, and validation rules, converting regulatory text into implementable rules and specifications.
• Provide guidance on regulatory interpretation, including ESMA Q&As and ARM feedback, ensuring reporting logic remains aligned to current obligations.
• Define technical change requirements across fields, mappings, validations, and exception handling.

Testing, Release, Controls & Defect Management

• Define and execute end-to-end testing and release assurance for reporting logic changes (system, regression, and UAT), ensuring robust evidence, data-quality controls, and formal sign-off prior to deployment.
• Manage controlled production deployments and fixes, agreeing deployment steps, rollback and contingency plans with Technology, and coordinating validation with Operations.
• Perform post-deployment validations, reconciliations, and control checks to confirm reporting completeness and accuracy, and lead root cause analysis for defects through to remediation via controlled change.

Requirements:
• Strong experience delivering UK/EU transaction reporting change in a regulated environment, including regulatory interpretation through to production deployment.
• Demonstrated ownership of formal change and release governance (CAB/go-no-go, evidence, audit trail, approvals).
• Detailed understanding of front-to-back trade lifecycle data across OTC and exchange-traded workflows.
• Advanced SQL skills (complex query design, optimisation, stored procedures) for deep investigation, reconciliation, and defect analysis across multiple systems.
• Coding capability in C# or Python for data manipulation, control automation, and delivery utilities (e.g., enrichment scripts, reconciliation tooling, file parsers, API clients).
• Experience working with ARMs/TRs, CCP/clearing data, and exchange reporting workflows; familiarity with common schemas (e.g., EMIR RTS/ITS fields) strongly preferred.
• Ability to interpret regulatory texts and convert them into actionable rules, validation checks, and technical specifications.
• Strong problem-solving mindset, high attention to data quality, and excellent stakeholder communication.

Benefits:
Initial 12-month contract

Rate to be discussed

London-based role (onsite expectation to be confirmed)

About us

ace is a specialist post-digital advisory and delivery partner helping financial institutions implement high-impact automation, AI, and post-digital solutions in regulated environments. We combine deep technical expertise with a practical understanding of governance, controls, and operational risk to delivery production-grade outcomes at pace.

We are part of the G MASS group, a global financial services resource augmentation and consulting firm that provides expert talent and delivery support across transformation, change, and operational resilience.