Data Engineer - Analytics Products

As a Data Engineer on the DC Public Charter School Board’s Analytics Products team, you will build and sustain the data pipelines, warehouse models, and data marts that underpin reporting, accountability calculations, and Enterprise Intelligence for public analytics. This is a remote position with an anticipated start in July 2026, offering a salary range of USD 83,520 to 103,172 per year.

Responsibilities

• Design, implement, and maintain ETL and ELT pipelines using Airflow, SQL, and Python to support analytical workflows and accountability calculations.
• Improve and document the Data Warehouse architecture, including data models, schemas, dependencies, and governance artifacts.
• Support the Data Mart development to ensure governed, non-PII data are organized for reporting, analysis, and Enterprise Intelligence use cases (star schemas).
• Create and sustain Airflow orchestration workflows for recurring data submissions, validations, report production, and downstream analytics products.
• Apply schema validation and transformation logic to ensure submitted data align with PCSB standards and Data Mart models.
• Monitor Airflow runs, troubleshoot pipeline failures, and address data quality issues in collaboration with Analytics Engineers and Product Managers.
• Support accountability data infrastructure, including ASPIRE, state assessment reporting, school performance reporting, and potential concurrent accountability frameworks.
• Manage cloud-based data infrastructure using AWS RDS, S3, IAM, and related services.
• Contribute to CI/CD processes by writing tests, conducting peer reviews, and ensuring reliable deployments of pipelines and infrastructure changes.
• Collaborate with Analysts, Analytics Engineers, and Product Managers to translate user stories and policy requirements into robust data models and automated workflows.
• Support Data Governance by maintaining data quality, privacy, transparency, and auditability across systems.
• Contribute to the Data Team Handbook and participate in Agile rituals to improve team processes.

Requirements

• Minimum of five years of professional experience in data engineering, analytics engineering, software engineering, database development, or a closely related technical role, with substantial SQL and Python experience in production or recurring workflows.
• Experience building and maintaining ETL/ELT pipelines to move data from source systems into databases, data warehouses, Data Marts, and reporting layers; handling structured data, data inconsistencies, and validation steps.
• Proficiency in data warehouse modeling and architecture, including understanding table grain, keys, relationships, dependencies, versioning, and downstream reporting needs.
• Experience creating governed, report-ready datasets and semantic models, with familiarity in dimensional modeling, star schemas, standardized definitions, or non-PII reporting layers.
• Background in workflow orchestration and reliability, using Airflow or equivalent tools to monitor recurring processes, diagnose failures, and implement durable fixes.
• Strong SQL skills and optimization experience for production data systems, with awareness of performance considerations, joins, indexing, migrations, and reporting impacts.
• Hands-on experience with cloud infrastructure and DevOps for data, including AWS services (RDS, S3, IAM, CloudWatch, Lambda, ECS) and practices like Git, CI/CD, Docker, and infrastructure-as-code.
• Knowledge of data governance, quality, and security practices, including data quality checks, documentation, lineage, privacy protections, access controls, and auditability, ideally in education or public sector contexts.
• Commitment to writing maintainable, tested, and well-documented code, with comfort in code reviews and contributing to long-term maintainability.
• Experience collaborating with analysts, product managers, program staff, and other non-engineering stakeholders to translate reporting and policy needs into reliable data infrastructure.
• Alignment with DC PCSB’s mission and REDI principles, emphasizing transparent, reliable, and equitable data systems for public education oversight.

Technologies

• Airflow, SQL, Python
• AWS RDS, S3, IAM, CloudWatch, Lambda, ECS
• Git, CI/CD, Docker, infrastructure-as-code practices

Benefits

• Comprehensive benefits plan that covers 100 percent of the employee’s insurance premium.
• Generous telecommuting policy to support remote work.
• Potential eligibility for the Public Service Loan Forgiveness Program for government or not-for-profit employees; details on studentaid.gov.
• Compensation system with a non-negotiation policy to promote fair pay practices.