Quality Assurance

Validate consumer identity, profile, behavioral, and transactional data across all layers of the data platform, from source systems through curated analytics datasets. 

Perform end-to-end dataset comparisons to ensure consumer-level records, counts, and attributes remain consistent as data moves through ingestion and transformation layers. 

Reconcile consumer metrics and KPIs displayed in Tableau and ThoughtSpot dashboards against upstream source and warehouse tables. 

Test ETL/ELT pipelines that ingest and transform consumer data, including events, purchases, interactions, and engagement signals. 

Validate business logic related to consumer attribution, segmentation, and aggregation rules used in analytics. 

Conduct row-level, aggregate-level, and trend-based testing to identify issues such as duplication, data loss, mis-joins, or incorrect consumer rollups. 

Partner with data engineers and analytics teams to investigate and resolve consumer data quality issues. 

Create reusable test plans, validation checklists, and reconciliation queries for consumer analytics datasets. 

Document test cases, validation results, and QA approvals for consumer data releases. 

Participate in Agile ceremonies, including sprint planning, backlog refinement, and retrospectives. 

Contribute to the continuous improvement of consumer data QA standards, validation frameworks, and automation coverage.