Specifications include, but are not limited to: A. The Contractor will partner with King County to acquire healthcare benefit eligibility, claims, and selected administrative data from multiple sources, create a data warehouse infrastructure to integrate the data, provide a set of standard reports, and provide role-based access to the data to a limited set of users through a web-based portal. B. The Contractor should have relevant experience providing health claims data warehousing and analytic services to organizations of similar size and scope; deep knowledge and expertise in health care analytics with a track record of supporting clients’ business needs; access to relevant methodologies, such as groupers, predictive analytics, and extent of low value care; availability of robust benchmarks for comparison; and an exceptional level of data security and privacy controls. C. Contractor shall provide the following services in the following five areas: 1. Obtain, validate, integrate, and house benefit eligibility, claims, and selected administrative data (see table below for expected data sources). a. Manage data integration from multiple sources on a quarterly basis b. Migrate 3 years of historical data from existing King County claims database c. Clean feeds to ensure consistency and accuracy d. Combine data for a single member provided by different sources 2. Analysis and reporting: provide a preconfigured set of reports and dashboards that are responsive to the County’s priority use cases in a user-friendly, web-based format, and that can be exported/downloaded for sharing. Examples include demographics, cost driver analyses, expense and utilization information against benchmarks, potential saving opportunities, low value care, care gaps, HEDIS measure results. Vendor must have ability to adjust for risk as appropriate. Also provide ad hoc consultation and analysis services (e.g., modeling new benefits). 3. Web-based portal access: provide role-based access to reports, dashboards, and the ability to self-run queries via a secure web portal with a simple user interface, within the context of appropriate security and privacy safeguards. Provide flexible platform that allows ability to filter and drill down, visualize data over time and against benchmarks, and export data. Dashboards and reports must be downloadable into Microsoft Excel. 4. Privacy and security: maintain compliance with HIPPA Privacy Rule (45 CFR part 160 and part 164, subparts A and E), and the Security Rule, and the HITECH Act. Appropriate physical, technical, and administrative security policies, procedures, and practices must be in place to safeguard confidentiality, integrity, and availability of the protected health information that is created, received, maintained, and transmitted. The selected data services vendor will be required to enter into a Business Associate Agreement. 5. Project management and customer service support: Provide a high level of customer support through a collaborative relationship with King County throughout all phases, including implementation and testing, training and documentation, problem resolution, special consultations and analyses, and ongoing customer support.