Senior QA Engineer
Permanent - Full TimeJob Overview
Pittsburgh or Boston - Hybrid
Why Confluence?
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.
More about the role & team
We’re looking for a Senior SQL professional to join a growing data and analytics team supporting mission‑critical financial and performance reporting platforms. This role is well‑suited to someone who enjoys working hands‑on with complex datasets, writing high‑quality SQL, and partnering closely with product, client services, and data teams.
You’ll play a key role in analyzing, transforming, and validating data used across client reporting, integrations, and internal platforms.
What You’ll Be Doing
- Write, optimize, and maintain advanced SQL queries for data analysis, validation, and reporting
- Work with large, complex datasets across relational databases
- Support data integrations, reconciliations, and issue resolution
- Partner with internal teams (product, analytics, client services) to understand data requirements
- Investigate data anomalies and ensure high data quality and accuracy
- Contribute to documentation and best practices around SQL and data workflows
- Support automation and process improvements where possible
What skills and experience do I need to succeed?
What We’re Looking For
- Hands‑on experience with SQL (complex joins, subqueries, CTEs, performance tuning)
- Experience in financial services, investment management, or performance reporting
- Experience working with large financial or transactional datasets
- Solid understanding of data structures and relational databases
- Ability to translate business or client requirements into data queries
- Strong problem‑solving and analytical skills
- Comfortable working independently and collaborating across teams
Nice to Have
- Exposure to Python or other scripting languages for data analysis or automation
- Experience supporting data integrations or ETL processes
- Familiarity with tools such as Power BI, Tableau, or similar analytics platforms
Why Join Us
- Work on high‑impact data that directly supports client reporting and decision‑making
- Join a collaborative, knowledgeable, and growing analytics environment
- Opportunity to influence data quality, tooling, and best practices