Senior Data QA Analyst: Pricing & Analytics Quality

Ingrity Pty; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Ingrity Pty is seeking a Senior Data QA Analyst to drive quality across the migration of pricing and analytics data from legacy SAS processes to Databricks and dbt platforms. You will validate data from modern Insurance Platform and legacy system, design test cases and provide evidence for release decisions.

Collaborating with data engineers, pricing analysts and SMEs, you will run end-to-end testing of ingestion, transformations and downstream datasets, ensuring accuracy and completeness for

Qualifications

• 5+ years in data testing, ETL testing or data quality assurance, including substantial hands‑on testing of complex data transformations.
• Strong SQL skills, including joins, window functions, aggregations and reconciliation queries.
• Experience testing data pipelines and layered data platforms, preferably using Databricks, Delta Lake, Spark or a comparable environment.
• Experience validating source-to-target mappings, business rules, incremental loads and downstream data products.
• Ability to analyse large datasets and distinguish genuine defects from expected differences between systems.
• Experience working with data engineers and business SMEs to clarify requirements and resolve defects.
• Clear written communication and disciplined test evidence, defect reporting and release reporting.

Responsibilities

• Develop and execute test cases for ingestion, transformation and reporting datasets across bronze, silver and gold layers.
• Reconcile modern Insurance Platform and a legacy system data against source systems, transformation rules and expected business outcomes.
• Validate policy, quote, risk and transaction records, including keys, dates, transaction sequences and product or brand mappings.
• Test premiums, exposure, coverage, renewal and pricing attributes, including calculations and aggregation rules.
• Check schema compatibility, data completeness, duplicates, null values, referential integrity, row counts and historical versus incremental loads.
• Investigate discrepancies using SQL, trace records through the pipeline and document the root cause with reproducible evidence.
• Support system integration testing, regression testing, UAT and production release validation.
• Maintain test plans, test data, defect records and concise test completion reports.
• Help develop repeatable data quality checks and automated reconciliation where practical.

Skills

Data testing

ETL testing

Data quality assurance

SQL

Large datasets analysis

Tools

Databricks

Delta Lake

Spark

dbt

Python

PySpark

SAS

Git

CI/CD

Job description

Ingrity Pty is seeking a Senior Data QA Analyst to drive quality across the migration of pricing and analytics data from legacy SAS processes to Databricks and dbt platforms. You will validate data from modern Insurance Platform and legacy system, design test cases and provide evidence for release decisions.

Collaborating with data engineers, pricing analysts and SMEs, you will run end-to-end testing of ingestion, transformations and downstream datasets, ensuring accuracy and completeness for