Data Warehouse QA Engineer — Quality at Scale

84 Lumber; Eighty Four (PA); On-site; USD 75,000 - 95,000; Full time

Job summary

84 Lumber is seeking a detail-oriented QA Analyst to own quality assurance across the data warehouse development lifecycle—partnering with business analysts, subject matter experts, and developers to validate data integrations, transformations, and reporting.

You will build reusable test collateral, automate where possible, and consider ripple effects across processes and systems, ensuring data integrity and reliable BI reporting.

Qualifications

• Bachelor's degree in a related field preferred, plus 3+ years of relevant work experience.
• Experience with data warehouse and BI platforms (Strategy / MicroStrategy a plus).
• Strong SQL skills, with the ability to write advanced queries to test data ETLs and reporting.
• Familiarity with relational databases and the ability to extract data as needed.
• Experience validating data using primary key matching, data hashing, or checksum-based reconciliation techniques.
• Knowledge of software testing processes, methods, and automated tools within a BI environment.
• Track record of owning testing efforts for highly complex projects, from requirements through ongoing support.

Responsibilities

• Participate in requirements meetings, provide estimates, and validate project requirements and technical specifications.
• Review requirements and technical designs with developers and analysts to confirm expected functionality.
• Perform impact analysis, quantify and mitigate risk, and document key issues.
• Communicate project readiness, status, and risks to the team, escalating as appropriate.
• Develop test strategy and manage testing efforts across functional, data validation, regression, system integration, and user acceptance testing.
• Determine test environment and test data requirements, coordinating with developers as needed.
• Write and execute test cases, map them to requirements, and lead peer reviews of test results.
• Track defects and issues through resolution using formal project management methodology.
• Proactively identify and implement automated testing solutions.
• Develop a strategy for continuous data quality monitoring, including trending reports and quality metrics.
• Evaluate data changes and anomalies against historical trends and benchmarks, guide resolution of variances.
• Troubleshoot job failures alongside developers and provide metrics reporting on test execution and defects.
• Build reusable, automated testing and reporting processes.

Skills

SQL

Data warehouse

BI platforms

MicroStrategy

Education

Bachelor's degree

Job description

84 Lumber is seeking a detail-oriented QA Analyst to own quality assurance across the data warehouse development lifecycle—partnering with business analysts, subject matter experts, and developers to validate data integrations, transformations, and reporting.

You will build reusable test collateral, automate where possible, and consider ripple effects across processes and systems, ensuring data integrity and reliable BI reporting.