We are seeking a Senior Data QA Analyst to support the migration of pricing and analytics data from legacy SAS processes to a Databricks and dbt platform. The role will focus on testing data sourced from a modern Insurance Platform and a legacy system, validating transformations, and ensuring downstream datasets are complete, accurate and fit for use.
You will work closely with data engineers, pricing analysts, business SMEs and delivery teams to identify defects, explain data differences and provide clear evidence for release decisions.
Apply Now >
Key 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.
Essential skills and experience:
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.
Experience with General Insurance data testing and/or migration from a legacy policy administration system.
Hands-on exposure to dbt, PySpark or Python for test automation and reconciliation.
Experience testing SAS-to-cloud migrations.
Familiarity with Git-based delivery, CI/CD and defect tracking tools.
Experience validating data consumed by pricing, actuarial or analytics teams.
What success looks like: You can take a business rule or source-to-target mapping, turn it into effective data tests, investigate a failed result to record level, and clearly explain whether the difference is a defect, a source-system variation or an agreed transformation. Your testing gives the team confidence to release Duck Creek and Protect data for pricing and analytics use.
Job Description Data Analyst - QA Key Responsibilities Analyse, interpret, and validate complex datasets to identify trends, patterns, and business insights. Develop, maintain, and enhance reports, dashboards, and performance metrics to support decision-making. Gather, document, and translate business and reporting requirements ...
Job Description Softtest pays pty ltd in Brisbane is seeking a diligent Test Analyst at APS5 level to validate designs and behaviours of ICT systems. You will perform testing across platforms, develop test artefacts, and report findings to senior staff. You will apply ISTQB Foundation Level expertise, follow guidelines, ...
Job Description Ignite in Sydney is seeking experienced Test Lead and Test Analyst to join a large-scale transformation program delivering critical technology and business outcomes. The roles involve testing across complex data platforms, integrations, and digital solutions, ensuring quality throughout the project lifecycle. ...
... focus on outcomes with efficiency in the way that we disrupt financial crime. Quality Assurance footprint spans Australia and India. DO WORK THAT MATTERS As a QA Senior Analyst, you will ensure the accuracy and completeness of Financial Crime cases, adhering to regulatory standards. Acting as a subject matter expert, you ...
... where the capability of our people is key to our success. Come and be a part of this success. About The Role The Geophysics and Geochemistry Team is seeking a Data Analyst to join our Geochemistry QA/QC and Data Processing team. This role offers the opportunity to work within a specialist technical group responsible for ...
... ecosystem - Lead functional, integration, regression and UAT testing - 12-Month Max-Term Contract – Melbourne | Hybrid We’re looking for an experienced Test Analyst to join our Quality Assurance team on a 12-month maximum-term contract . Reporting to the QA Lead , you’ll own testing activities end-to-end across a range ...
Job Description Consumer Affairs Victoria, Melbourne, seeks a Senior Analyst in the Intelligence branch to lead data and information analysis tasks, producing high-quality intelligence outputs to support Victoria's regulatory functions. You will identify threats, opportunities, patterns and trends, and collaborate with ...
... standards, client data remediation and regulatory reporting change. You'll be part of a collaborative Delivery team working alongside Compliance, Risk, Operations, Data and Technology About The Role As a Business Analyst, you'll sit at the centre of this program, turning regulatory obligations and complex client data into clear ...
Job details - The Quality Assurance Section of the Data & Service Delivery Governance Branch within DFAT’s Information Management and Technology Division, has a requirement for up to ( 4x ) labour-hire resources to fill the role of Senior Test Analyst(s) , one Test Lead and one Automation Test Analyst to work with existing ...
... infrastructure, environmental approvals, ecology, earth science or environmental science - Support the use and improvement of enterprise GIS platforms and spatial databases - Assist with field data capture tools, including mobile data collection and data QA - Provide day-to-day GIS support to project teams, including troubleshooting ...