3 days old

Quality Assurance Analyst- Data Warehouse

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

Quality Assurance Analyst- Data Warehouse

Description/Job Summary

Summary/Objective 

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.

Responsibilities/Duties

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

Competencies 
  • 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.

Details

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.  
Posted: 2019-10-10 Expires: 2019-11-10

84 Lumber cares about the financial future of you and your family. We also want to reward you for your loyalty to our team. We are dedicated to providing our Associates with the opportunity to enjoy a lucrative retirement from our company!

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Quality Assurance Analyst- Data Warehouse

84 Lumber
Eighty Four, PA 15330

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast