Stefanini Group is hiring!
Exciting opportunity awaits let us help you get started!
Click Apply now or you may call Vipul Bhardwaj at 1 or email at for faster processing!
Project Summary
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.
Purpose and objectives
- 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 departments 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
- 3. 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.
- 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.
- Open API 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.
Listed salary ranges may vary based on experience qualifications and local market. Also some positions may include bonuses or other incentives
About Stefanini Group
The Stefanini Group is a global provider of offshore onshore and near shore outsourcing IT digital consulting systems integration application and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like Americas Europe Africa and Asia and more than 400 clients across a broad spectrum of markets including financial services manufacturing telecommunications chemical services technology public sector and utilities. Stefanini is a CMM level 5 IT consulting company with global presence. We are CMM Level 5 company.
#LI-VB1
#LI-REMOTE
Required Experience:
IC
Job DescriptionStefanini Group is hiring!Exciting opportunity awaits let us help you get started!Click Apply now or you may call Vipul Bhardwaj at 1 or email at for faster processing!Project SummaryThe API Developer will build and maintain the data services that power the dashboard ensuring reliab...
Stefanini Group is hiring!
Exciting opportunity awaits let us help you get started!
Click Apply now or you may call Vipul Bhardwaj at 1 or email at for faster processing!
Project Summary
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.
Purpose and objectives
- 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 departments 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
- 3. 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.
- 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.
- Open API 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.
Listed salary ranges may vary based on experience qualifications and local market. Also some positions may include bonuses or other incentives
About Stefanini Group
The Stefanini Group is a global provider of offshore onshore and near shore outsourcing IT digital consulting systems integration application and strategic staffing services to Fortune 1000 enterprises around the world. Our presence is in countries like Americas Europe Africa and Asia and more than 400 clients across a broad spectrum of markets including financial services manufacturing telecommunications chemical services technology public sector and utilities. Stefanini is a CMM level 5 IT consulting company with global presence. We are CMM Level 5 company.
#LI-VB1
#LI-REMOTE
Required Experience:
IC
View more
View less