Sr. QA Analyst

Job Title: Senior Quality Assurance Analyst

About the Role:

Botsford Associates is seeking a Senior QA Analyst to support the Cyber Data Operations team.. This role is responsible for ensuring the quality, accuracy, and reliability of CyberDW data pipelines and Cyber Data Dashboards through robust testing practices.

The ideal candidate will take a hands-on approach to designing and executing test cases, validating large and complex datasets, identifying and tracking defects, and maintaining comprehensive regression test plans. This position is critical to delivering trusted data products by ensuring functional accuracy, data integrity, and adherence to requirements across systems.

Rate: $60-62/hr

Key Responsibilities

• Design, develop, and execute detailed test plans, test cases, and test scripts based on business and technical requirements
• Perform manual and automated testing across functional, regression, integration, and UAT phases
• Validate data accuracy, completeness, and consistency across CyberDW and Cyber Data Dashboards
• Analyze and scrub large datasets using SQL and Python-based tools to identify anomalies, defects, and data quality issues
• Document, track, and manage defects using JIRA; collaborate closely with development teams through resolution
• Maintain requirement traceability and QA documentation; contribute to regression test plans, cases, and scripts
• Participate in Agile/Scrum ceremonies, providing feedback on system stability, usability, and data reliability
• Test and validate data integrations and services using APIs, including detailed verification with Postman
• Manage QA artifacts, documentation, and deliverables across projects
• Contribute to continuous improvement of QA processes, tools, and testing strategies

Required Qualifications (Non-Negotiable)

Candidates must have strong, hands-on experience with:

• SQL – advanced querying, joins, CTEs, and large dataset validation
• Python – data analysis and test validation scripting
• Pandas – data manipulation and quality analysis
• PySpark & SparkSQL – large-scale data validation and transformation testing
• APIs (RESTful services) – validating data flows and integrations
• Postman – API testing, payload validation, and troubleshooting

Additional Required Experience

• 7–10 years of experience in software testing, QA, or business systems analysis
• Strong background in data-centric QA (financial services or banking experience preferred)
• Hands-on experience with test management and defect tracking tools (e.g., JIRA; Confluence is a plus)
• Solid understanding of SDLC and Agile/Scrum methodologies
• Exceptional attention to detail with strong analytical and problem-solving skills
• Strong written and verbal communication skills, with the ability to document complex testing scenarios

While we thank all interested applicants in advance, we will only contact those selected for an interview. All interviewed candidates will be notified of the hiring decision within 45 days of their interview. Artificial intelligence may be used during the initial resume screening process to identify qualified candidates. This posting is for a current, open contract position supporting one of our financial services clients. Your personal data is collected solely for recruitment purposes in compliance with applicable privacy laws.