Data Engineer – Analytics Products

DC Public Charter School Board

Data Engineer managing data pipelines and infrastructure for educational insights at DC PCSB. Collaborating with teams to ensure data governance and quality standards are met.

Posted 7/25/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $83,520 - $103,172 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining ETL/ELT pipelines, data warehouse architecture, and cloud-based data infrastructure, particularly using Airflow, SQL, and Python. Proven ability to develop reliable data models and ensure data quality in a collaborative environment.

Highest-signal resume keywords

ETL/ELT Pipeline DevelopmentAirflow Workflow ManagementSQL OptimizationPython ProgrammingAWS Cloud Infrastructure

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL DevelopmentELT DevelopmentSQLPythonData Warehouse ArchitectureData Mart DevelopmentData Quality MonitoringData ModelingOrchestration WorkflowsCI/CD Practices

Tools & Technologies

AirflowAWS

Industry Keywords

Data EngineeringAnalytics EngineeringDatabase DevelopmentData InfrastructureReporting Needs

Tech Stack

Tools & technologies

AirflowAWSCloudETLPythonSQL

About the role

Key responsibilities & impact

Design, build, and maintain ETL/ELT pipelines using Airflow, SQL, and Python.
Maintain and improve PCSB's Data Warehouse architecture.
Support the development and reliability of the Data Mart.
Develop and maintain orchestration workflows in Airflow.
Monitor and resolve Airflow failures and data quality issues.
Support accountability-related data infrastructure.
Manage cloud-based data infrastructure using AWS.
Contribute to a CI/CD environment by writing tests and performing peer code reviews.
Collaborate with teams to translate reporting needs into reliable data models.

Requirements

What you’ll need

At least five (5) years of professional experience in data engineering, analytics engineering, software engineering, or database development.
Substantial experience using SQL and Python in a production or recurring-workflow environment.
Experience building and maintaining ETL/ELT pipelines.
Experience designing, maintaining, or improving database, warehouse, or analytics data models.
Experience creating governed, report-ready datasets or semantic models.
Experience developing, maintaining, or troubleshooting scheduled data workflows using Airflow.
Experience writing and optimizing SQL for production data systems.
Familiarity with cloud infrastructure and deployment workflows (especially AWS services).

Benefits

Comp & perks

DC PCSB offers a comprehensive benefits plan covering 100% of the employee’s insurance premium.
Generous telecommuting policy.
Potential eligibility for the PSLF Program for employees from government or non-profit organizations.