Dover, DE - IT - DOE - Technology & Data Office - Programmer 6

Overview

Short term assignment that will end on 6/30/26. Title: Programmer 6. Rate: ***. Remote. Interviews: Virtual. Project Summary: The Redding Equity Dashboard will provide a secure, public facing view of key equity indicators across Delaware schools, with consistent definitions, suppression rules, and filtering to support transparent reporting and data driven decision making. The API Developer will build and maintain the data services that power the dashboard, ensuring reliable, scalable access to curated datasets and enabling timely updates and future expansion.

Responsibilities

• Design and implement secure, documented APIs that deliver aggregated dashboard datasets to the Web Developer.
• Implement consistent business rules described in the data considerations, including enrollment scope, exclusion rules, and suppression for counts.

Data domains to support

• APIs must support all data domains within department’s public reporting database.

Handling known data gaps and inconsistencies

• Provide a data availability endpoint so the UI can communicate limitations by Local Education Agency (LEA) and metric, aligned to the documented missing data lists.
• Partner with department staff to ensure all data elements needed are available.

API design requirements

• REST or GraphQL, with preference determined by department standards, with OpenAPI documentation required for all endpoints.
• Versioning strategy, including backward compatible changes for the Web Developer.
• Standard query parameters
• Domain, metric, year, as of date.
• Geography: city, county, state, district, school
• LEA type: traditional public, charter, vo tech, as categorized.
• Standard response structure
• Metadata: dataset name, as of date, refresh cadence, suppression policy, and calculation notes.
• Data payload: categories, counts, percents, suppressed indicators, denominator values where applicable.
• Caching headers and server-side caching for common queries.

Security and governance

• Public read only access pattern with protection against abuse
• API gateway and rate limiting
• Logging and monitoring.
• No PII exposure. Only aggregated values with suppression.
• Align to Department and Data Management Office (DMO) security standards for hosting and operations.

Data pipeline and refresh

• Define extract and transform processes with DMO, including data validations needed for:
• Verified address for City of Wilmington.
• LEA code mappings for attendance and tardy codes.
• Refresh cadence
• Support snapshot-based refresh where stated in the document that data will not be continuously updated.
• Provide clear run logs and publish last refresh timestamps.
• Automated tests for calculations and suppression rules.

Deliverables

• API implementation deployed to the agreed environment.
• OpenAPI specification and developer portal documentation.
• Data dictionary and metric definition catalog aligned to UI needs.
• Data availability and gap reporting endpoints aligned to the documented considerations.
• Operational runbook for refresh, monitoring, incident response, and onboarding new metrics.

Acceptance criteria

• API responses match documented business rules and suppression.
• Performance supports dashboard use with reasonable response times under load.
• Security controls implemented and validated.
• Documentation enables the Web Developer to implement the UI without additional reverse engineering.
• DMO review and sign off on governance, definitions, and operational readiness.