Investigate and resolve complex L3 production issues involving trade data, positions, holdings, reconciliation breaks, and downstream reporting failures.
Trace issues end-to-end across the trading lifecycle — from order and execution through allocation, settlement, and accounting feeds — to isolate root cause.
Write, debug, and optimize T-SQL queries daily: complex joins, window functions, CTEs, views, and stored procedures.
Author and modify stored procedures as part of issue resolution and ongoing operational improvements.
Diagnose failed data imports/exports, ETL failures, interface errors, and data feed disruptions across OMS, accounting, and custody systems.
Partner directly with portfolio managers, traders, operations staff, and technology teams to communicate findings and drive resolution.
Document issues and resolutions clearly; contribute to operational runbooks and knowledge base articles.
Identify and escalate systemic or recurring issues with evidence-based root cause analysis.

Trading workflow expertise: You understand the full trade lifecycle in fixed income and/or credit markets — order, execution, allocation, settlement, reconciliation — and can reason about where and why data breaks occur.
Hands-on T-SQL / SQL Server: Daily, production-level SQL: complex joins, window functions, CTEs, views, stored procedures. You read and write them under pressure, not just reference them.
Stored procedure development: You can author new stored procedures and modify existing ones as part of resolving production issues.
Production support experience: Background supporting mission-critical systems in a financial services environment, with clear ownership of incident investigation and resolution.
Communication under pressure: Ability to translate technical findings clearly to both engineering teams and non-technical trading/operations stakeholders.
At least 5+ years of experience in application support for Investment and Trading teams.

Considered as advantage:

Experience with OMS or portfolio management platforms such as Everest (Allvue/Black Mountain), Charles River (CRD), or Bloomberg AIM.
Familiarity with XSLT/XML data transformations.
Exposure to ETL pipeline troubleshooting and data feed architecture.
Experience working across custody, fund accounting, or prime brokerage workflows.

This is a contractor position only (C2C).
Looking for individuals with 5+ years of experience.
Candidates should be prepared to demonstrate their hands-on SQL skills during the interview process. This may include tasks such as writing, modifying, and troubleshooting SQL Server queries and stored procedures in real time to solve data problems or answer technical scenarios relevant to the role.
Compensation ranges from $80-110 per hour based on experience and qualifications. Higher rates may be considered for exceptionally strong candidates.
Candidates should be local to the NYC Area and can work in a hybrid model (3 days in the office.)
We are flexible and take an individualized approach with each candidate we meet, so we encourage you to apply even if you do not meet every listed requirement.
Only candidates who have the right to work in USA are considered for this position.

L3 Production Support Engineer

Key skills