CNET SQL Developer

Location: 400 E 14th Street, Des Moines- Remote

Duration: 1 Year

Job Description

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 Department's 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:

C#, APIs, .NET core, MVC, JavaScript, JQuery, Linq, MSSQL, Html, CSS, Bootstrap, Bootswatch,Entity Framework, EF Core, Rest Services

Technical priorities:

4 plus year experience in C# development

Experience in developing REST API Services

4 plus years of experience in .Net projects

4 plus years of experience in .Net Core

4 plus years of experience with MSSQL Stored Procedures, SSIS Packages

4 plus years of experience in ASP.net/ MVC web development using C#

4 plus years of experience in working with MSSQL Server

Hands on experience with JavaScript and jQuery

Full Stack Capabilities a plus