Senior Quality Assurance Engineer

Redwood Trust, Inc.; Denver (CO); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Discretionary corporate bonus program

Multiple health plans

STD and LTD options

Company sponsored life insurance

Fitness reimbursement

Paid parental leave

Time to volunteer

Paid Time off

ESPP

401K matching

Job summary

Redwood Trust, Inc. is seeking a QA Engineer to oversee quality across our enterprise data platform (EDP) reporting and related applications. You will collaborate with developers, data engineers, and stakeholders to ensure data integrity and reliable releases.

You will validate data throughout the lifecycle—from source systems through ETL processes and Microsoft Fabric to Power BI dashboards—using SQL, PySpark, and API testing to ensure accuracy and readiness for production.

Qualifications

• 5+ years of QA experience with a focus on data platforms or enterprise systems.
• Strong SQL skills and ability to validate data across multiple databases.
• Experience with ETL/ELT, data warehousing concepts, and reporting tools.

Responsibilities

• Apply analytical thinking to assess complex data systems and root causes.
• Execute QA for data platforms, ETL processes, reporting solutions, and integrations.
• Perform end-to-end data validation from sources through ETL to reporting apps.
• Validate data across Oracle SQL Developer, MySQL, and MS SQL Server.
• Validate ETL/ELT pipelines and transformations in Microsoft Fabric using SQL and PySpark.
• Review API integrations, JSON/XML data structures, and Power BI reports.
• Design validation strategies for large-scale data processing and integrations.
• Collaborate with developers and data engineers on mortgage KPIs and processes.
• Communicate testing progress and risks to stakeholders; support QA practices.

Skills

SQL

Data platforms

ETL testing

Power BI

API testing

JSON/XML validation

Python

Playwright

Selenium

Microsoft Fabric

Data integrity

Tools

Postman

Playwright

Selenium

SQL Developer

Job description

The QA Engineer is responsible for quality assurance efforts across enterprise data platform (EDP) reporting and application initiatives. This role requires strong analytical thinking to evaluate complex data workflows, ETL processes, integrations, and reporting solutions to ensure high-quality outcomes.

The candidate will work closely with developers, data engineers, and business stakeholders to ensure data integrity, system reliability, and overall product quality. This role is accountable for validating data throughout the entire data lifecycle—from source systems through ETL processes and Microsoft Fabric to reporting applications such as Power BI—while ensuring readiness for production releases. The position requires deep expertise in SQL, data platforms, system integrations, and modern reporting technologies.

Responsibilities

As a QA Engineer, you will:

• Apply advanced analytical thinking and logical reasoning to assess complex data systems, identify root causes, and support solutions
• Execute quality assurance activities for enterprise data platforms, ETL processes, reporting solutions, and system integrations, ensuring data accuracy, consistency, and integrity across systems
• Perform end-to-end data validation from source systems through ETL processes to downstream reporting applications
• Analyze and validate data across multiple database systems, including Oracle SQL Developer, MySQL, and Microsoft SQL Server
• Validate ETL/ELT pipelines, data transformations, and business rules within Microsoft Fabric using SQL and PySpark
• Review and validate API integrations, including request/response structures, status codes, and protocols
• Analyze and validate JSON and XML data structures across systems and integrations
• Validate Power BI reports and dashboards by verifying calculations, filters, drill-through functionality, visualizations, KPIs, security, and user experience
• Design and execute validation strategies for large-scale data processing and integrations
• Collaborate with development teams and data engineers to ensure alignment with mortgage processes and KPIs
• Communicate testing progress, risks, and results clearly to stakeholders and leadership
• Support and guide QA processes, including risk identification and mitigation strategies
• Participate in agile ceremonies and help drive QA best practices across teams
• Manage priorities, timelines, and deliverables in a fast-paced, data-driven environment
• Support and contribute to test automation efforts using tools such as Playwright, Python, and API tools (e.g., Postman)

Characteristics

You are a strong fit for this role if you have:

• 5+ years of experience in Quality Assurance, with strong focus on data platforms or enterprise systems
• Strong analytical and problem-solving skills, with the ability to evaluate complex data and system behaviors
• Strong understanding of enterprise data warehousing concepts, ETL/ELT processes, Microsoft Fabric architecture, and data integration principles
• Advanced SQL skills with experience writing complex queries for data analysis, reconciliation, troubleshooting, and validation across Oracle, SQL Server, MySQL, or similar platforms
• Strong understanding of relational databases, data modeling, joins, indexing, and query optimization concepts
• Experience testing reporting solutions, including Microsoft Power BI, with the ability to validate data accuracy, business logic, calculations, filters, and visualizations
• Strong experience analyzing and validating JSON and XML data formats
• Experience validating APIs using tools such as Postman, including request/response validation, authentication, and status code verification
• Experience with test automation frameworks such as Playwright or Selenium and scripting using Python or similar languages
• Experience leveraging AI-assisted development and testing tools (e.g., ChatGPT, GitHub Copilot, Microsoft Copilot) to improve productivity, test design, troubleshooting, and code generation
• Understanding of mortgage industry processes and key performance indicators (KPIs)
• Excellent communication skills, with the ability to clearly convey technical concepts to diverse stakeholders
• Ability to work effectively in a fast-paced, dynamic environment and manage changing priorities

A reasonable estimate of the total compensation range for this role is $100,000-$120,000. The actual salary offer to the successful candidate will be based on job-related education, geographic location, training, licensure and certification, and other factors.

CoreVest also offers a competitive benefit package including

• discretionary corporate bonus program
• multiple health plans
• STD and LTD options
• company sponsored life insurance
• fitness reimbursement
• paid parental leave
• time to volunteer
• Paid Time off
• ESPP
• 401K matching

At Redwood Trust, we are committed to fostering an inclusive workplace where diversity is valued, and everyone has the opportunity thrive. We welcome applications from individuals of all backgrounds and experiences. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.