Confluence

Database Developer

Confluence

full-time

Posted on:

Location Type: Hybrid

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

MS SQL ServerPythonSQL

About the role

  • 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

Requirements

  • 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)
  • Prior experience with investment performance reporting or analytics systems
  • 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
  • Python experience (nice to have)
  • Experience using AId-assisted development tools for coding or testing (nice to have)
  • Background with asset managers, investment advisors, custodians (nice to have)
Benefits
  • 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!
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Microsoft SQL ServerSQLT-SQLperformance optimizationtroubleshootingdatabase logicanalyticsreportingPythonAId-assisted development tools
Soft Skills
collaborationproblem-solvingcommunication