SDET II (NextGen)

About Us

insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.

Job Description

insightsoftware

Equity Management Engineering — Job Description

Senior Quality Engineer — Reporting/BI Engineering

Reports To

Principal QA Lead or Sr Engineering Manager — QA & Standards

Location

Remote (India)| Global team

Team

Reporting/BI Engineering — fully embedded

Aboutinsightsoftware

insightsoftwareis a growing, dynamic computer software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. Atinsightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for futureInsighterswho candemonstrateteamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team!

Job Description

As a Senior Quality Engineer embedded in the Reporting/BI Engineering team, you will be the primary quality voice for a scrum team focused on building and enhancing the financial reporting and business intelligence capabilities of theCertentEquity Management (CEM) platform for a large, strategic enterprise client engagement. You will report into the QA & Standards organization while working day-to-day within the Reporting/BI scrum team, collaborating closely with the Lead Engineer, engineers, and product management throughout the delivery lifecycle.

This is not a standard application-layer QA role. The Reporting/BI test surface is dominated by SQL correctness, data accuracy, query performance, and report output fidelity — not UI workflows. You will need to think in terms of data: whether the right rows came back, whether the aggregations are correct, whether hierarchical traversal produces the right results, whether a report output matches the source data at the financial detail level. Writing SQL tovalidatedata is not optional here — it is the primary tool for most of your testing.

The right candidate takes personal ownership of quality outcomes — not justidentifyingproblems, butpartnering with engineering to drive them to resolution. “No bugs made it to production on my watch” is not a goal,it’sa standard. This is a hybrid manual and automation role. SQL-based data validation and API test coverage are the priority automation surfaces; UI automation is secondary. AI will be a core part of how you work across every aspect of quality engineering.

Responsibilities

Quality Ownership & Test Execution

Own the quality of the Reporting/BI team’s deliverables — from requirements review through release — ensuring nothing ships without adequate test coverage across functional, data accuracy, performance, and non-functional scenarios.

Define, document, and execute test plans and test cases for new reporting features, SQL changes, BI enhancements, and bug fixes — covering report output correctness, data transformation accuracy, edge cases, regression, security, and non-functional scenarios.

Identifytest conditions from user stories, reporting specifications, andrequirementsdocuments — including positive, negative, boundary, hierarchical data traversal, aggregation correctness, and null handling scenarios.

Execute test cases, document results, track defects, and own them through to resolution — partnering with engineers and product management to ensure nothing falls through the cracks.Identifyinga problem is the beginning, not the end.

Participate actively in sprint ceremonies — planning, refinement, standups, demos, and retrospectives — as the quality voice of the team.

Collaborate with the Principal QA Lead and Sr Engineering Manager — QA & Standards tomaintainconsistent quality standards across scrum teams.

SQL & Data Accuracy Validation

Write Oracle SQL and PL/SQL queries tovalidatereport output against source data — verifying row counts, field-level accuracy,aggregationcorrectness, financial calculations, and referential integrity. This is the primary testing tool for this team.

Design and execute data accuracy test strategies for complex, non-flattened hierarchical data models —validatingthat reporting queries traverse hierarchies correctly and produceaccurateresults across all nodes and rollup levels.

Validate SQL and PL/SQL changes — stored procedures, packages, views, and query modifications — ensuring correctness, expected performance characteristics, and no unintended side effects on existing report output.

Identifyand document data discrepancies clearly — providing engineers with precise SQL evidence that isolates where in the data pipeline a calculation or transformation is producing incorrect results.

Validate query performance benchmarks as part of definition of done — confirming that new or modified queries meet the team’s performance standards and do not introduce regression in report responsiveness.

Reporting & BI Output Testing

Test end-to-end report output fidelity —validatingthat what is displayed in a report or BI dashboard accurately reflects the underlying data, with correct formatting, correct totals, correct filtering behavior, and correct drill-down results.

Validate Logi Analytics (Logi Symphony) report and dashboard implementations — testing report rendering, parameter handling, data binding, conditional logic, and export output against expected data.

Test report configuration and parameterization — verify