Senior Application Engineer

We are seeking a highly skilled Senior Application Engineer with deep T-SQL expertise to join the Liquid Credit Engineering Team, a key division within our broader Investment Systems organization. In this role, you will focus on designing, developing, and supporting the critical technology solutions that power our liquid credit investment workflows - spanning trade processing, portfolio reporting, and advanced data management.

You will collaborate closely with portfolio managers, traders, operations professionals, and fellow engineering teams to build, optimize, and scale high-performance systems that support the firm's core investment functions.

Req# 1060032160

Responsibilities

• Solution Development: Design, develop, and maintain robust, scalable software solutions supporting complex liquid credit investment processes and workflows
• Data Integration: Seamlessly integrate high-volume financial data across multiple systems involved in credit investing to ensure a unified and accurate data landscape
• Database Optimization: Write and optimize complex stored procedures, queries, and data models in SQL Server (2016 or later) to ensure maximum database performance and data integrity
• Reporting Solutions: Build, customize, and enhance reporting capabilities using SQL Server Reporting Services (SSRS) and SQL-based data models
• Collaboration & Alignment: Work in lockstep with cross-functional teams, including front-office users (traders, portfolio managers), operations teams, and product stakeholders
• Architecture & Best Practices: Participate in system architecture design sessions and contribute actively to engineering standards, documentation, and best practices
• Production Support: Troubleshoot and resolve critical production issues in a timely manner to maintain system reliability and minimize business impact

Requirements

• T-SQL Expertise: Strong hands-on experience with SQL Server (2016 or later), featuring advanced skills in query optimization, data modeling, and writing complex stored procedures
• Reporting Tools: Proven track record of building and enhancing reports using SSRS
• Software Engineering Fundamentals: Solid understanding of modern software engineering principles, including data structures, Object-Oriented Programming (OOP), and system design
• Financial Services Context: Experience working in financial services, asset management, or investment systems (highly preferred)
• Execution & Analytical Skills: High attention to detail, excellent analytical and problem-solving abilities, and the capacity to manage multiple priorities in a fast-paced environment
• Communication: Outstanding verbal and written communication skills, with the ability to translate complex technical concepts to non-technical business stakeholders

Nice to have

• Programming Languages: Proficiency in Python for data processing, scripting, or backend development
• Industry Systems: Hands-on experience with Allvue's cloud-native platform (Everest), particularly with trade/order management modules
• Domain Knowledge: Strong understanding of the trade lifecycle, Order Management Systems (OMS), or Portfolio Management Systems (PMS)
• Cloud Infrastructure: Familiarity with AWS (cloud services, architecture, and deployment)
• Modern DevOps: Experience with CI/CD pipelines, DevOps practices, and microservices architecture