Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]
Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]

Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]

Full-Time 75000 - 85000 £ / year (est.) No home office possible
Smart Sourcer

At a Glance

  • Tasks: Join a global law firm as a Finance Integration Business Analyst, driving e-invoicing and CTC projects.
  • Company: Renowned global law firm with a strong finance function.
  • Benefits: Competitive salary, flexible remote work, and comprehensive benefits package.
  • Why this job: Make a real impact in finance integration while working with cutting-edge technology.
  • Qualifications: 7+ years in business analysis with strong SQL and data mapping skills.
  • Other info: Dynamic role with opportunities for professional growth and collaboration across global teams.

The predicted salary is between 75000 - 85000 £ per year.

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

Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...] employer: Smart Sourcer

Join a prestigious global law firm that values innovation and collaboration within its Finance function. With a strong focus on employee growth, this role offers the chance to work in a dynamic hybrid environment, where you will engage with diverse teams across multiple jurisdictions. Enjoy competitive benefits and a supportive work culture that fosters professional development and meaningful contributions to transformative projects.
Smart Sourcer

Contact Detail:

Smart Sourcer Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]

Tip Number 1

Network like a pro! Reach out to your connections in the finance and tech sectors. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have the inside scoop on job openings.

Tip Number 2

Show off your skills! Create a portfolio or a personal website showcasing your projects related to SQL, data mapping, and e-invoicing. This gives potential employers a tangible look at what you can do, making you stand out from the crowd.

Tip Number 3

Prepare for interviews by brushing up on common questions related to finance integration and data modelling. Practice articulating your experience with PEPPOL and JSON, as well as your approach to stakeholder management. Confidence is key!

Tip Number 4

Don’t forget to apply through our website! We’ve got loads of opportunities that might just be perfect for you. Plus, it’s a great way to ensure your application gets seen by the right people.

We think you need these skills to ace Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]

SQL
Data Mapping
Data Modelling
PEPPOL
JSON
XML
Integration Design
Financial Process Expertise
Stakeholder Management
Documentation Skills
Agile Methodologies
AP/AR Processes
e-Invoicing
CTC Compliance
Problem-Solving Skills

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Finance Integration Business Analyst role. Highlight your experience with SQL, e-invoicing, and data mapping. We want to see how your skills match what we're looking for!

Showcase Your Projects: Include specific projects where you've designed integrations or worked with financial ERPs. We love seeing real examples of your work, especially if they relate to PEPPOL or JSON. It helps us understand your hands-on experience!

Be Clear and Concise: When writing your cover letter, keep it clear and concise. Explain why you're a great fit for the role and how your background aligns with our needs. We appreciate straightforward communication!

Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to hear from you!

How to prepare for a job interview at Smart Sourcer

Know Your Tech Inside Out

Make sure you brush up on your SQL skills and understand the intricacies of JSON, XML schemas, and PEPPOL. Be ready to discuss how you've used these technologies in past projects, especially in relation to e-invoicing and CTC.

Showcase Your Data Mapping Skills

Prepare examples that highlight your experience with data mapping and modelling. Think about specific scenarios where you’ve defined field-level mappings or built canonical data models, as this will demonstrate your hands-on expertise.

Understand the Business Context

Familiarise yourself with the finance processes relevant to the role, such as Source to Pay and VAT. Being able to articulate how these processes integrate with technology will show that you’re not just a techie but also understand the business side of things.

Communicate Clearly and Confidently

Practice explaining complex technical concepts in simple terms. Since you'll be working with various stakeholders, clear communication is key. Prepare to discuss how you've managed stakeholder relationships in previous roles.

Finance Integration Business Analyst – SQL, CTC, e-Invoicing, JSON, PEPPOL, Data Mapping, Data [...]
Smart Sourcer

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>