Data Engineer- Analytics Products

DC Public Charter School Board (DC PCSB) is dedicated to ensuring that public charter school students receive a quality education. The Data Engineer will be a key member of the Analytics Products team, responsible for building and maintaining the data infrastructure to support agency reporting and public-facing analytics products.

Responsibilities:

• Design, build, and maintain ETL/ELT pipelines using Airflow, SQL, and Python to support analytical workflows, reporting products, and accountability calculations
• Maintain and improve PCSB’s Data Warehouse architecture, including data models, schemas, dependencies, and documentation
• Support the development and reliability of the Data Mart, ensuring that governed, non-PII data are structured for reporting (star schemas), analysis, and Enterprise Intelligence use cases
• Develop and maintain orchestration workflows in Airflow that support recurring data submissions, validation processes, report production, and downstream analytics products
• Implement schema validation and transformation logic to ensure submitted and processed data conform to PCSB standards and Data Mart models
• Monitor and resolve Airflow failures, pipeline errors, and data quality issues in collaboration with Analytics Engineers and Product Managers
• Support accountability-related data infrastructure, including ASPIRE, state assessment reporting, school performance reporting, and potential concurrent accountability calculation frameworks
• Manage cloud-based data infrastructure using AWS RDS, S3, IAM, and related services
• Contribute to a CI/CD environment by writing tests, performing peer code reviews, and ensuring reliable deployment of data pipelines and infrastructure changes
• Collaborate with Analytics Engineers and Product Managers to translate user stories, reporting needs, and policy requirements into reliable data models and automated workflows
• Support PCSB’s Data Governance by maintaining data quality, privacy, transparency, and auditability across systems
• Contribute to the Data Team Handbook and participate in Agile rituals, including sprint planning, reviews, and retrospectives, to improve team processes

Requirements:

• At least five (5) years of professional experience in data engineering, analytics engineering, software engineering, database development, or a closely related technical role
• Substantial experience using SQL and Python in a production or recurring-workflow environment
• Experience building and maintaining ETL/ELT pipelines that move data from source systems into databases, data warehouses, Data Marts, reporting layers, or analytics products
• Experience designing, maintaining, or improving database, warehouse, or analytics data models
• Experience creating governed, report-ready datasets, views, tables, or semantic models
• Experience developing, maintaining, or troubleshooting scheduled data workflows using Airflow or a comparable orchestration tool
• Experience writing and optimizing SQL for production data systems
• Experience using cloud infrastructure and deployment workflows to support data pipelines, databases, warehouses, or analytics products
• Experience implementing data-quality checks, documentation, lineage, privacy protections, access controls, or auditability practices within data pipelines or warehouse models
• Experience writing maintainable, tested, and documented code using version control
• Experience working with analysts, Analytics Engineers, Product Managers, program staff, or other non-engineering partners to translate reporting, accountability, or business needs into reliable data infrastructure
• Commitment to DC PCSB's mission, values, and REDI principles