Software Engineer IV

This position is approved for remote work.

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 11,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 Oregon Department of Human Services (ODHS) provides a number of social programs to qualifying Oregon citizens. One of these programs, the Jobs Opportunity and Basic Skills (JOBS), is funded through Temporary Assistance to Needy Families (TANF) and seeks to provide assistance for and remove barriers to economic independence. The JOBS program contracts with private vendors to provide services to Oregonians with the goal of helping them develop necessary skills and receive needed services to become financially and economically self-sufficient. The ODHS is committed to continuous improvement by measuring the performance of different program elements. Evaluating the success of the JOBS program is done through their Self-Sufficiency Programs (SSP) Employment and Training (E&T) area of ODHS. The SSP selected the Jobs Opportunity and Basic Skills (JOBS) as an area to be measured to determine success and to determine what, if any, program adjustments are needed for the purpose of meeting goals.

JOBS offers services to participants, in four service categories which include Stability, Wellbeing, Education and Training, and Job Readiness/Employment. A workgroup was created to define success for each contracted service. The evaluation program has had input from E&T Policy, local SSP staff, the Office of Reporting, Research, Analytics, and Implementation (ORRAI), and JOBS contractors.

OIS seeks an experienced Software Engineer IV to provide programming and application development support to the JOBS Outcome Indicators (JOI) application, a web-based system which has been developed to collect and manage data from contract vendors related to services provided to program participants. Key Person must have expertise in developing and implementing C#/.Net applications utilizing ASP.NET Core, Visual Studio (2019 or later), Azure DevOps and Azure PaaS technologies. Must have experience utilizing Sql Server (2017 or later) to create enterprise application online transactional database (OLTP) data stores.  Key Person will need experience in constructing and maintaining information technology documentation including but not limited to the following: technical specifications, data models, system overviews, and user guides.

This resulting application captures and track ODHS’ JOBS program outcome indicators utilizing input from community partners and internal staff as collected from Oregonians utilizing related state services. Key Person will work directly with technology staff and program area staff and must possess the ability to develop a strategic roadmap to execute data modernization efforts.

Scope:

The JOBS Outcome Indicators (JOI) application is a web-based system developed to collect and manage data from contract vendors related to services provided to program participants.  It currently contains a number of bugs, and there remains some data source validation work to be completed. This project seeks to correct those bugs and remediate any data source issues.

The current web-based application needs the following support:

                           a.          Correct errors in the creation and management of Services and related attributes.

                           b.          Correct errors in the creation and management of Contractors and their personnel.

                           c.          Correct errors in the creation and management of Contracts and Contract Iterations which define what Services will be offered by a Contractor.

                           d.          Correct errors in the creation and management of Service measure elements, called Indicators.

                           e.          Correct errors in the search, addition, and management of Case Participants, those receiving Services determined by a Referral.

                            f.          Correct errors in the creation and management of Referrals, which tie a Contract (Service governor) to Case Participants.

                           g.          Correct errors in the search and assignment of Participants to a Referral.

                           h.          Correct errors in the creation and management of Indicator Questions used to collect data on Services provided to Participants.

                            i.          Correct errors in the creation and management of Referral Activities, actions performed by system users during a Referral lifecycle.

                            j.          Correct errors in the creation and management of Services Activities, actions performed by a system user during a Service lifecycle.

                           k.          Correct errors in application security based on system user role.

                            l.          Correct errors in landing page UI elements determined by system user role.

Tasks:

The Key Person under this WOC will develop, test, implement and document the application software as requested by the stakeholders and business process owners using an Agile SCRUM development methodology.

Contractor’s Key Person shall:

• Conduct business analysis and research in collaboration with Information Technology and Business staff on application software to be developed.
• Collaborate on and document the development of specifications for objects and code to be used in development.
• Design, develop, and publish the application software from the conceptual process, data, and technical requirements.
• Create, implement, and document all unit testing for application software.
• Create and implement Azure Dev Ops processes for automated CI/CD for the application software.
• Ensure the software application provides the requested authentication and authorization functionality using both application-based and Azure Active Directory-based components.
• Host the application using Microsoft’s Azure PaaS platform.
• Assist Information Technology and Business staff in testing and training end-users of developed application software.
• Documents all aspects of the system application development including but not limited to technical specifications, system overview, data models, user guides, and others are requested.

The schedule for completing the work is dependent on the business and other project work. The Services will be completed using an Agile approach.

Sprints will be completed by the Key Person as follows:

• Participate in daily and weekly sprint planning and review meetings with Authorized Purchaser’s Solution Development and Delivery (SDD) and Self-Sufficiency Programs (SSP) Employment and Training (E&T) teams.  The design, development and unit testing currently identified for completion as part of the Services has been documented in the ADOS Sprint Backlog.
• Provide feedback and input on the Project release schedules, including identifying and recommending incremental delivery of work for the JOI development project to be completed in a specific sprint.
• Provide updates to current Tasks and action items, upcoming tasks and action items, and plan work for the current and upcoming sprints.
• Demonstrate understanding of requirements using incremental functional prototypes and receiving and documenting feedback from business and technical stakeholders.
• Review any additions / modifications to requirements and determine impact to FTSD and timelines. Communicate impact to product owner and technical manager.
• Document Services completed under this Task in the relevant Sprint Report Package.
• Keep members of the Project apprised of sprint status via daily updates within Daily Scrum meetings and within the ADOS tracking system as needed.
• Document each product increment delivery timeline and align with product feature release schedules.
• Coordinate review and ensure updates of product delivery schedule are agreed upon by Product Owner and OIS technical manager

General Deliverables cadence:

• Daily updates within Scrum meetings and ADOS tracking system
• Daily and weekly sprint planning and review tasks
• Sprint Report Package delivery, expected to be 1 per calendar month, within 5 business days of the first business day of each month

·    Required skills and experience:

• Transact-SQL – Advanced skill (7-9 years experience)
• Data Analysis – Advanced skill (7-9 years experience)
• DHTML – Advanced skill (7-9 years experience)
• CSS – Advanced skill (7-9 years experience)
• XML – Advanced skill (7-9 years experience)
• SQL Server 2017 (or later) - Advanced skill (7-9 years experience)
• Windows 9x/2000/XP/NT/Vista/7 – Advanced skill (7-9 years experience)
• IIS – Advanced skill (7-9 years experience)
• Microsoft Internet Information Server (IIS) – Advanced skill (7-9 years experience)
• Design patterns – Advanced skill (7-9 years experience)
• Azure PaaS for cloud hosting of application and database components - Advanced skill required (7-9 years experience)
• Azure Dev Ops for CI/CD - Advanced skill required (7-9 years experience)
• Unit testing using xUnit - Advanced skill required (7-9 years experience)
• Agile SCRUM Development - Advanced skill required (7-9 years experience)
• ASP – Expert skill (10+ years experience)
• Microsoft .NET Framework – Expert skill (10+ years experience)
• MVC – Expert skill (10+ years experience)
• Microsoft SQL Server – Expert skill (10+ years experience)
• AJAX – Expert skill (10+ years experience)
• HTML DOM – Expert skill (10+ years experience)
• JSON – Expert skill (10+ years experience)
• C# in ASP.NET Core using Visual Studio (2019 or later) – Expert skill (10+ years experience)
• HTML – Expert skill (10+ years experience)
• JavaScript – Expert skill (10+ years experience)
• Microsoft Visual Studio .NET – Expert skill (10+ years experience)
• IBM DB2 UDB – Proficient skill (4-6 years experience)
• DB2 – Proficient skill (4-6 years experience)
• TCP/IP – Proficient skill (4-6 years experience)
• Communication skills both verbal and written – Proficient skill (4-6 years experience)
• Azure Active Directory authentication and authorization – Proficient skill (4-6 years experience)
• Microsoft Office – Proficient skill (4-6 years experience)

Preferred skills and experience: 

• XMLDOM – Advanced skill desired (7-9 years experience)
• XML Schema – Advanced skill desired (7-9 years experience)
• XHTML– Advanced skill desired (7-9 years experience)
• XSL– Advanced skill desired (7-9 years experience)
• XSLT– Advanced skill desired (7-9 years experience)
• Apache – Proficient skill desired (4-6 years experience)
• SOAP  – Proficient skill desired (4-6 years experience)
• Service oriented architecture (SOA) – Proficient skill desired (4-6 years experience)
• Microsoft Access  – Proficient skill desired (4-6 years experience)
• Oracle  – Proficient skill desired (4-6 years experience)
• ADO.NET – Proficient skill desired (4-6 years experience)
• Microsoft Exchange Server – Proficient skill desired (4-6 years experience)
• VisualBasic/NET – Proficient skill desired (4-6 years experience)
• WSDL – Proficient skill desired (4-6 years experience)
• XQuery – Proficient skill desired (4-6 years experience)
• VBScript – Proficient skill desired (4-6 years experience)
• Language - C – Proficient skill desired (4-6 years experience)
• Shell – Proficient skill desired (4-6 years experience)
• Backup and recovery – Proficient skill desired (4-6 years experience)
• IBM WebSphere – Proficient skill desired (4-6 years experience)
• State of Oregon government agency processes desired
• Experience working directly with stakeholders and product owners desired