Database Developer

Overview Pittsburgh or Boston | Hybrid 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: Boston, US Workplace type: Hybrid Key Responsibilities We’re building and modernizing the data foundation behind a market‑leading investment performance analytics platform used by large enterprise financial institutions. As a Database Developer, you’ll play a critical, hands‑on role in designing and optimizing high‑performance SQL solutions that power complex investment analytics at scale. This is not a traditional DBA role — it’s a deep, problem‑solving development role where your work directly impacts how global clients measure and understand investment performance.

What you’ll do Design, build, and optimize SQL Server stored procedures and complex queries that support large‑scale investment performance calculations Map and transform data from custodial and investment data sources into structured, analytics‑ready data models Diagnose and resolve performance bottlenecks across very large datasets (millions to billions of records) Partner closely with application and UI engineers whose reports and dashboards rely on your database outputs Collaborate with onshore engineers and an offshore development team to deliver scalable, enterprise‑grade solutions Contribute to platform modernization initiatives for new large enterprise client programs You’ll join a highly experienced engineering team working on complex, meaningful problems at the intersection of data, finance, and analytics. Skills, Knowledge & Expertise What we’re looking for Core technical skills Expert‑level Microsoft SQL Server experience (non‑negotiable) Strong hands‑on experience writing and tuning complex SQL and T‑SQL Proven background in SQL Server performance optimization and troubleshooting Experience building database logic for analytics and reporting environments (not infrastructure or admin‑focused roles) Domain expertise (essential) Prior experience with investment performance reporting or analytics systems Investment management industry experience is key Solid understanding of core investment concepts such as: Equity vs. fixed income; Benchmarks and returns; Custodial data and financial data structures Ability to sense‑check and validate what “reasonable” performance outcomes should look like Nice to have Python experience Experience using AI‑assisted development tools for coding or testing Background with asset managers, investment advisors, custodians Be part of a supportive team that sits at the heart of how our data is managed and used. You’ll work on meaningful systems that power analytics and client outcomes, learn from experienced teammates, and collaborate closely with other teams across the business.

This is a great opportunity to grow your technical skills while contributing ideas, improving tools, and helping shape how we work with data every day. About Confluence 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.

Documents Database developer investment performance reporting (1) — Viewable within the job posting. Our Hiring Process Details of stages are provided by the employer outside of this description. #J-18808-Ljbffr