Hybrid Technical Business Analyst – Transaction Reporting, SQL, C#

at G MASS Consulting

• Job title: Technical Business Analyst – Transaction Reporting, SQL, C#
• Job type: Contract
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Python, SQL
• Location requirements: Hybrid, London, United Kingdom

About the role

• Technical Business Analyst managing UK/EU transaction reporting changes in a hybrid role with a prestigious financial institution. Bridging compliance and technology to streamline reporting processes.

Responsibilities

• 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.
• 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.
• 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.
• 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)