This position will develop an Operational Data Store (ODS) and eTranscript repository. This position will also be responsible for developing APIs to deliver data from these data stores to multiple applications across the enterprise. APIs will need to connect and deliver data securely to other agencies such as the Department of Health and Human Services. This position will be responsible for developing additional .NET applications such as a public reporting website.
The Departments eTranscript gateway project will connect with a third-party vendor to pull transcript data on demand and deliver it to the eTranscript gateway application hosted by the Board of Regents. This position will also develop and enhance the ODS to deliver real-time data and reporting to users to support foster care, migrant, and direct certification processes. This work will include working with a team on updating application requirements documentation, architecting and implementing improvements to data collection, validation, and reporting features across the application suite; rebuild legacy code in C#/.NET.
Candidate will work on education mission-focused solutions supporting Iowa educational institutions. The candidate will work with the latest .Net technologies and tools; have an opportunity to work with the project team to analyze and document requirements; and help to refine complex data validations using MS SQL. This will be a full stack web development with hands on experience with back-end tools.
This position will include independent work as well as collaborative work with the technical team and the close-knit team of business users/data analysts. The contractor will coordinate work tasks with the SME team and IT project manager and supported by the DBA and lead developer. The contractor will be a part of the agency app development team during this work, participating in regular team check-ins and collaboration opportunities.
Day-to-day Duties Of This Position
20% Business analysis meetings with stakeholders
30% Independent development work
30% Data refinement/SQL queries
20% Testing
Technical Environment
Visual Studio 2017, Visual Studio 2022, MS Sql Server, TFS
Tools And Technologies The Contractor Will Be Working With