Business Analyst, Data
EXL
contract
Posted on:
Location Type: Hybrid
Location: Bristol • United Kingdom
Visit company websiteExplore more
Tech Stack
About the role
- Convert high-level business needs into detailed technical mapping specifications for Data Engineers.
- Investigate data lineage, trace transformations, and validate upstream → downstream flows.
- Analyse large datasets across Derivatives and Non-Derivatives products to identify data gaps and inconsistencies.
- Lead complex data mapping analyses for Counterparty Credit Risk (CCR) to migrate the reporting from On-Prem to GCP platform.
- Engage closely with Risk, Finance, Operations, Tech, and Data Engineering teams to gather requirements.
- Facilitate working sessions, clarify logic, and ensure adherence to regulatory expectations.
- Coordinate dry-run cycles of RWA calculations on the GCP strategic platform.
- Support user testing, validation, and sign‑off activities with Risk and Ops teams.
Requirements
- Expert SQL skills with ability to write complex queries, troubleshoot logic, and optimise performance.
- Strong understanding of data modelling, ETL/ELT flows, and data quality assessment.
- Ability to analyse data lineage, source-to-target mappings, and transformation logic.
- Understanding of Counterparty Credit Risk (CCR), OTC Derivatives, EAD, RWA.
- Proven ability to translate complex regulatory requirements into clear technical specifications.
- Experience working with Risk and Finance functions in a banking environment.
- Ability to run workshops, document requirements (BRDs, FRDs, mapping specs), and manage testing cycles.
- Exposure to Agile delivery methodologies.
- Strong analytical mindset with meticulous attention to detail.
- Excellent communicator able to collaborate with both business SMEs and technical engineers.
- Self-driven, proactive, and able to manage competing priorities.
- Comfortable operating in a fast-paced, high‑stakes regulatory environment.
- Hands‑on experience with GCP BigQuery.
- Strong understanding of:
- Derivatives (e.g., swaps, options, forwards, futures)
- Non-derivatives (e.g., bonds, repos, securities)
- Exposure calculations, sensitivities, EAD, EEPE, SA‑CCR etc.
- Prior experience in large-scale CCR programmes.
- To be considered for this role, you must already be eligible to work in the United Kingdom.
Benefits
- Flexible hybrid working
- Umbrella Contract (Inside IR35)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdata modellingETLELTdata quality assessmentdata lineage analysissource-to-target mappingstransformation logicregulatory requirements translationRWA calculations
Soft Skills
analytical mindsetattention to detailexcellent communicationcollaborationself-drivenproactivemanaging competing prioritiesfacilitating workshopsdocumenting requirementsmanaging testing cycles