Senior Quality Assurance Engineer - Data & Analytics

Geomatik; Houston (TX); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Fully remote

Job summary

Octave is seeking a Senior Quality Assurance Engineer for Data & Analytics to ensure the accuracy, reliability, and performance of analytics across our global Public Safety software portfolio, including the HxGN OnCall suite. You will audit data pipelines, validate reports, and partner with engineers and data teams in an Agile setting.

Fully remote opportunity with collaboration across time zones. Ideal candidates have 5+ years in QA for data-intensive apps, strong SQL, Power BI, and experience

Qualifications

• At least five years of experience in software QA, data QA, or software testing within Agile teams.
• Experience testing ETL pipelines, analytics platforms, or data‑intensive applications.
• Strong SQL skills, including joins, aggregations, duplicates, source‑to‑target reconciliation.
• Practical experience testing Power BI reports and dashboards.
• 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, refresh, and gateways.
• Strong QA methodologies, test design, risk‑based testing, and defect management.
• Excellent investigative, problem‑solving, and communication skills.

Responsibilities

• Serve as embedded QA 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

QA testing

ETL testing

SQL queries

Power BI

Data quality

Agile / SAFe

Problem solving

Education

Bachelor's degree or equivalent in CS/IS/Data Analytics

Tools

SSIS

SSAS

Azure Data Factory

Azure DevOps

Job description

Senior Quality Assurance Engineer - Data & Analytics

Job Location (Short): Houston, Texas-USA | Madison, Alabama-USA
Workplace Type: Remote
Req Id: 2762

Responsibilities

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.

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.

Recruitment Fraud Alert

Octave posts all official job opportunities on either https://careers.octave.com/ or https://www.octave.com/about/careers and communicates only from email addresses ending [e-mail]. We never request payment or personal banking information during recruitment. No offers will ever be extended without a proper interview via Teams or in person, never done over email alone. If you suspect fraud, it probably is, and contact us at [e-mail]