Senior Quality Assurance Engineer - Data & Analytics

Octave; Town of Texas (WI); On-site; USD 110,000 - 160,000; Full time

Job summary

Octave is seeking a Senior Quality Assurance Engineer focused on data and analytics to ensure the accuracy, reliability, and performance of analytics across our portfolio.

You will embed with an Agile team, owning quality across data pipelines, reporting platforms, dashboards, and analytics services, collaborating with Developers, Data Engineers, Product Owners, and Scrum Masters to uncover risks early and ensure trusted operational data.

Qualifications

• 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.

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

SQL

Power BI

QA methodologies

Data QA

Analytical thinking

Communication skills

Agile/SAFe

Test design

Data validation

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

SSIS

SSAS

Azure Data Factory

Azure DevOps

Job description

Is testing data your jam?

Do mismatched totals bother you until you find the exact transformation, relationship, or filter that caused them? Do you enjoy tracing data from a source table through an ETL pipeline, stored procedure, semantic model, and Power BI dashboard? Can you spot the difference between bad source data, faulty SQL, and a broken report?

If so, this may be your kind of role.

Octave is looking for a Senior Quality Assurance Engineer who knows that a polished dashboard is only as trustworthy as the data behind it. You’ll help ensure the accuracy, reliability, and performance of analytics used across our global Public Safety software portfolio, including the HxGN OnCall application suite.

Embedded within an Agile delivery team, you’ll own quality across data pipelines, reporting platforms, dashboards, and analytics services. You’ll work alongside Developers, Data Engineers, Product Owners, and Scrum Masters to uncover risks early and ensure operational data can be trusted when it matters most.

Experience in Public Safety, emergency response, or another mission-critical environment is especially valuable.

What you’ll do

• 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.

Education / Qualifications

• 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.

Even better if you have

• 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.

Education

• A bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related technical field—or equivalent professional experience.

Location and interview requirements

• Fully remote opportunity for the right candidate.


• Participation in an in-person interview and/or completion of mandatory in-person training are required conditions of employment.

LI-Remote

#SIG2026

About Octave

Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle - Design, Build, Operate and Protect - where performance, safety, and reliability are non-negotiable and failure is not an option.

Turning complex operational data into actionable intelligence, Octave connects expertise, real-world conditions and enterprise-scale insight to improve performance, resilience and incident response where it matters most.

Octave has more than 7,000 employees in 45 countries. Learn more at octave.com and follow us on LinkedIn.

Why work for Octave?

All in. Always forward. That's the way we do things around here. We put trust in our people because we believe it's the best way to unleash potential, bring ideas to life, and keep moving ahead. And it's why we're committed to creating an environment that's truly supportive, providing you with the resources you need to support your ambitions, no matter who you are or where you are in the world.

Everyone is welcome

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don't discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all.

Respect is the cornerstone of how we operate, so speak up and be yourself. You're valued here.

Senior Quality Assurance Engineer - Data & Analytics

Job Location (Short): Houston, Texas-USA | Madison, Alabama-USA

Workplace Type: Remote

About Octave

Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle - Design, Build, Operate and Protect - where performance, safety, and reliability are non-negotiable and failure is not an option.

Turning complex operational data into actionable intelligence, Octave connects expertise, real-world conditions and enterprise-scale insight to improve performance, resilience and incident response where it matters most.

Octave has more than 7,000 employees in 45 countries. Learn more at octave.com and follow us on LinkedIn.

Why work for Octave?

All in. Always forward. That's the way we do things around here. We put trust in our people because we believe it's the best way to unleash potential, bring ideas to life, and keep moving ahead. And it's why we're committed to creating an environment that's truly supportive, providing you with the resources you need to support your ambitions, no matter who you are or where you are in the world.

Everyone is welcome

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don't discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all.

Respect is the cornerstone of how we operate, so speak up and be yourself. You're valued here.