Developer
Remote / W2 / C2C / 1099
Background / Description:
This role, for the Colorado Office of Information Technology (OIT), will work collaboratively with the OIT Solution Architect, and other OIT resources, to assist in the migration of data. This role will create extractions based on case types for the Needles system that is being migrated to a SaaS product. This position will develop extracts using SQL to create .BAK files, excel files, and other file types as needed. This resource will also work closely with the Colorado Department of Labor and the SaaS product vendor to help in the mapping of the legacy system data into the SaaS product.
This role will also assist in the development of an index and method to convert thousands of relevant case documentation to both the SaaS product as well as to a storage drive with specified folders. The nature of the drive could be either an AWS S3 bucket or a NAS drive.
This position requires an individual to go through a National background check with fingerprinting because they will have access to Criminal Justice Information (CJI).
Requirements:
- Expert-level experience with Structured Query Language (SQL).
- Expert-level experience in creating, modifying, and querying relational databases.
- Expert-level experience in the creation of SQL queries to retrieve specific data from Needles by specifying various search criteria.
- Experience with SQL Server Management Studio (SSMS).
- At least 5 years of experience with interpreting database tables and data to understand correct extraction and mapping.
- Experience formatting, running totals, summaries, custom formulas, and custom Functions (SQL Queries).
- Experience PLSQL Developer, SQL Plus, SQL Navigator, and TOAD.
- Experience with the .NET framework is preferred.
- Experience using Nuxeo is preferred.
- Experience in Visual Studio Code is preferred.
- Strong ability to research and manage complex data requests
- Sound oral and written communication skills
- High evaluative and interpretative skills