Database Developer Department:Development - Software DevelopmentEmployment Type:Permanent - Full TimeLocation:Montreal, CanadaReporting To:Jimmy WeiDescription Canada - Toronto - RemoteAt Confluence we are committed to innovation, precision, and partnership in the investment data space. Our global footprint spans multiple countries, giving employees exposure to diverse cultures. Our success relies on our hardworking team.Key Responsibilities Build the Data Engine Behind Investment Performance ReportingAs a Database Developer, you will play a hands‑on role 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.Enjoy solving complex SQL performance problems and working with investment data? This is a fit. This is not a traditional DBA role. You will solve engineering challenges across high‑volume datasets and work closely with experienced engineers to deliver scalable solutions.What you will be doingBuild and optimise SQL Server logic that supports investment performance calculations and reportingImprove query performance and resolve bottlenecks across large and complex datasetsTranslate investment data from custodians and market sources into structured, analytics‑ready modelsWork closely with engineering and product teams to ensure outputs are accurate, reliable and aligned to client needsCandidates must have the right to work in the US on a permanent basis (no visa sponsorship available).Skills, Knowledge & Expertise Core technical skillsDeep experience with SQL ServerStrong experience writing and optimising complex SQL and T‑SQL queriesProven ability to troubleshoot and improve performance at scaleExperience building database logic for analytics or reporting environmentsDomain expertiseExperience working with investment performance, performance reporting, or closely related financial systems within an investment management environmentPractical exposure to asset classes such as fixed income, equities, or multi‑asset portfolios, and how these are represented in performance and portfolio dataConfident understanding of returns, benchmarks and portfolio structures, with the ability to validate outputs in a real‑world contextFamiliarity with custodial, market or portfolio accounting data and how it feeds performance reportingComfortable identifying when results do not look right and investigating data or calculation issuesNice to havePython experienceExposure to modern development tooling including AI‑assisted toolsExperience working with asset managers, fund administrators or investment data vendorsExposure to concepts such as composites or attribution is beneficialJob BenefitsGenerous Time Off packages including additional half days with each public holiday in your locationGlobal Career Development opportunitiesSocial EventsReferral Bonus scheme – up to $3,000 per successful referralPlus many moreValuesIntegrity – Face reality with honesty, courage and accountabilityImagination – Deal creatively with challenges and envision what the world could beDiscipline – Build good habits into reflexes which become a part of our lifeService – Committed to the success of othersLocation We offer flexible working options for all employees. Remote is available.#J-18808-Ljbffr