2024 Data Management Systems Support, Development, Analytics, and Reporting

Deadline for written questions: 5.27.2024
Deadline for submission of proposals: 6.24.2024

The Pacific States Marine Fisheries Commission (PSMFC) maintains multiple databases that integrate and consolidate fisheries-dependent and independent data from various state and federal agencies, as well as other data sources, to support fisheries management goals and objectives in Alaska, the West Coast, and the Pacific Islands. PSMFC programs associated with these databases include the four Fisheries Information Networks (FIN), namely the Alaska Fisheries Information Network (AKFIN), Pacific Fisheries Information Network (PacFIN), Western Pacific Fisheries Information Network (WPacFIN) and Pacific Coast Recreational Fisheries Information Network (RecFIN). The information within these databases are used extensively by fishery managers, analysts, and scientists to assess existing management policies, as well as to promote the advancement of new policies to manage the public's fishery resources.

Pacific States Marine Fisheries Commission is seeking to subcontract with an information technology company to assist with data management systems support, development, analytics, and reporting. The primary areas of work include:

Database support and development: Develop, maintain, and update relational Oracle databases, including database objects, schemas, and scripted procedures. In addition, monitor automated Extract, Transform, Load (ETL) processes and conduct and create routines for data quality assurance/quality control (QA/QC).

API and web services: Develop, maintain, and update Rest API tools.

Web application support and development: Develop, maintain, and update public and private reports, as well as secure online data query tools. Functionality includes the ability of authorized users to filter and download a variety of reports or data outputs. These Oracle APEX applications and products need to meet data user needs with ongoing technical support to ensure the functionality of all reports, graphics, and related products.

Data analytics: Develop, maintain, and update data processes and products for spatial and artificial intelligence (AI) initiatives in Python, such as data mining, computer vision, natural language processing, and predictive analytics.

Client support: Provide ongoing technical support to FIN programs, web application users, and data users; ensure all tools remain operational and data integrity is maintained; and address critical technical issues rapidly and efficiently; coordinate with FIN staff, data users, and agency staff to determine reporting needs, translate needs into business rules/report logic, design and create online reports, demo reports and products during development, and work with users to alter the reports as additional needs arise; develop detailed documentation of analysis creation, updates and user guides.

The initial contract period for the vendor selected from this RFP will be for one year, with possibility of extension for up to five years.

Posted: 5.8.2024

Download the full Request for Proposals

May. 8, 2024