Data Warehouse QA Analyst: Drive Data Integrity & Automation

84 Lumber Company; North Strabane Township (PA); On-site; USD 65,000 - 95,000; Full time

Job summary

84 Lumber Company is seeking a detail-oriented QA Analyst to join the Business Intelligence team in the United States. The role focuses on owning quality assurance across the data warehouse development lifecycle, validating data integrations, transformations, and reporting to ensure data integrity.

You will build reusable test collateral, automate where possible, and assess ripple effects across processes and systems.

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 testing

Root-cause analysis

Communication

Cross-functional collaboration

Education

Bachelor's degree

Tools

MicroStrategy

ETL testing tools

Relational databases

Job description

84 Lumber Company is seeking a detail-oriented QA Analyst to join the Business Intelligence team in the United States. The role focuses on owning quality assurance across the data warehouse development lifecycle, validating data integrations, transformations, and reporting to ensure data integrity.

You will build reusable test collateral, automate where possible, and assess ripple effects across processes and systems.