API Developer

Required Skill:

At minimum 7 years experience, Microsoft SQL, RESTful
API development: JASON payloads, OpenAPI and Git documentation
Experience with Agile/Scrum Methodologies
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.

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.