Database Developer
Pittsburgh, PA - USA
Job Summary
Pittsburgh or Boston Hybrid
Why Confluence
Why Confluence
At Confluence weve 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.
Key Responsibilities
Were building and modernizing the data foundation behind a marketleading investment performance analytics platform used by large enterprise financial institutions. As a Database Developer youll play a critical handson role in designing and optimizing highperformance SQL solutions that power complex investment analytics at scale
This is not a traditional DBA role its a deep problemsolving development role where your work directly impacts how global clients measure and understand investment performance.
What youll do
- Design build and optimize SQL Server stored procedures and complex queries that support largescale investment performance calculations
- Map and transform data from custodial and investment data sources into structured analyticsready 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 enterprisegrade solutions
- Contribute to platform modernization initiatives for new large enterprise client programs
Youll join a highly experienced engineering team working on complex meaningful problems at the intersection of data finance and analytics.
Skills Knowledge & Expertise
What were looking for
Core technical skills- Expertlevel Microsoft SQL Server experience (nonnegotiable)
- Strong handson experience writing and tuning complex SQL and TSQL
- Proven background in SQL Server performance optimization and troubleshooting
- Experience building database logic for analytics and reporting environments (not infrastructure or adminfocused 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 sensecheck and validate what reasonable performance outcomes should look like
Nice to have
- Python experience
- Experience using AIassisted 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. Youll 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.
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 $3000 per successful referral
Plus many more!
More about the Location
We offer flexible working options for all employees.
#LI-Hybrid
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 .
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.
If you believe that this job posting is noncompliant please email us at .
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.
Required Experience:
IC
About Company
We are are a global leader in data-driven investment management solutions delivering products and services to optimize efficiency and control.