SQL Server Database Analyst

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 06 Month(s)

Skills

ASP.NET MVC
Data Analysis
C#
TCP/IP
SQL
Microsoft Azure
JavaScript
XML
DevOps

Job Details

Title: SQL Server Database Analyst

Locations: Salem OR

Duration :06 Months


The OIS Child Welfare Development Team seeks an experienced Database Analyst Level IV with expertise in designing and developing Microsoft SQL Server data structures, optimizing interactions with and within the database (SQL, stored procedures, ETL, etc.), in accordance with business, data security and regulatory requirements as well as legislative mandates and court findings.

This work will continue fulfilling the Child Welfare (CW) plan items from previous years and continue to support CW Transformation strategies including data quality initiatives and the emerging transition to data-oriented decision making in CW practice.

Contractor s Key Person will also work with various CW program areas and business teams to deliver strategic roadmap components to execute data modernization efforts, fulfill legislative mandates and comply with court findings.

Scope:

Contractor s Key Person under this WOC will participate in executing the strategic direction for use of data to support CW programmatic and administrative functions. Contractor s Key Person will provide expertise in the planning efforts to identify and modernize the agency s data assets and to develop the future-state technical environment for CW.

Tasks:

Contractor s Key Person shall:

  • Develop database structure and process changes based on specifications established during weekly Sprint planning sessions and following data standards based on existing datatype standards where available and appropriate; address standards published by the United States Postal Service as an example.
  • Comply with data security and access models.
  • Comply with Federal regulations for CCWIS (Comprehensive Child Welfare Information System) design, development, deployment and maintenance.
  • Follow a data (or database) change request process with the developer and Data Resource Management teams.

Required skills and experience:

  • Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years of experience)
  • HTML DOM (7-9 years of experience)
  • Windows 9x/2000/XP/NT/Vista/7 (7-9 years of experience)
  • Transact-SQL (10+ years of experience)
  • Microsoft Visual Studio (10+ of years of experience)
  • Microsoft .NET framework (4-6 years of experience)
  • Microsoft Azure Development Operations
  • MVC (4-6 years of experience)
  • Data Analysis (10+ years of experience)
  • JSON (10+ years of experience)
  • SQL (10+ years of experience)
  • MVC (4-6 years of experience)
  • XML (4-6 years of experience)
  • C# (4-6 years of experience)
  • HTML (4-6 years of experience)
  • JavaScript (4-6 years of experience)
  • TCP/IP (4-6 years of experience)
  • Communication skills both verbal and written (4-6 years of experience)
  • Microsoft Office (4-6 years of experience)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.