Note: The job is a remote job and is open to candidates in USA. Octave provides mission-critical software that transforms complex operational data into actionable intelligence across the asset lifecycle, including its global Public Safety software portfolio. The Senior Quality Assurance Engineer will own quality for data pipelines, reporting platforms, dashboards, and analytics services by designing and executing tests, validating data with SQL, investigating discrepancies, and managing defects 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
Skills
- 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
- 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
Benefits
- Fully remote opportunity for the right candidate.
- A supportive work environment providing employees with the resources they need to support their ambitions.
- An inclusive workplace committed to equal opportunities, an inclusive environment, and fairness for all.
Company Overview
Company H1B Sponsorship