DC Public Charter School Board (DC PCSB) is seeking a Data Engineer for its Analytics Products team. This role designs, builds, and maintains data pipelines, data warehouse models, orchestration workflows, and Data Mart structures that allow staff, school leaders, and public stakeholders to access reliable, governed data for reporting, accountability calculations, Enterprise Intelligence, and public analytics products. The Data Engineer combines traditional data engineering skills—pipelines, orchestration, warehousing, and cloud infrastructure—with close collaboration with Analytics Engineers, Product Managers, and agency program teams. The goal is scalable, auditable, and maintainable data architecture that complies with DC PCSB’s Data Governance and REDI commitments. Core responsibilities include: designing, building, and maintaining ETL/ELT pipelines using Airflow, SQL, and Python; maintaining and improving the Data Warehouse architecture, models, schemas, dependencies, and documentation; developing and maintaining the Data Mart (star schemas) to support reporting and analytics with governed, non-PII data; developing orchestration workflows in Airflow to support recurring submissions, validation processes, report production, and downstream analytics; implementing schema validation and transformation to ensure data conform to PCSB standards and Data Mart models; monitoring and resolving Airflow failures, data quality issues, and pipeline errors in collaboration with Analytics Engineers and Product Managers; supporting accountability-related data infrastructure including A

DC Public Charter School Board (DC PCSB) is seeking a Data Engineer for its Analytics Products team. This role designs, builds, and maintains data pipelines, data warehouse models, orchestration workflows, and Data Mart structures that allow staff, school leaders, and public stakeholders to access reliable, governed data for reporting, accountability calculations, Enterprise Intelligence, and public analytics products. The Data Engineer combines traditional data engineering skills—pipelines, orchestration, warehousing, and cloud infrastructure—with close collaboration with Analytics Engineers, Product Managers, and agency program teams. The goal is scalable, auditable, and maintainable data architecture that complies with DC PCSB’s Data Governance and REDI commitments. Core responsibilities include: designing, building, and maintaining ETL/ELT pipelines using Airflow, SQL, and Python; maintaining and improving the Data Warehouse architecture, models, schemas, dependencies, and documentation; developing and maintaining the Data Mart (star schemas) to support reporting and analytics with governed, non-PII data; developing orchestration workflows in Airflow to support recurring submissions, validation processes, report production, and downstream analytics; implementing schema validation and transformation to ensure data conform to PCSB standards and Data Mart models; monitoring and resolving Airflow failures, data quality issues, and pipeline errors in collaboration with Analytics Engineers and Product Managers; supporting accountability-related data infrastructure including A