Margin Data & Reconciliation Analyst

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