Margin Data and Reconciliation Analyst

G MASS Consulting

Margin Data & Reconciliation Analyst working with a hedge fund to improve broker data handling capabilities. Investigating margin data discrepancies and resolving accounting issues for optimized operations.

Posted 7/3/2026contractLondon • 🇬🇧 United KingdomMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Python

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

Length: Initial 6-month contract
Competitive salary

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Margin MechanicsData Discrepancy InvestigationFinancial Data AnalysisCalculation Logic DocumentationFX Conversion Handling

Soft Skills

Analytical ThinkingProblem-SolvingCollaboration