Data Warehouse QA Specialist: Automate & Ensure Data Integrity

84 Lumber Company; North Bethlehem Township (PA); On-site; USD 90,000 - 120,000; Full time

Job summary

84 Lumber Company is seeking a detail-oriented QA Analyst to join our Business Intelligence team. You’ll own quality assurance across the data warehouse development lifecycle, validating data integrations, transformations, and reporting, ensuring data integrity and identifying discrepancies before reaching the business.

You’ll build reusable test collateral, automate where possible, and consider ripple effects across processes and systems to prevent issues in production.

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 across functional, data validation, regression, system integration, and user acceptance testing.
• Determine test environment and 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 skills

Data quality monitoring

Analytical thinking

Communication

Education

Bachelor's degree in a related field

Tools

SQL

Relational databases

BI tools (MicroStrategy)

Job description

84 Lumber Company is seeking a detail-oriented QA Analyst to join our Business Intelligence team. You’ll own quality assurance across the data warehouse development lifecycle, validating data integrations, transformations, and reporting, ensuring data integrity and identifying discrepancies before reaching the business.

You’ll build reusable test collateral, automate where possible, and consider ripple effects across processes and systems to prevent issues in production.