Data QA Analyst
Core
Senior Data QA Analyst supporting migration of pricing and analytics data from legacy SAS processes to a Databricks and dbt platform, ensuring downstream datasets are complete, accurate, and fit for use.
Role type
Senior IC data quality assurance engineer (data migration)
Builds
Validated pricing, analytics, and risk data pipelines for an Insurance Platform
Domain
Insurance / Data Engineering / Data Quality
Deliverable
production ML models
Required skills
SQL (joins, window functions, aggregations), data pipeline testing, layered data platform testing (Databricks, Delta Lake, Spark), source-to-target mapping validation, discrepancy investigation, test case development, regression testing, defect documentation
Preferred skills
Insurance domain knowledge (policy, quote, risk, coverage, renewal, premium), SAS-to-cloud migration experience, dbt, PySpark, Python, Git-based delivery, CI/CD, defect tracking tools
Technologies
Databricks, Delta Lake, Spark, dbt, Python, PySpark, SQL, SAS
Responsibilities
Develop and execute test cases for ingestion, transformation, and reporting datasets; Reconcile modern Insurance Platform and legacy system data against source systems and business outcomes; Validate policy, quote, risk, and transaction records including keys, dates, and mappings; Test premiums, exposure, coverage, renewal, and pricing attributes; Check schema compatibility, data completeness, duplicates, null values, and referential integrity; Investigate discrepancies using SQL and document root cause; Support system integration testing, regression testing, UAT, and production release validation; Maintain test plans, test data, defect records, and test completion reports; Help develop repeatable data quality checks and automated reconciliation
Seniority
Senior, hands-on IC