L3 Production Support Engineer

28Stone•New York, NY

23h•Hybrid

About The Position

28Stone is a full service custom solutions firm. We offer a wide range of services - from ‘tip of the spear’ advisory, application design, system architecture to implementation, testing and deployment. We partner with the world’s leading financial institutions to design and build robust financial applications that improve their business performance while reducing system risk, cost and time to market. We develop technology of value: we are proud of our proven track record of delivering quality results and the trust our clients place in us with ongoing, repeat engagements. Role Summary This L3 Production Support Engineer role demands equal parts capital markets knowledge and technical depth. You will be the person who can trace a broken trade from front-office order entry through OMS processing, reconciliation, and downstream reporting — and simultaneously drop into SQL Server to interrogate the data at the source. You understand fixed income and credit instruments, how they flow through a trading lifecycle, and why data breaks in the ways they do. And you write serious SQL — not occasional queries, but complex joins, window functions, stored procedures, and schema-level investigation as a daily practice. Important: All candidates will complete a live SQL assessment as part of the interview process. This reflects what the role actually requires day to day. Why This Role? You’ll work on production systems that directly support active trading desks — the problems are consequential and technically complex. 28Stone operates at the senior end of the market; you’ll work alongside experienced capital markets practitioners and engineers who have seen it all. Your expertise is the product — there’s no bureaucratic buffer between your skills and the impact you have. Hybrid schedule, collaborative culture, and a rate that reflects the depth of knowledge this role demands.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume