About the job
Join 28Stone, a premier custom solutions firm. We specialize in delivering a comprehensive suite of services ranging from top-tier advisory, application design, system architecture, to implementation, testing, and deployment.
Partnering with leading financial institutions, we design and develop robust financial applications that enhance business performance while effectively mitigating system risk, cost, and time to market.
We pride ourselves on delivering technology that holds value: Our proven track record of achieving quality outcomes has earned us the trust of our clients, resulting in ongoing and repeat engagements.
Role Overview:
As an L3 Production Support Engineer, you will utilize your deep understanding of capital markets and your technical expertise to troubleshoot complex issues. You will trace broken trades from order entry through OMS processing, reconciliation, and downstream reporting, while also utilizing SQL Server for data interrogation.
Your knowledge of fixed income and credit instruments and their flow through the trading lifecycle will be essential in understanding data discrepancies. You will engage in writing sophisticated SQL queries, including complex joins, window functions, stored procedures, and conducting schema-level investigations as part of your daily tasks.
Important: All candidates will undergo a live SQL assessment during the interview process to reflect the daily requirements of the role.
Key Responsibilities:
- Investigate and resolve intricate L3 production issues related to trade data, positions, holdings, reconciliation discrepancies, and reporting failures.
- Trace issues throughout the trading lifecycle, isolating root causes from order execution to settlement and accounting.
- Daily tasks will include writing, debugging, and optimizing T-SQL queries involving complex joins, window functions, CTEs, views, and stored procedures.
- Author and modify stored procedures for issue resolution and operational improvements.
- Diagnose failed data imports/exports, ETL failures, interface errors, and disruptions in data feeds across OMS, accounting, and custody systems.
- Collaborate with portfolio managers, traders, operations staff, and technology teams to communicate findings and drive resolutions.
- Document issues and resolutions clearly; contribute to operational runbooks and knowledge base articles.
- Identify and escalate systemic or recurring issues through evidence-based root cause analysis.
Why Consider This Role?
- You will engage with production systems that directly support active trading desks, facing consequential and technically challenging problems.
- At 28Stone, you will work alongside seasoned capital markets practitioners and engineers who bring extensive experience.
- Your expertise will contribute directly to the improvement of trading systems and processes.

