Data Analyst

Database Analyst

Remote

Oregon Health Authority

No of Positions : 2

We need a candidate who is having Child Welfare Experience

The OIS Child Welfare Development Team seeks an experienced Database Analyst Level 4 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 will work towards fulfilling the Child Welfare (CW) twelvemonth plan items for 2024 and 2025 which support CW Transformation strategies including data quality initiatives and the emerging transition to dataoriented decision making in CW practice.

Contractors 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.

Contractors 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 Azure Development Operations
• Microsoft SQL Server/Reporting Services/Business Intelligence (79 years of experience)
• Microsoft Visual Studio (10 years of experience)
• Microsoft .NET framework (45 years of experience)
• HTML DOM (79 years of experience)
• Windows 9x/2000/XP/NT/Vista/7 (79 years of experience)
• Design patterns (79 years of experience)
• TransactSQL (10 years of experience)
• Data Analysis (10 years of experience)
• JSON (10 years of experience)
• SQL (10 years of experience)
• MVC (46 years of experience)
• XML (46 years of experience)
• C# (46 years of experience)
• HTML (46 years of experience)
• JavaScript (46 years of experience)
• TCP/IP (46 years of experience)
• Communication skills both verbal and written (46 years of experience)
• Microsoft Office (46 years of experience)

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 nontechnical Business Analysts and nontechnical 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 date warehouses
• Apache (13 years of experience)
• SOAP (13 years of experience)
• Angular (13 years of experience)
• Erwin (13 years of experience)
• ASP (46 years of experience)
• Service oriented architecture (SOA) (46 years of experience)
• XMLDOM (46 years of experience)
• XMLSchema (46 years of experience)
• ADO.NET (46 years of experience)
• AJAX (46 years of experience)
• DHTML (46 years of experience)
• CSS (46 years of experience)
• Microsoft Exchange Server (46 years of experience)
• WSDL (46 years of experience)
• PL/SQL (46 years of experience)
• ASP. NET (46 years of experience)
• VBScript (46 years of experience)
• XHTML (46 years of experience)
• XSL (46 years of experience)
• XSLT (46 years of experience)
• Shell (46 years of experience)
• Backup and recovery (46 years of experience)
• Active Directory (46 years of experience)
• IIS (46 years of experience)
• Microsoft Internet Information Server (IIS) (46 years of experience)
• IBM WebSphere (46 years of experience)
• Microsoft Visual Studio .NET (46 years of experience)