Senior Application Engineer

About the Position

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.

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.

We Offer

• 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

About the Company

[Company description if present]