Software Technology Inc
Location
Oregon, OH | United States
Job 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 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) twelve-month plan items for 2024 and 2025 which 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:
Required skills and experience:
In addition, the ideal candidate will have skills and experience in:
Covendis rate card description for a Database Analyst 4:
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.
Covendis rate card rates for a Database Analyst 4:
Minimum $$$
Maximum $$$
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. All proposals must be complete. Please include a detailed cost proposal for proposed deliverables consistent with the delivery and payment schedule in attached Statement of Work.
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 likely add to the background check process timeline.
The selected key person could potentially telecommute, as agreed to between the Agency Authorized Representative and the key person. Any decision to allow telecommuting is made with the understanding that decision will be re-evaluated by the Agency Authorized Representative on a regular basis. The key person should be available to work onsite within a reasonable timeframe.Telecommuting will be contingent upon the key person providing his/her own adequate computer, monitor(s), Internet connection, and telephone in a secure location, 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.
Work schedule is typically Monday - Friday, 8 AM - 5 PM Pacific Standard Time.
Number Name Deliverables Description Start Date End Date
1.01Sprint Report Package 202403
Sprint Report Package 202404
Sprint Report Package 202404
Sprint Report Package 202405
Sprint Report Package 202405
Sprint Report Package 202406
Sprint Report Package 202406
Sprint Report Package 202407
Sprint Report Package 202407
Sprint Report Package 202408
Sprint Report Package 202408
Sprint Report Package 202409
Sprint Report Package 202409
Sprint Report Package 202410
Sprint Report Package 202410
Sprint Report Package 202411
Sprint Report Package 202411
Sprint Report Package 202412
Sprint Report Package 202412
Sprint Report Package 202501
Sprint Report Package 202501
Sprint Report Package 202502
Sprint Report Package 202502
Sprint Report Package 202503
Sprint Report Package 202503
FTSD Deliverables
FTSD Deliverables
Code Modifications and System Testing Deliverables
Code Modifications and System Testing Deliverables
Knowledge Transfer Deliverables
Knowledge Transfer Deliverables
| Location Requirements | |
| Candidate must be local or willing to commute or relocate. | No preference |
| Additional Location Details (City, State) : | Telecommuting/remote work will be contingent upon the key person providing their own adequate office equipment, secure location, and connectivity. |
| Requisition Custom Selections | |
| . | Please upload the required document to the comment section of the proposal |
| Examples of prior work product Relevant to the Services and Deliverables described in this Opportunity (maximum five pages). | No |
| Summary of Key Person(s) qualifications and experience providing the requested or similar services . If Key Person(s) are the Proposer's sub-contractors, identify the sub-contracting firm and the percentage of work that will be sub-contracted out. | Yes |
| Description of Supplier's (organization) experience of relevant functional business areas or programs and processes as cited in the description of this program/work in Oregon, or similar programs and process knowledge from other states. | No |
| Resumes of Key Person(s) proposed to perform work as described in this Opportunity, including their education and work experience. | Yes |
| (3) Supplier (Organization) References References must be clients for whom your organization has performed similar work within the last three (3) years . Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states . Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate Proposer's performance. | No |
| (3) References for each proposed Key Person References must be for similar work performed within the last three (3) years. Where possible, clients listed for reference should be state or local Oregon government agencies or health and human services organizations in other states . Include the client's company name, address, and contact person with telephone and email address for the contact person. The contact person must be someone who was directly involved in the work and is qualified to evaluate the performance of the Key Person(s). | Yes |
| Background Verification | |
| Minimum Verification Requirements | Please have the candidate complete the required form upon selection. The form is located on the dashboard. |
Job tags
Salary
