Investments QA Lead - Data Validation & BI Testing (Remote)

Ledgent Technology; United States; Remote; USD 125,000 - 146,000; Full time

Job summary

Ledgent Technology is seeking an Investments QA Lead (Techno/Functional) III to oversee testing of an investments data warehouse. You will lead functional, integration, regression and UAT testing, perform SQL-based validation, and ensure data accuracy against Power BI reports.

You will collaborate with product managers, developers and analysts, drive defect root cause analysis, and support compliance through detailed documentation in a remote US-based role.

Qualifications

• 5+ years of experience in quality assurance, with a focus on data-intensive applications.
• Strong understanding of testing methodologies and SDLC best practices.
• Proficiency in SQL and working with large financial datasets.
• Foundational understanding of fixed income instruments (Bonds, MBS, ABS), mortgage loans, equities and derivatives.
• General familiarity of terms and conditions related to financial products.

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 communication of business impact.
• Document and maintain comprehensive test cases and test scripts.
• Perform SQL-based data testing, including joins, aggregations, and large dataset validation.
• Validating Power BI reports against underlying data.
• Integrate and execute tests within CI/CD pipelines (e.g. Azure DevOps).
• Conduct data analysis and data lineage
• Identify patterns in recurring bugs to drive long-term solutions.
• Collaborate closely with product managers, developers and analysts to ensure requirements are met.
• Support internal controls, audits, and regulatory reviews through detailed documentation and validation.
• Use DBT to perform testing.

Skills

QA Leadership

Data testing

SQL proficiency

Data validation

Testing methodologies

Root cause analysis

Agile practices

Investments domain knowledge

Python for adhoc testing

Tools

Azure DevOps

Jira

Snowflake

DBT

Python

Job description

Ledgent Technology is seeking an Investments QA Lead (Techno/Functional) III to oversee testing of an investments data warehouse. You will lead functional, integration, regression and UAT testing, perform SQL-based validation, and ensure data accuracy against Power BI reports.

You will collaborate with product managers, developers and analysts, drive defect root cause analysis, and support compliance through detailed documentation in a remote US-based role.