L3 Production Support Engineer

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.

What You’ll Do:

• 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.

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.

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.

Benefits:
Employment Details:

• 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.