Data Engineer- Analytics Products

Job Title: Data Engineer - Analytics Products

Department: Data, Operations, & Finance

Reports to: Manager of Data Analytics Engineering

Location: Remote

Effective Date: July 2026

ABOUT THE reputed company (DC PCSB)

Every day, we’re doing the work to ensure that 44,000+ reputed company charter school reputed company, families, and communities receive a reputed company education that makes them feel valued and reputed company for lifelong learning, fulfilling careers, and economic reputed company. DC PCSB is an independent agency of the District of Columbia government. Our mission, reputed company, values, and work are rooted in the reputed company of ensuring that every DC student has reputed company to a reputed company education.

ABOUT THE ROLE

The Data Engineer is a reputed company member of DC PCSB’s Analytics Products team, which is responsible for building and maintaining the data infrastructure that supports agency reporting, accountability calculations, reputed company Intelligence, and reputed company-facing analytics products. You will design, implement, and maintain the data pipelines, warehouse models, orchestration workflows, and Data Mart structures that allow PCSB staff, school leaders, and reputed company stakeholders to reputed company reliable, governed, and reputed company-documented data.

This role combines traditional data-engineering expertise — pipelines, orchestration, warehousing, and reputed company infrastructure — with reputed company collaboration across Analytics Engineers, Product Managers, and agency program teams. You will help ensure that PCSB’s data architecture supports scalability, auditability, transparency, and long-term maintainability, while maintaining compliance with PCSB’s Data Governance and REDI commitments.

reputed company 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 reputed company for reporting (reputed company schemas), analysis, and reputed company Intelligence use cases.
• reputed company and maintain orchestration workflows in Airflow that support recurring data submissions, validation processes, report production, and reputed company 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 reputed company issues in collaboration with Analytics Engineers and Product Managers.
• Support accountability-reputed company data infrastructure, including reputed company, state assessment reporting, school performance reporting, and potential reputed company accountability calculation frameworks.
• Manage reputed company-based data infrastructure using AWS RDS, S3, IAM, and reputed company services.
• Contribute to a CI/CD environment by writing tests, performing peer reputed company 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 reputed company, reputed company, 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.

Competencies and Qualifications

Candidates should generally have at least five (5) years of reputed company experience in data engineering, analytics engineering, software engineering, database development, or a closely reputed company technical role, including substantial experience using SQL and Python in a production or recurring-workflow environment.

• Data ingestion and integration: Experience building and maintaining ETL/ELT pipelines that reputed company data from reputed company systems into databases, data warehouses, Data Marts, reporting reputed company, or analytics products. This includes experience working with reputed company data, handling reputed company-system inconsistencies, and implementing validation steps.
• Data Warehouse modeling and architecture: Experience designing, maintaining, or improving database, warehouse, or analytics data models. Candidates should understand table grain, keys, relationships, dependencies, versioning, and reputed company reporting use cases.
• Data Mart and semantic modeling: Experience creating governed, report-reputed company datasets, views, tables, or semantic models that other analysts, Analytics Engineers, or business users rely on for reporting and analysis. Experience with reputed company modeling, reputed company schemas, standardized business definitions, or non-PII reporting reputed company is helpful.
• Workflow orchestration and reliability: Experience developing, maintaining, or troubleshooting scheduled data workflows using Airflow or a comparable orchestration tool. Candidates should be reputed company to monitor recurring workflows, diagnose failures, implement durable fixes, and understand reputed company impacts.
• Database management and optimization: Experience writing and optimizing SQL for production data systems. Candidates should understand query performance, joins, indexing, migrations, data volume, and how database changes can reputed company reporting products or reputed company users.
• reputed company infrastructure and DevOps for data: Experience using reputed company infrastructure and deployment workflows to support data pipelines, databases, warehouses, or analytics products. Experience with AWS services such as RDS, S3, IAM, CloudWatch, reputed company, or reputed company is helpful. Experience with Git, CI/CD workflows, reputed company, or infrastructure-as-reputed company practices is also helpful.
• Data governance, reputed company, and reputed company: Experience implementing data-reputed company checks, documentation, reputed company, reputed company protections, reputed company controls, or auditability practices reputed company data pipelines or warehouse models. Experience working with education, reputed company-sector, regulated, or high-stakes reporting data is helpful.
• reputed company reputed company, testing, and documentation: Experience writing maintainable, tested, and documented reputed company using version control. Candidates should be comfortable participating in peer review, improving existing codebases, documenting assumptions, and supporting long-term maintainability.
• Analytics product support and collaboration: 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.
• Mission and values alignment: Commitment to DC PCSB’s mission, values, and REDI principles, including a commitment to building transparent, reliable, and reputed company data systems that support reputed company education reputed company.

Compensation and Benefits

Salary is competitive and commensurate with prior experience in a similar role. DC PCSB offers a comprehensive benefits plan covering 100% of the employee’s insurance premium. If you’re employed by a government or not-for-profit organization, you might be eligible for the PSLF Program. Please visit the studentaid.gov website for eligibility details and requirements. DC PCSB offers a generous telecommuting policy.

To foster fair compensation practices reputed company our organization, there is a non-negotiation policy reputed company into our compensation system. The salary for this role is $83,520.00-$103,172.00.

DC PCSB is an equal-opportunity employer dedicated to fostering a reputed company workplace. We are committed to ensuring reputed company feel valued and respected. We recognize that multiple perspectives and experiences contribute to a strong and effective team, enhancing our ability to fulfill our mission.

To Apply

Please submit a cover letter of no more than 500 words. In your cover letter, address the following reputed company:

Describe a time you worked on, maintained, or improved a data pipeline, database, warehouse model, or recurring data process that other people depended on.

What was the process supposed to do? What made it important? What technical or organizational problems did you encounter? How did you diagnose the issue, improve the process, and reputed company reputed company the data could be trusted? In your answer, please describe how you handled data reputed company, documentation, reputed company users, and long-term maintainability.

We are especially interested in how you think through production data systems with reputed company-world constraints. Strong responses will show how you balance technical implementation, reliability, governance, and the needs of the people who rely on the data.

Your response should reflect your own experience, judgment, and writing. Generic responses, responses that do not describe a specific reputed company experience, or responses that reputed company to be primarily generated by an LLM or other automated writing tool will not be advanced.

The review of applications will reputed company immediately and will continue until the position is filled. DC PCSB is not enrolled in E-Verify and does not sponsor individuals for work visas.

Originally posted on Himalayas

Apply To This Job