Talent.com
84 Lumber
Data Warehouse QA Analyst84 Lumber • Eighty Four, Pennsylvania
Data Warehouse QA Analyst

Data Warehouse QA Analyst

84 Lumber • Eighty Four, Pennsylvania
30+ days ago
Job type
  • Full-time
Job description

Overview



84 Lumber is looking for a detail-oriented, curious QA Analyst to join our Business Intelligence team. In this role, you'll 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'll be a champion for data integrity, spotting and resolving discrepancies before they reach the business.

We're looking for someone who builds reusable test collateral, automates wherever possible, and thinks beyond the immediate issue to understand its ripple effects across processes and systems.


Responsibilities

New Development Support

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

Testing Strategy & Execution

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

Ongoing Data Quality & Monitoring

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


Qualifications

Experience & Education

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

Skills & Attributes

  • Strong root-cause analysis skills and sound judgment when assessing impact.
  • A track record of driving projects to completion and owning outcomes, including tough issues.
  • Clear, professional communicator — able to translate technical concepts for non-technical audiences.
  • Collaborative team player who works effectively across functional groups.
Create a job alert for this search

Data Warehouse QA Analyst • Eighty Four, Pennsylvania

Similar jobs

Healthcare Business Analyst - FHIR / HL7 Interoperability

Veterans Sourcing GroupPittsburgh, PA, United States
Full-time

Healthcare Business Analyst - FHIR / HL7 Interoperability Remote.The Business Analyst will play a critical role in enabling end to end interoperability solutions within the CMS ONC ecosystem.This p... Show more

 • Promoted

Business System Analyst

Jconnect Infotech IncPittsburgh, PA, United States
Full-time

Business Analysis & Requirements Management.Elicit, analyze, validate, and document business requirements from stakeholders.Create and maintain comprehensive Business Requirement Documents (BRDs) a... Show more

 • Promoted

Associate, Data Transfer, Integration & Quality Representative I- Evening Shift

Bank Of New York MellonPittsburgh, PA, United States
Full-time

Data Transfer, Integration & Quality Evening Shift 12 Noon - 8:30 PMAt BNY, our culture allows us to run our company better and enables employees' growth and success.As a leading global financi... Show more

 • Promoted

Entry Level Sales Operations AND Analytics Opportunity

Year Up UnitedShaler Township, PA, US
Full-time

Year Up United is a one-year or less, intensive job training program that provides young adults with in-classroom skill development, access to internships and job placement services, and personaliz... Show more

 • Promoted

Data Verification Analyst

CorVelPittsburgh, PA, United States
Full-time

The Data Verification Analyst is responsible for all bill review clerical functions, including mail, prepping and scanning medical bills, data entry, data verification and assisting with various ph... Show more

 • Promoted

Data Analyst - Entry/Junior

SynergisticITPittsburgh, PA, United States
Full-time

Synergisticit Job Opportunities.Since 2010 Synergisticit has helped jobseekers get employed in the tech job market by providing candidates the requisite skills, experience, and technical competence... Show more

 • Promoted

Business Analyst Senior - Data, Modeling & Analytics

PNCPittsburgh, PA, United States
Full-time +1

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve.We are all united in delivering the best experience for our customers.We work together each day ... Show more

 • Promoted

Data Analyst(Remote)

SynergisticITPittsburgh, PA, United States
Remote
Full-time

Job Opportunity at SynergisticIT.SynergisticIT is aware that the job market is challenging due to almost 300,000 tech layoffs within the past year.The job market is flooded with thousands of laid o... Show more

 • Promoted

Business Analyst

Computer Enterprises, Inc. (CEI)Pittsburgh, PA, United States
Full-time

CEI is a nationally recognized CMMI level 5 IT services company providing consulting, cutting edge technology project services and outsourcing to clients across the United States, including over 60... Show more

 • Promoted

Pricing Analyst III

Thermo FisherPittsburgh, PA, United States
Full-time

Schedule: Office (Onsite 3-4 days / week).This role supports RSD North America in the Customer Channel Group, serving lab customer end users through the Fisher Scientific distribution channel.Are y... Show more

 • Promoted

Business Analyst

Yantran LLCPittsburgh, PA, United States
Full-time

Location: Pittsburgh, Pennsylvania, USA Years of Experience: 5 -7 Years.Participates in developing functional requirements for business systems; tests, trains and implements applications Translates... Show more

 • Promoted

Workday Tier 2 Support Analyst

ClifyXPittsburgh, PA, United States
Temporary

Workday Tier 2 Support Analyst/HcmLocation:Pittsburgh Pa Job Type:12+months Contract Visa Type Citizen/ Green Card/ H1bRole Scope / Deliverables:The qualified applicant will become part of Thermo F... Show more

 • Promoted

Business Analyst AML

ClifyXPittsburgh, PA, United States
Full-time

We are looking for a business analyst with AML (Anti Money Laundering) experience. Show more

 • Promoted

Data Governance Lead

Inizio PartnersPittsburgh, PA, United States
Full-time

Dallas, Texas, United States Or refer someone Job Openings Data Governance Lead.Data Governance Lead (Collibra OR Alation).Hybrid (3 days onsite, 2 days work from Home).Pittsburgh / Cleveland / Dal... Show more

 • Promoted

Senior Pricing Analyst

PGW Auto GlassCranberry Twp, PA, United States
Full-time

Senior Pricing AnalystPGW Auto Glass is seeking a strategic thinker with a passion for data-driven decision-making for our team.As a Pricing Analyst, you will conduct comprehensive analyses to supp... Show more

 • Promoted

Business Analyst- Pittsburgh, PA

Georgia IT, Inc.Pittsburgh, PA, United States
Full-time

Location: Pittsburgh, PA Rate: DOE $/Yr.Position Type: Full Time Interview Process: Phone Followed by F2F.US Citizen, Green Card and GC EAD.Job Description: Exposure to Basel 2, Basel 3, Risk and R... Show more

 • Promoted

Analyst

Pacer GroupPittsburgh, PA, United States
Full-time

Nippon Project Analyst / Coordinator.As part of Nippon project strategic process undertaking.Along those projects there will be IT components.Delivering infra, cyber components etc.Looking for Ana... Show more

 • Promoted

Business Analyst- Pittsburgh, PA

StaffingPittsburgh, PA, United States
Full-time

Location: Pittsburgh, PA Rate: DOE $/Yr.Position Type: Full Time Interview Process: Phone Followed by F2F.US Citizen, Green Card and GC EAD.Job Description: Exposure to Basel 2, Basel 3, Risk and R... Show more

 • Promoted

Project Analyst 4

KCI TechnologiesPittsburgh, PA, United States
Full-time

Join us as we Rise to the Challenge.At KCI, we're building an enduring community that provides unparalleled value to our employee-owners.We make our mark designing and delivering our world-class so... Show more

 • Promoted

Operational Excellence Analyst

Penske Truck LeasingPittsburgh, PA, United States
Full-time

Operational Excellence Analyst.The Operational Excellence Analyst is primarily responsible for completing tasks directly or indirectly supporting key initiatives within the Operational Excellence d... Show more