
Senior Data Quality Engineer - Zonda - Irvine, CA
CoStar Group1 day ago
Irvine, CA, USASenior
Base Salary
$110k - $148k/yr
Responsibilities
- Design and execute testing strategies for ETL/ELT pipelines, transformations, integrations, and published data products.
- Validate data from source ingestion through transformation and final output, including completeness, accuracy, mappings, calculations, aggregations, joins, filters, and business rules.
- Build automated validation frameworks and reusable regression coverage for freshness, volume, completeness, uniqueness, validity, referential integrity, reconciliation, distributions, and drift.
- Create and maintain curated test datasets and expected results covering common scenarios, edge cases, historical conditions, and known failure modes.
- Translate business definitions, methodologies, acceptance criteria, and expected outcomes into executable test scenarios with business and domain experts.
- Integrate quality checks into CI/CD, dbt, Airflow/MWAA, and release workflows, including controls that can prevent downstream publication when thresholds are not met.
- Independently validate material or high-risk data releases and provide quality evidence, risk findings, and release-readiness recommendations.
- Establish monitoring and actionable alerts through Grafana, CloudWatch, DataHub, or related capabilities, and perform post-release validation.
- Investigate quality failures with Data Engineers and convert recurring defects into automated regression tests or preventative controls.
- Define data-testing standards and mentor engineering teams on reconciliation, test-data design, regression testing, and data-quality practices.
Requirements
- At least 6 years of experience in Data Quality Engineering, Data Testing, Quality Engineering, Data Engineering, or a related discipline, including significant production data-system testing.
- Strong hands-on experience with ETL/ELT and end-to-end data pipeline testing, source-to-target reconciliation, regression testing, and large-dataset validation.
- Advanced SQL skills for data analysis, reconciliation, comparison, and validation.
- Strong scripting or test-automation skills, preferably with Python, and experience designing automated data-testing or data-quality frameworks.
- Experience creating test cases, expected results, and curated test datasets for complex data scenarios.
- Experience validating data in modern cloud data platforms; Snowflake experience is preferred.
- Experience testing pipelines built with dbt, Apache Airflow, AWS Glue, or comparable ETL/ELT frameworks.
- Strong understanding of accuracy, completeness, consistency, uniqueness, validity, freshness, referential integrity, and distribution as data-quality dimensions.
- Experience with defect analysis, release validation, and root-cause investigation.
- Ability to translate complex domain requirements into measurable test scenarios with business subject-matter experts.
- Strong analytical and communication skills for explaining quality findings and risks to technical and business audiences.
- Preferred experience includes dbt testing and custom tests, Amazon MWAA, Apache Airflow, AWS Glue, Amazon S3, DataHub or similar catalog platforms, data profiling, anomaly detection, distribution-based validation, quality scorecards, CI/CD integration, high-volume validation, and complex analytical, economic, financial, or real-estate datasets.
Benefits
- Comprehensive medical, vision, dental, prescription drug, life, legal, and supplementary insurance coverage.
- Virtual and in-person mental health counseling for individuals and families.
- Commuter and parking benefits.
- 401(k) retirement plan with matching contributions.
- Employee stock purchase plan and paid time off.
- Tuition reimbursement, internal training, and professional and academic growth support.
- On-site fitness center or reimbursed fitness center membership costs, depending on location.
- Employee Resource Groups, complimentary beverages, fresh fruit, and healthy snacks.
- Full-time position based in Irvine, California; applicants must currently be eligible to work full-time in the United States.
About CoStar Group
CoStar Group builds subscription databases, analytics, and online marketplaces for commercial and residential real estate professionals, investors, and advertisers. Its portfolio includes CoStar (research and data), LoopNet (commercial listings), and Apartments.com (rental listings), generating revenue from subscriptions, listings, and advertising. The company is publicly traded on NASDAQ (CSGP) and is headquartered in Arlington, Virginia, with inclusion in the S&P 500 index.