Database Analyst IV

TalentBurst; Salem (OR); On-site; USD 80,000 - 110,000; Full time

Job summary

Eine innovative Behörde sucht einen erfahrenen Datenbankanalysten, der die strategische Richtung für die Nutzung von Daten im Bereich Kinderschutz unterstützt. In dieser Schlüsselrolle werden Sie für die Entwicklung und Optimierung von Microsoft SQL Server-Datenstrukturen verantwortlich sein und sicherstellen, dass alle gesetzlichen Vorgaben eingehalten werden. Sie arbeiten eng mit verschiedenen Programmbereichen zusammen, um Datenmodernisierungsprojekte voranzutreiben und die Qualität der Daten zu verbessern. Wenn Sie leidenschaftlich an der Verbesserung von Lebensqualität durch datengestützte Entscheidungen interessiert sind, ist dies die perfekte Gelegenheit für Sie.

Qualifications

• 7-9 Jahre Erfahrung in Microsoft SQL Server und Reporting Services.
• 10+ Jahre Erfahrung in Transact-SQL und Datenanalyse.
• Erfahrung in der Zusammenarbeit mit nicht-technischen Business-Analysten.

Responsibilities

• Entwicklung von Datenbankstrukturen und Prozessänderungen basierend auf Spezifikationen.
• Einhaltung von Daten- und Sicherheitsmodellen.
• Unterstützung von Modernisierungsinitiativen in der Kinderschutzpraxis.

Skills

Microsoft SQL Server

Transact-SQL

Data Analysis

JSON

C#

HTML

JavaScript

Communication skills

Tools

Microsoft Visual Studio

Microsoft .NET framework

Microsoft Azure Development Operations

Job description

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Client. OIS provides the technology systems and services that support more than 18,000 OHA and Client agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food, and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.

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 support CW Transformation strategies, including data quality initiatives and the emerging transition to data-oriented decision making in CW practice.

The 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:

The 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. They will provide expertise in planning efforts to identify and modernize the agency's data assets and develop the future-state technical environment for CW.

Tasks:

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

Required skills and experience:

1. Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years)
2. HTML DOM (7-9 years)
3. Windows 9x/2000/XP/NT/Vista/7 (7-9 years)
4. Transact-SQL (10+ years)
5. Microsoft Visual Studio (10+ years)
6. Microsoft .NET framework (4-6 years)
7. Microsoft Azure Development Operations
8. MVC (4-6 years)
9. Data Analysis (10+ years)
10. JSON (10+ years)
11. SQL (10+ years)
12. XML (4-6 years)
13. C# (4-6 years)
14. HTML (4-6 years)
15. JavaScript (4-6 years)
16. TCP/IP (4-6 years)
17. Communication skills both verbal and written (4-6 years)
18. Microsoft Office (4-6 years)

In addition, the ideal candidate will have skills and experience in:

• Software development life cycle, especially related to the impact from requirement changes.
• Agile Software Development Process.
• Requirements elicitation and specification in collaboration with non-technical Business Analysts and non-technical CW business program staff.
• Modernization initiatives targeting specific technology changes or generational changes in Federal program regulations.
• Working to deliver technical solutions in a County, State, or Federal Human Services context.
• Managing the impact of database changes on external data exchanges or data warehouses.