Investments QA Lead - Remote, Data Quality & SQL Expert

Ledgent Technology; Newport Beach (CA); Remote; USD 83,000 - 96,000; Full time

Job summary

Ledgent Technology is seeking an experienced QA Lead to ensure an Investments data warehouse meets rigorous quality standards. You will lead testing efforts across functional, integration, regression and UAT, with strong focus on SQL data validation and Power BI verification.

The role requires knowledge of fixed income/financial products and experience in CI/CD environments. This remote position offers a 1-year duration with potential extension and close collaboration with product managers and

Qualifications

• 5+ years of QA experience testing data-intensive applications.
• Strong understanding of testing methodologies and SDLC best practices.
• Proficiency in SQL and handling large financial datasets.

Responsibilities

• Define and implement test strategies, including planning, execution, and reporting.
• Lead functional, integration, regression and UAT testing efforts.
• Manage defect lifecycle, root cause analysis, and communicate business impact.
• Document and maintain test cases and test scripts.
• Perform SQL-based data testing, including joins and large dataset validation.
• Validate Power BI reports against underlying data.
• Integrate and run tests within CI/CD pipelines (Azure DevOps).
• Conduct data analysis and data lineage; identify recurring bug patterns.
• Collaborate with product managers, developers and analysts to ensure requirements are met.
• Support internal controls, audits and regulatory reviews with documentation.
• Use DBT for testing.

Skills

QA Leadership

SQL Proficiency

Data Validation

SDLC Best Practices

Power BI Validation

Data Reconciliation

Tools

Azure DevOps

Jira

Snowflake

DBT

Job description

Ledgent Technology is seeking an experienced QA Lead to ensure an Investments data warehouse meets rigorous quality standards. You will lead testing efforts across functional, integration, regression and UAT, with strong focus on SQL data validation and Power BI verification.

The role requires knowledge of fixed income/financial products and experience in CI/CD environments. This remote position offers a 1-year duration with potential extension and close collaboration with product managers and