Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data Modelling - Global
Outstanding opportunity to join this famous, global law firm within their Finance function to support the strengthening of their global e‑invoicing and continuous transaction controls (CTC) capabilities. We’re looking for a Technical Business Analyst / Integration Specialist to play a pivotal role in this transformation.
This is a hands‑on hybrid role blending business analysis, integration design, data modelling, data mapping, SQL and financial process expertise. You’ll work across multiple global jurisdictions, partnering with Finance, Tax, IT, and local offices to deliver compliant, scalable, and high‑quality integrations.
Required Experience:
* Proven experience designing integrations between finance ERPs and Accounts Payable automation tools for e‑invoicing & CTC across multiple jurisdictions.
* Strong Data modelling, canonical modelling and Data Mapping skills
* Working knowledge of PEPPOL, UBL 2.1, JSON / XML schemas, and digital certificates/signatures.
* Strong SQL skills to support the generation of JSON / XML files
* Strong understanding of Source to Pay inc. VAT, self‑billing, credit notes, withholding, FX, and tax determination.
* Knowledge of REST/JSON APIs, XML/UBL, file/batch interfaces, and familiarity with iPaaS/middleware
* Experience with PMS or ERP systems (e.g. Elite 3E, Aderant, SAP, Oracle), e‑invoicing gateways, and tax engines (e.g. ONESOURCE, Vertex).
* Strong understanding of AP/AR processes, invoice lifecycle, GL coding, cost centres, and master data.
* Excellent documentation skills (specs, mapping workbooks, sequence/data flow diagrams, control documentation).
* Experience working in Agile environments with matrixed stakeholders.
* Strong stakeholder management and clear, concise communication.
* 7+ years in Business Analysis / Integration roles with a track record in e‑invoicing & CTC programmes.
What You’ll Do:
* Gather and document business, functional, and non‑functional requirements for e‑invoicing/CTC compliance.
* Map current‑state AP/AR, tax, and reporting processes; define future‑state operating models.
* Analyse data ownership, lineage, quality rules, and reconciliation needs across PMS/ERP, billing, tax engines, data warehouses, and e‑invoicing platforms.
* Build canonical data models for invoices, credit/debit notes, and adjustments.
* Define field‑level mappings between internal schemas and external standards (PEPPOL BIS/UBL 2.1, country‑specific JSON/XML, CSV).
* Produce transformation specifications, validation rules, and exception logic.
* Define reference and master data synchronisation requirements.
* Partner with architects/engineers to design integrations with robust error handling, retries, idempotency, correlation IDs, monitoring, and alerting.
* Translate jurisdictional mandates into implementable requirements (formats, protocols, signatures, QR codes, archiving, clearance vs post‑audit).
* Coordinate pilots, phased deployments, cutover, regression analysis, and hypercare.
* Produce compliance documentation with Finance, Tax/VAT, and Risk & Compliance.
* Define test strategy, test cases, and acceptance criteria across functional, integration, negative/error, performance, and control testing.
* Prepare sample payloads (JSON, XML/UBL), mocks, and validation checks.
* Lead UAT with Finance/AP/AR and local office teams; manage defects to closure.
£75k-£85k + benefits. 12 months FTC. City of London. 40% remote.