SQL/BI developer with .Net experience (Remote)

Description

• The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Department of Human Services (DHS). OIS provides the technology systems and services that support more than 18,000 OHA and DHS 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 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)

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 date warehouses

Description for a Database Analyst IV:

• Maintains data storage and access by evaluating, designing and implementing company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a manager. May require a bachelor's degree in a related area and 0 2 years of relevant experience.
• Full-time professional work experience in Software Development, Maintenance, or Implementation. Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.) Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years. Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.) Two (2) years of work experience as a Data Administrator; Data Warehousing Administrator; Data Architect; Database Analyst-Intermediate; Data Warehousing Analyst may substitute for all of the required experience.
• Our primary criteria are the qualifications and experience of the proposed key person. Please propose your strongest candidate, at a rate less than or equal to the maximum.
• Interviews will be conducted via MS Teams. Interview times will reflect Pacific Standard Time.
• Due to circumstances beyond our control, we anticipate two weeks or more for the background check completion for the selected candidate. In addition to the standard OHA/DHS background check, the selected candidate will need to pass a CJIS background check. This will add to the background check process timeline.
• Telecommuting will be contingent upon the key person(s) providing their own adequate computer, monitor(s), Internet connection, and telephone, and be readily available during normal working hours via phone, email or instant message. Access to Agency systems will be provided via VPN or similar software. No hardware or additional software will be provided at the key person's home site or his/her PC.
• For Services that are agreed to occur remotely that those Services will only be completed by the Key Person(s) resourced for the Project and all work must be performed in the United States of America. Remote engagement requires Key Person(s) to have consistent access and/or clarity for: high speed internet, cellular phone/landline phone, web camera and microphone.
• OIS/ODHS operates on standard business days (Monday - Friday, 8 AM 5 PM, Pacific Standard Time, except for State of Oregon holidays and business closures) and Key Person(s) must be available to engage with OIS/ODHS as agreed upon with OIS management.