Data Quality Assurance and Privacy Testing Lead (Ref: 5747)

Position Summary

The Data Quality Assurance and Privacy Testing Lead will validate the accuracy, security, privacy, and regulatory compliance of education data integrations, reporting datasets, and dashboards. This role will ensure that student and school data is appropriately masked, aggregated, anonymized, and separated before being released through public-facing reports or dashboards.

Key Responsibilities

• Develop and execute data quality, privacy, and compliance test plans.

• Validate compliance with FERPA, COPPA, New York Education Law 2-d, and applicable Data Privacy Agreements.

• Test aggregation and anonymization rules applied to student, school, and district data.

• Verify that required N-size suppression rules are correctly applied to public reports and dashboards.

• Validate data masking and de-identification of personally identifiable information and other sensitive data.

• Confirm that public-facing datasets contain only approved, aggregated, and anonymized information.

• Test the separation of public-facing data from internal, detailed, or raw source data.

• Identify data-quality, privacy, security, and reporting defects and document expected corrective actions.

• Perform regression testing after data pipeline, transformation, suppression, or dashboard changes.

• Maintain test cases, test evidence, defect logs, traceability documentation, and validation results.

• Work with data engineers, integration leads, business analysts, reporting developers, and privacy stakeholders to resolve defects.

• Support final acceptance testing and approval of datasets intended for public reporting.

Required Qualifications

• Experience testing data integrations, reporting datasets, dashboards, or data warehouse environments.

• Experience validating FERPA, COPPA, New York Education Law 2-d, or comparable education data privacy requirements.

• Experience validating compliance with Data Privacy Agreements.

• Hands-on experience testing data aggregation, anonymization, masking, and de-identification.

• Experience validating N-size suppression or similar small-group disclosure protections.

• Experience verifying dashboard data accuracy and reconciling results to source systems.

• Experience testing the separation of public-facing data from internal, restricted, or raw data.

• Strong knowledge of data-quality testing, reconciliation, validation, and defect management.

• Strong technical documentation and communication skills.

Preferred Qualifications

• Experience working with K–12 school districts, education agencies, or student information systems.

• Experience testing PowerSchool, Oracle, education data warehouses, or public reporting platforms.

• Knowledge of personally identifiable information, student-data privacy, role-based access controls, and secure data-handling practices.

• Experience with SQL, ETL/ELT testing, API testing, SFTP data feeds, and automated data pipelines.

• Familiarity with Ed-Fi, OneRoster, or similar education data standards.

About Estrada Consulting Incorporated

Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.