Lead investigation and resolution of broker margin data discrepancies by validating Python pipeline outputs against internal sources. Debug raw broker files, document margin calculation logic across account types, work with Data Engineering to translate business rules into Python, escalate structural data gaps, liaise with brokers and SMEs, and maintain mapping and audit documentation.
G MASS are partnering with a leading hedge fund to appoint a Margin Data & Reconciliation Analyst on an initial 6-month contract, based in London. Sitting within a Strategic Solutions function, this role is central to building out the firm's broker data handling capabilities, with responsibility for validating, troubleshooting, and codifying the ingestion of direct broker margin files.
You'll act as the connective tissue between intricate margin methodologies, internal accounting systems, and Python-based data engineering pipelines, with the ultimate goal of ensuring the firm's new in-house broker data either matches or knowingly improves upon legacy feeds.
Responsibilities:
- Take the lead on investigating margin data discrepancies day to day (Posted, Initial Margin, Variation, and Excess), comparing outputs from the Python replication dashboard against internal golden sources
- Dig into raw broker files to get to the bottom of accounting breaks, whether that's a mapping error, a parsing issue, or a more fundamental margin methodology mismatch
- Build out and document the underlying calculation logic for margin across different account types (Futures, PB, FIPB, OTC Non-Cleared), factoring in FX conversions for non-USD accounts and any custom aggregation rules
- Work hand in hand with Data Engineering, converting business logic into workable Python code and flagging where bugs, mistargeted data, or missing flags are causing issues
- Own escalations around structural data gaps, including direct liaison with broker contacts and internal SMEs to sign off on bespoke account treatments
- Keep mapping logic, trackers, and supporting documentation current and accurate, ensuring a clear audit trail of how broker files feed into internal systems
Requirements
- Solid grounding in Prime Brokerage, FIPB, and Futures margin mechanics
- Confidence working through dense, multi-tab financial data files
- Some exposure to data pipeline architecture
- A naturally analytical mindset, with the ability to turn business logic into clean, programmatic rules
Benefits
Length: Initial 6-month contract
Competitive salary
Similar Jobs
Fintech • Mobile • Payments • Software • Financial Services
Design, implement, and operate low-latency stream processing pipelines and tooling on AWS using Flink and Kafka. Build platform services for real-time validation, fraud and AML checks, enable data movement to the data lake, and support product teams with automation, best practices, and scalable infrastructure.
Top Skills:
Apache FlinkApache IcebergApache KafkaAWSJavaKafka StreamsKubernetes (K8S) OperatorsSpring
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning • Software
Lead and scale Nexthink's channel partner ecosystem across Europe: drive revenue, recruit and enable partners, build executive relationships, coach regional channel team, run joint go-to-market plans, and collaborate cross-functionally to deliver measurable partner-driven growth.
Fintech • Mobile • Payments • Software • Financial Services
Lead Product Analyst for Business Account Management: deliver actionable insights, define KPIs, run A/B tests, build automated data pipelines and dashboards, identify high-impact opportunities, and lead cross-team projects (fraud, chargebacks, pricing) to inform product strategy and improve Multi-User Access adoption and depth.
Top Skills:
AirflowDbtSQL
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
