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

Benefits

• Extended Healthcare with Prescription Drugs, Dental and Vision, and Healthcare Spending Account (Company Paid)

• Life and AD&D Insurance (Company Paid)

• Employee Assistance Program (Company Paid)

• Telehealth (Company Paid)

• Short-term Disability (Company Paid)

• Long-Term Disability

• Paid Time Off (including vacation and sick days)

• Registered Retirement Savings Plan (RRSP) with Company match

• Maternity/Parental/Adoption Leave Top-up

• Employee Stock Purchase Program

• Critical Illness Insurance

• Employee Discounts

• Unlimited access to LinkedIn learning solutions