CodeForce
IA-DOM-DoED-TS3-C#.NET SQL Developer
CodeForce, Iowa City, Iowa, United States, 52245
The Iowa Department of Education needs a techno/functional development specialist to provide support for the maintenance and improvement of key applications for student reporting.
The Iowa Department of Education needs a technical and functional development specialist to support the development and maintenance of key applications. The Iowa Department of Education needs a .NET application developer with advanced SQL knowledge to develop applications leveraging a modernized standards-based infrastructure. Ideally, this candidate would need to have good communication skills and ability to also function as a business analyst in this role.
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 stakeholders30% Independent development work30% Data refinement/SQL queries20% 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# developmentExperience in developing REST API Services4 plus years of experience in .Net projects4 plus years of experience in .Net Core4 plus years of experience with MSSQL Stored Procedures, SSIS Packages4 plus years of experience in ASP.net/ MVC web development using C#4 plus years of experience in working with MSSQL ServerHands on experience with JavaScript and jQueryFull Stack Capabilities a plus
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceC# .NET developmentRequired5Yearsdeveloping REST API ServicesRequired5Yearsexperience working with MSSQL ServerRequired5YearsMSSQL Stored Procedures, SSIS PackagesRequired5Yearshands on experience with JavaScript and jQueryRequired5Yearsexperience working with stakeholders in a business analysis capacityHighly desired5YearsQuestions
No.QuestionQuestion1The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?Question2Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?Question3This requirement falls under the E-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?Question4Please list candidate's email address.Question5The Vendor Rate for this position is $87.35. Do you accept this requirement?Question6PROVIDE CANDIDATES CURRENT PHYSICAL LOCATION [HERE]Question7SHOW YOUR WORK - In the summary of qualifications field under the details tab of the candidate's profile, you should explain why your candidate is the best fit for this position. Please confirm that you have thoroughly validated and attested to the accuracy of the credentials listed throughout this candidate's VectorVMS profile and resume according to Section 5.2.5 of ITS-009440. Do you confirm? Candidates will get rejected if an agency cuts and pastes the candidates' resumes into this field.
The Iowa Department of Education needs a technical and functional development specialist to support the development and maintenance of key applications. The Iowa Department of Education needs a .NET application developer with advanced SQL knowledge to develop applications leveraging a modernized standards-based infrastructure. Ideally, this candidate would need to have good communication skills and ability to also function as a business analyst in this role.
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 stakeholders30% Independent development work30% Data refinement/SQL queries20% 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# developmentExperience in developing REST API Services4 plus years of experience in .Net projects4 plus years of experience in .Net Core4 plus years of experience with MSSQL Stored Procedures, SSIS Packages4 plus years of experience in ASP.net/ MVC web development using C#4 plus years of experience in working with MSSQL ServerHands on experience with JavaScript and jQueryFull Stack Capabilities a plus
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceC# .NET developmentRequired5Yearsdeveloping REST API ServicesRequired5Yearsexperience working with MSSQL ServerRequired5YearsMSSQL Stored Procedures, SSIS PackagesRequired5Yearshands on experience with JavaScript and jQueryRequired5Yearsexperience working with stakeholders in a business analysis capacityHighly desired5YearsQuestions
No.QuestionQuestion1The Contractor must report any disciplinary action, misdemeanor or felony convictions to the State for any temporary IT staff provided. Do you agree to this requirement?Question2Absences greater than two weeks MUST be approved by CAI Management in advance, and contact information must be provided to CAI so that a resource can be reached during his or her absence. The client has the right to dismiss the resource if she or he does not return to work by the agreed upon date. Do you accept this requirement?Question3This requirement falls under the E-RTR process. The candidate MUST submit their Right to Represent electronically following the process to be considered. Do you accept this requirement?Question4Please list candidate's email address.Question5The Vendor Rate for this position is $87.35. Do you accept this requirement?Question6PROVIDE CANDIDATES CURRENT PHYSICAL LOCATION [HERE]Question7SHOW YOUR WORK - In the summary of qualifications field under the details tab of the candidate's profile, you should explain why your candidate is the best fit for this position. Please confirm that you have thoroughly validated and attested to the accuracy of the credentials listed throughout this candidate's VectorVMS profile and resume according to Section 5.2.5 of ITS-009440. Do you confirm? Candidates will get rejected if an agency cuts and pastes the candidates' resumes into this field.