Description

Amended 11/12/20 to add Sample BAA.This is a Request for Intermediate Proposals (RIP) used when County expenditure will be less than $150,000 for the initial term of the resulting contract.PRE-PROPOSAL CONFERENCE:There will not be a pre-proposal conference for this sourcing event.INTRODUCTION AND BACKGROUND:Multnomah County spends significant support costs for data mart load job failures due to multiple reasons: bad data, data type changes, other source file changes, systems down, permission, access/security.  Further we have difficulty recovering from failures due to incomplete auditing, logging and debugging capabilities. In addition we spend significant development time costs for extract and load development activities.The goal with this procurement is to determine if there is a tool where Multnomah County could spend significantly less resources (over existing tools) building and supporting SQL Database staging loads and extractions.CURRENT SERVICES/SOLUTION:Not applicable to this sourcing event. MULTNOMAH COUNTY TECHNICAL ENVIRONMENTNot applicable to this sourcing event.FUNDINGAdequate funding has been budgeted for the purchase of these services.SOLUTION REQUIREMENTS/SCOPE OF WORKMultnomah County is seeking ETL tools that meet the following requirements:●     Cloud based tool.●     HIPAA Compliant and willing to sign a BAA.●     Support for CSV, JSON, Rest based APIs, relational databases, google sheets data sources.●     Automation of recovery of outages or interruptions (picking up where it left off).●     Automation of unexpected data values (i.e. we were expecting a number and a string is sent in next load).●     Automation of unexpected source structure changes.●     Speed to implement new ETL or changes (No or low code) -also code aligns with County existing skills.●     Ability to troubleshoot problems easily (logs, monitoring, debugging).●     Supports incremental loads and history tracking without writing code.●     DevOps integration with our existing tools as appropriate (Source Code Control, integration api, Azure DevOps).●     Must include some kind of job scheduler.●     Built in API integration - for use with a data governance platform like Collibrar for data dictionary information.●     Self generating support documentation from the tool.●     Migration tool for SSIS and T-SQL to the new tool.●     Consumption based pricing.●     CJIS Compliance.PRE-AWARD RISK ASSESSMENTSuccessful proposers whose contract award includes federal funding (as identified by a Catalog of Federal Domestic Assistance number) will be subject to a PreAward Risk Assessment (which includes an evaluation of financial stability, quality of financial /management systems, experience with federal funds, reports and findings from audits) completed by Multnomah County (if one has not been submitted in the last year) prior to the issuance of a contract. Contractors who fail to submit the required documents will not be eligible for a contract from the County.MINIMUM PROPOSAL SUBMITTAL REQUIREMENTSTimely submission of responsive, responsible offers is the only minimum requirement for this sourcing event.FISCAL REQUIREMENTS AND REPORTINGNot applicable to this sourcing event.PERFORMANCE MEASURES/PERFORMANCE CONTRACTINGNot applicable to this sourcing eventCONTRACT NEGOTIATIONThe County will initiate contract negotiations with the responsive and responsible Supplier with the highest scoring proposal. Multnomah County may, at its option, elect to negotiate general contract terms and conditions, services, pricing, implementation schedules, and such other terms as the County determines are in the County’s best interest. If negotiations fail to result in a contract, the County reserves the right to terminate the negotiations and initiate contract negotiations with the next highest scoring responsive and responsible Supplier. This process may continue until a contract agreement is reached.  Multnomah County reserves the right to score the acceptance of its standard contract terms and conditions as a part of this sourcing event.CONTRACT AWARDCounty is seeking to award one contract through this sourcing event.  Award, as determined by the County, will be made to the responsible Supplier whose Proposal the County determines is most advantageous to the County based on the evaluation process and evaluation factors described in this sourcing event. Multnomah County strongly encourages the participation of Minority-Owned, Women-Owned, and Emerging Small Businesses and Organizations in providing these services.CONTRACT TERMThe contract term will be negotiated at time of contract award and will be dependent upon the product and/or services provided. The Negotiated contract term will be in compliance with all public procurement laws and Multnomah County PCRB public contracting rules.COMPENSATION AND METHOD OF PAYMENTCompensation method for implementation services and hardware: deliverables-based payments upon acceptance with a not to exceed cap.Compensation method for ongoing services, software maintenance and support or subscriptions, etc. will be subject to negotiation once the County has selected a Supplier.INSURANCE REQUIREMENTSThe Supplier awarded a Contract as a result of this sourcing event will be required to provide at a minimum the insurance outlined in the table below. The type of insurance required will depend on the type of services and or products provided under the contract which will be negotiated during the contract process. Type of Insurance Per Occurrence Aggregate Professional Liability $1,000,000 $2,000,000 Commercial General Liability $1,000,000 $2,000,000 Cyber Liability (only if Software as a Service) $5,000,000 $10,000,000 Workers Compensation Required  MULTI-STAGE SOURCING EVENT SUMMARYMultnomah County will follow a multi-stage sourcing event that incorporates the following potential steps in the Multco Marketplace Supplier Portal:●     Panel Questionnaire Solution and Supplier Research (Unscored)●     Autoscored Supplier Qualification based on Solution Requirements●     Scripted Remote Demo●     Site Visit(s)●     Panel Questionnaire Proposal Solution Requirements●     Panel Questionnaire Proposal Doing Business with Multnomah County●     Oral Evaluation●     Pricing Evaluation●     Best and Final Offer (BAFO)The purpose of a multistage process is to identify and adjust the competitive range between proposed solutions based on the evaluation of each stage with the goal of identifying the most advantageous solution at the conclusion of the process. The first stage for this Sourcing Event will be an Autoscored Supplier Qualification based on Solution Requirements. The follow-on stages will be determined based on the results of the first stage.Multnomah County reserves its right, at its sole discretion, to modify, combine, adjust, re-order, repeat, re-schedule or cancel individual steps by written notification to all affected parties.  Multnomah County may, at its sole discretion, make an award at such time as the most advantageous solution for the County has been identified through this competitive process.EVALUATION PROCESS AND CRITERIAProposed solutions will be evaluated using a combination of auto-scoring and scoring by an evaluation panel depending on the stage.  Scores of each stage will be added together for a total score for all stages excluding BAFO.  If the County uses an optional BAFO process, prior scores will be considered but a new score will be determined based on evaluation of Best and Final Offers.Multnomah County is seeking a solution and/or services that meets or exceeds its identified requirements based on the judgment of the evaluators and the score of the supplier’s offer determined by this process, at a cost that is deemed by evaluators to be reasonable, responsible and optimal for purchase with public dollars.DETERMINATION OF COMPETITIVE RANGEMultnomah County will determine Competitive Range based on a natural break in scores for those proposers that are determined to be closely competitive and have a reasonable chance to be the Most Advantageous Proposer. At the conclusion of each stage, all proposers will receive notification of which Proposers have been determined to comprise Competitive Range.  Proposers determined to be within the Competitive Range will continue to the next stage unless the County chooses to make an award.

Attachments

This project has the following solicitation documents. You will need to visit the agency's original website to download these documents.

For Questions or Additional Information, Contact:

No contact listed