Senior Quality Assurance Engineer - Data & Analytics

Octave provides mission-critical software that transforms complex operational data into actionable intelligence for organizations across the asset lifecycle. The company is seeking a Senior Quality Assurance Engineer to ensure the accuracy, reliability, and performance of data pipelines, reporting platforms, dashboards, and analytics services. The role involves designing and executing data-focused tests, validating SQL and Power BI outputs, diagnosing discrepancies, and managing quality within an Agile delivery team.

Responsibilities:

• Serve as the embedded quality expert on an Agile/SAFe team delivering analytics and reporting capabilities
• Collaborate with Product Owners, Data Engineers, and Developers to shape user stories, acceptance criteria, data mappings, and validation scenarios
• Design and execute tests for ETL pipelines, data transformations, reports, dashboards, semantic models, and analytics services
• Trace data from source systems through pipelines, database objects, reporting models, and final visualizations
• Use SQL to validate accuracy, completeness, transformations, aggregations, nulls, duplicates, and source-to-target reconciliation
• Test Power BI reports and dashboards, including measures, filters, relationships, drill-through behavior, refreshes, and KPI calculations
• Diagnose whether reporting discrepancies originate in source data, ETL logic, SQL, semantic models, or visual configurations
• Validate pipeline failure handling, reruns, partial loads, performance, and recovery scenarios
• Perform functional, integration, regression, and exploratory testing throughout each sprint
• Document and triage defects with clear reproduction steps, data samples, reconciliation queries, and impact assessments
• Help establish analytics-testing standards, reusable validation practices, and effective test-data strategies
• Maintain test cases, defects, and traceability in Azure DevOps while actively participating in Agile ceremonies

Requirements:

• At least five years of experience in software QA, data QA, or software testing within Agile teams
• Hands-on experience testing ETL pipelines, analytics platforms, reporting systems, or other data-intensive applications
• Strong SQL skills, including joins, aggregations, duplicate detection, source-to-target reconciliation, and validation of views and stored procedures
• Practical experience testing Power BI reports and dashboards—not simply viewing or consuming them
• The ability to trace a reported value from a visualization back through its measure, model, database objects, transformation logic, and source data
• Familiarity with Power BI measures, filter context, relationships, refreshes, and gateways
• A strong understanding of QA methodologies, test design, risk-based testing, and defect management
• Strong investigative, problem-solving, and communication skills
• A proactive, accountable approach and the curiosity to keep expanding your technical skills
• A bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related technical field—or equivalent professional experience
• Participation in an in-person interview and/or completion of mandatory in-person training are required conditions of employment
• Experience in Public Safety, emergency response, or another mission-critical environment is especially valuable
• Experience with Public Safety, emergency response, or other mission-critical systems
• Experience testing SSIS, SSAS, or Azure Data Factory pipelines
• Knowledge of dimensional modeling, fact and dimension tables, slowly changing dimensions, or medallion architectures
• Experience with Power BI semantic models, DAX, row-level security, gateways, or deployment troubleshooting
• Experience building automated tests with Playwright and TypeScript
• Experience with API testing, CI pipelines, or cloud-based data architectures—particularly Microsoft Azure
• Fully remote opportunity for the right candidate