At Confluence, we’ve always been driven by a commitment to innovation, precision, and partnership in the investment data space. Our global footprint now spans multiple countries, giving our employees the opportunity to get exposure to other countries and cultures. And it stands to reason that none of this would have been possible without the hundreds of hard-working employees who work at Confluence.

Department: Development - Software Development
Employment Type: Permanent - Full Time
Location: Montreal, Canada
Workplace type: Fully remote
Reporting To: Jimmy Wei

Key Responsibilities

🚀 Build the Data Engine Behind Investment Performance Reporting

As a Database Developer, you will play a hands on role in shaping the data layer that underpins investment performance calculations used by enterprise clients. This role sits at the core of how returns, benchmarks and portfolio data are processed, validated and delivered.

You will work on large scale, performance critical systems where accuracy and efficiency matter. Your work will directly influence how clients understand and trust their data.

If you enjoy solving complex SQL performance problems and working with investment data, this is a strong fit.This is not a traditional DBA role. You will be solving engineering challenges across high volume datasets and working closely with experienced engineers to deliver scalable solutions.

What you will be doing

Build and optimise SQL Server logic that supports investment performance calculations and reporting
Improve query performance and resolve bottlenecks across large and complex datasets
Translate investment data from custodians and market sources into structured, analytics ready models
Work closely with engineering and product teams to ensure outputs are accurate, reliable and aligned to client needs

Candidates must have the right to work in the US on a permanent basis (no visa sponsorship available).

Skills, Knowledge & Expertise

Core technical skills

Deep experience with SQL Server
Strong experience writing and optimising complex SQL and T SQL queries
Proven ability to troubleshoot and improve performance at scale
Experience building database logic for analytics or reporting environments

Domain expertise

Experience working with investment performance, performance reporting, or closely related financial systems within an investment management environment
Practical exposure to asset classes such as fixed income, equities, or multi asset portfolios, and how these are represented in performance and portfolio data
Confident understanding of returns, benchmarks and portfolio structures, with the ability to validate outputs in a real world context
Familiarity with custodial, market or portfolio accounting data and how it feeds performance reporting
Comfortable identifying when results do not look right and investigating data or calculation issues

Nice to have

Python experience
Exposure to modern development tooling including AI assisted tools
Experience working with asset managers, fund administrators or investment data vendors
Exposure to concepts such as composites or attribution is beneficial

This is an opportunity to work on systems that sit at the centre of investment reporting. You will be part of a team improving how performance data is processed and delivered, with scope to influence how the platform evolves as it scales.

Job Benefits

Confluence offers generous benefit packages for team members. As a growing, global organization, we are always looking for ways to ensure that our employees can access benefits that matter to them and their families. This includes:

🕚 Generous Time Off packages including additional half days with each public holiday in your location.

🌎 Global Career Development opportunities

🎊 Social Events

💵 Referral Bonus scheme - Upto $3,000 per successful referral

🚀 Plus many more!

More about the Location

We offer flexible working options for all employees.

#Remote

Values

We look for people who align with our 4 values.

Integrity

Face reality with honesty, courage and accountability

Imagination

Deal creatively with challenges and envision what the world could be

Discipline

Build good habits into reflexes which become a part of our life

Service

Committed to the success of others

If you would like to find out more about a Career at Confluence, please apply today.

If you believe that this job posting is noncompliant, please email us at recruitment@confluence.com.

Pre-Employment Screening Disclaimer
As part of our recruitment process, we carry out identity checks on all candidates. Offers of employment are conditional upon the completion of satisfactory background checks prior to the commencement of work. These checks may include verification of identity, right to work in the UK, employment history, and other relevant pre-employment screening.

Please note that additional checks may be required depending on the nature of the role and the jurisdiction in which the role is based or operates. These may include, but are not limited to, criminal record checks or financial background checks where applicable.

About Confluence Technologies

As a leading global technology solutions provider to the investment management industry, Confluence helps clients solve complex investment data challenges across the front, middle and back office. Headquartered in Pittsburgh, PA, Confluence services over 1000 clients in 40 countries, with locations across Europe, North America, South Africa, Australia and Asia.