Senior Application Engineer

Job summary

Design, develop, and maintain scalable software solutions and data integrations for liquid credit investment workflows. Optimize SQL Server databases and build reporting capabilities using SSRS while collaborating with front-office and operations teams.

Job details

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 The recruiting efforts for this position are intended to fill an existing vacancy for a new position. 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 This posting includes a salary range EPAM Canada would reasonably expect to pay the selected candidate. Individual compensation offers within the range are based on a variety of factors, including, but not limited to, experience, credentials, education, training, the demand for the role, skillset, and overall business and local labour market considerations. Most candidates are hired at a salary within the range disclosed. Salary range: CA$110,000-CA$140,000. In addition, the details highlighted in this job posting above are a general description of all other expected benefits and compensation for the position. An artificial intelligence system is software that is developed with one or more techniques that can, for a given set of human-defined objectives, using algorithmic information processing, generate outputs such as content, predictions, recommendations, or decisions with varying levels of autonomy (“AI”). Tasks that humans have traditionally done by thinking and reasoning are increasingly being done by, or with the help of, AI to help create efficiencies.EPAM may use AI during the recruitment process, in connection with collecting or processing your personal data. Some (non-exhaustive) examples of tasks that EPAM may use AI for include conducting initial screening, creating transcripts of interviews, and assessing applications/CVs against defined job description criteria to make suggestions to the individuals evaluating your candidacy.Your personal data and the results of any processing are not shared with AI applications outside of EPAM infrastructure. While EPAM may use AI to help create efficiencies during the recruitment process, EPAM does not use AI to make hiring decisions, which is done by EPAM Talent Acquisition and management. EPAM Canada welcomes and encourages applications from candidates with disabilities. Please contact WFA Human Resource CA WFAHRCA@epam.com if you have questions in this regard, or if you require an accommodation to complete the application process. Click here to review EPAM’s Accessibility for Ontarians with Disabilities Accessibility Policies and Multi-Year Access. EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our clients, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential. Engineer the Future with a Career at EPAM

What you’ll do

Design, develop, and maintain scalable software solutions and data integrations for liquid credit investment workflows. Optimize SQL Server databases and build reporting capabilities using SSRS while collaborating with front-office and operations teams.

Requirements

Requires advanced T-SQL expertise in SQL Server 2016+ and a proven track record with SSRS reporting. Candidates should have a strong foundation in software engineering principles and experience within financial services or asset management.

Benefits

• Extended Healthcare with Prescription Drugs
• Dental and Vision
• Healthcare Spending Account
• Life and AD&D Insurance
• Employee Assistance Program
• Telehealth
• Short-term Disability
• Long-Term Disability
• Paid Time Off
• 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

Listed skills

• Python · Preferred
• Amazon Web Services · Preferred
• CI/CD · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• T-SQL
• SQL Server
• SSRS
• Query Optimization
• Data Modeling
• Stored Procedures
• Object-Oriented Programming
• System Design
• Python
• AWS
• CI/CD
• DevOps
• Microservices
• Allvue Everest
• Trade Lifecycle
• Portfolio Management Systems

Job areas

• Software
• Technology
• Engineering
• Finance & Accounting
• Data & Analytics

More jobs from EPAM Systems