• Guide framework decisions: Choose and standardize testing tools (RSpec over Minitest, Jest over Mocha) and lead architectural adoption across the platform • Build enablement infrastructure: Design factory patterns, data seeds, and service stubs enabling sophisticated testing in inner development loops without full integration • Define quality standards together: Establish coverage thresholds, test suite structures for product types, and boundary metrics giving teams clear targets • Optimize delivery pipelines: Integrate quality gates into CI/CD, balance performance and reliability, and analyze data to eliminate shipping bottlenecks • Mentor and share best practices: Collaborate with teams on avoiding flaky tests, designing testable code, and building robust automated coverage • Enable data-informed improvements: Analyze quality metrics (flaky tests, incidents, DORA) to identify systemic issues and facilitate process improvements

• Validate end-to-end data pipelines from source systems to data marts. • Test batch data loads. • Validate transformations, aggregations, and derived metrics. • Ensure data completeness, accuracy, and consistency across layers. • Understanding of data governance, privacy, and PII handling • Write complex SQL queries to validate fact and dimension tables in Redshift. • Validate data models (fact/dimension, keys, relationships) • Perform reconciliation between raw, curated, and reporting layers. • Validate business KPIs and metrics against source systems and definitions. • Validate data ingestion in S3 (file counts, schema, partitions, formats) • Review Glue job and Lambda execution logs to troubleshoot data issues. • Monitor pipeline health, failures, and data refresh SLAs.

**Description:** - Prepare and execute test plans and testing strategies. - Perform functional, integration, and user acceptance testing. - Design and implement automation testing. - Document and track defects and follow up on their resolution with development teams. - Work on highly complex systems and applications. - Improve quality processes and test automation. - Contribute to improving release quality

• Assess performance of internal, client or vendor case files or records • Identify trends and areas of opportunity for increased service efficiency and quality • Work in partnership with stakeholders to ensure all required and relevant data elements are accurately captured • Compile audit results and submit to manager for review • Provide audit results for quarterly stewardship reports • Monitor ongoing action items logs and project plans with appropriate stakeholders • Update vendor resources to mapping program