Requisition Number: 8441 ANLQAS 004
Job Title: Quality Assurance Analyst- Data Warehouse
City: Eighty Four
State: PA
Salary Range: N/A

Return to list of 84 Lumber Career Opportunities

Quality Assurance Analyst- Data Warehouse

Apply Now

Description/Job Summary


The QA Analyst is responsible for performing quality assurance duties throughout the data warehouse development life cycle. This position will work closely with our project team: business analysts, subject matter experts, store/manufacturing field leaders, managers, and developers to assist in analysis of data integration and data transformation as well as defined and ad-hoc company reports. They will be a champion of our data and reports, helping to identify and resolve any data discrepancies within the data warehouse or reporting for the company. This position demonstrates and promotes innovation, and proactively seeks out automated solutions to business problems. They should create and built upon reusable test collateral on the knowledge foundation of the reporting solution. They should consult with data/business owners and teammates to identify all facets of an issue to help generate a solution as well as understand the potential impacts to processes and systems across the organization to create test scenarios.


Essential Functions

  • Participate in discovery meetings, provide estimates, analyze and validate project requirements and technical specifications, perform impact analysis and document key issues.
  • Review requirements and technical design documents with developers / analysts to confirm expected functionality and business needs. 
  • Drive BI testing including Functional Testing, Data Validation, Regression Testing, System Integration Testing, Automated Testing and User Acceptance Testing.
  • Determine test environment and test data requirements, often in concert with integrated systems owners.
  • Develop the test strategy and manage the testing effort. 
  • Responsible for writing and executing test cases, mapping test cases to requirements, documentation and tracking defects and issues.
  • Resolve issues found in testing and develop benchmarks for testing data and provide metrics reporting on test execution and defects. 
  • Troubleshoot job failures with developers, where necessary.
  • Evaluate data changes and anomalies against previous tends and benchmarks. Provide guidance to resolve variances. Develop strategy for continuous monitoring of data quality.
  • Communicate with Team regarding project readiness, status and potential risks. Document, quantify, and elevate risks as appropriate. 
  • Development of BI and automated and re-usable reporting testing processes. 
  • Develop trending reports and data quality metrics for reporting.

Required Experience

  • 1-3 years of experience in QA or similar technical role. 
  • Knowledge of relational databases with the ability to extract data as necessary.  
  • Knowledge of Software testing processes and automated tools, with an ability to apply software testing methods and techniques in a business intelligence environment. 
  • Ability to deliver assigned work tasks within project timelines. 
  • Able to communicate technical concepts to non-technical people in both written and verbal communication. 
  • Able to speak with business customers to understand and define a problem.
  • Able to use problem solving skills to indentify alternative solutions and approaches to a problem along with costs and benefits of each (tangible or intangible)
  • Able to learn new busniness concepts quickly.
  • Able to estimate task completion time with reasonable accuracy.
  • Effectivly work in a collaborative environment across functional teams.

Preferred Experience

  • Experience in writing advanced SQL statements in order to test data loads and reporting.
  • Past ownership in the development of test planning and execution in a project setting.
  • Experience with QA automation tools.
  • Experience developing and documenting software use cases, testing and reporting results.

Preferred Education

Bachelor’s degree in related field is preferred along with 3 years of relevant work experience. Data Warehouse/Business Intelligence (MicroStrategy) is a Plus.


Supervisory Responsibility 
This position currently has no supervisory responsibility. 

84 Lumber reserves the right to assign or reassign duties and responsibilities to this job at any time.  
Apply Now

84 Lumber Company is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, national origin, disability, or protected veteran status.