Margin Data & Reconciliation Analyst
AI Summary
A Margin Data & Reconciliation Analyst validates and reconciles broker margin data, investigates discrepancies, and translates business logic into Python pipelines to ensure accurate in-house broker data.
About this role
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
Skills
Explore related jobs
More jobs at G Mass
- Transaction Reporting ManagerBengaluru, Karnataka
- Technical Business Analyst / AI Field EngineerLondon, England
- Lloyd's Non-Financial Returns LeadLondon, England
- Equity Derivatives Operations BA (Calypso)London, England
- Access Governance & Compliance Operations ConsultantNew York, New York
- Lloyd's Market Reporting Consultant (Non-Financial Returns)London, England
Similar Data Pipelines jobs
Jobs in London
- Receptionist - Cecconi's Mayfair, Central LondonSoho House & Co. · 5A Burlington Gardens, London W1S 3EP
Receptionist - Cecconi's Mayfair, Central LondonSoho House via Caterer.com · London- Chef de Partie - Cecconi's Mayfair, Central LondonSoho House & Co. · 5A Burlington Gardens, London W1S 3EP
Demi Chef de PartieThe Queen's Club · London, London
German Speaking Sr. Client Success Manager - EnterpriseAddepar · London, UK- Meat CutterFarm Boy Inc. · London, ON