Data and Technical Lead (Analytics) Responsible for all Covered California data requirements for analytics and reporting including those that exceed the standard reporting package and the information available through the decision support tool provided by the Vendor Establish the principles by which data analytics activities will be executed, and define the goals, objectives and standards of the organization's analytics approach and architecture Employ advanced information analytics practices to Covered California requirements Apply multiple solutions and approaches to business problems Provide input on analytics prioritization and support Covered California’s Enterprise Analytics governance process Work with Covered California stakeholders and provide guidance on possible analytic approaches leading to proposals to develop and implement analytics applications and tools Track analytic tools and models deployed elsewhere in support of analytic guidance efforts Provide tailored training and project involvement for Covered California analytics (approximately 5-8 staff). Support of any audit made of the data, analyses or methodologies, as requested by Covered California Deep familiarity with Vendor’s analytical models, tools, and technology Experience with Healthcare analytical models required by Covered California and related data sources Minimum of five (5) years of deep information and data architecture and management experience for a government or private sector healthcare payer or provider, including a minimum of three (3) years of experience in a project similar in scope and size to that of Covered California Possesses interpersonal skills, including teamwork, facilitation, and negotiation skills and experience Excellent analytical and technical skills including but not limited to, translation of business questions and requirements into reports, views, and BI query objects; knowledge of BI tool architectures, functions, and features; understanding of SQL and relational and multidimensional designs; strong problem-solving and metadata skills; and understands BI tool architecture, functions, features and customizes BI tools to meet user needs Deep experience with advanced modeling approaches, tools, and model repositories. Ability to rapidly comprehend the functions and capabilities of new technologies.
Analytic Staff Define process for the development, production and delivery of standard and ad hoc reports (purpose, audience, content, data sources, frequency, etc.) Define and document Client’s reporting needs – categorize the standard versus ad hoc reports Conduct exploratory analyses in support of analytic requirements Produce standard and ad hoc reports Perform report quality assurance to ensure analytic integrity/identify anomalies Documentation, and ongoing maintenance of the processes, methodologies, algorithms, etc., employed during the analytics Additional Specific To Ad Hoc Reporting Analyze results and write interpretation Present the reports and results interpretation to Client Respond to Client questions and iterative analyses needs Deep familiarity with Vendor’s analytical models, tools, and technology Experience with Healthcare analytical models required by Covered California and related data sources Minimum of three (3) years of deep information and data architecture and management experience for a government or private sector healthcare payer or provider, including a minimum of two (2) years of experience in a project similar in scope and size to that of Covered California Possesses interpersonal skills, including teamwork, facilitation, and negotiation skills and experience Excellent analytical and technical skills including but not limited to, translation of business questions and requirements into reports, views, and BI query objects; knowledge of BI tool architectures, functions, and features; understanding of SQL and relational and multidimensional designs; strong problem-solving and metadata skills; and understands BI tool architecture, functions, features and customizes BI tools to meet user needs Deep experience with advanced modeling approaches, tools, and model repositories. Ability to rapidly comprehend the functions and capabilities of new technologies. Location of Contracted Functions and Personnel The Vendor Key Project Personnel must be available to participate in-person during Covered California-related meetings and activities and must be located at Vendor offices located in California. Regardless of California location of vendor offices, Key Project Personnel must be capable of meeting in the Covered California offices in Sacramento regularly and frequently on short notice (one (1) business day or less). Covered California will not necessarily provide facilities for Vendor Key Project Personnel to perform daily work at Covered California, but this will be determined in partnership with the selected vendor. Work must be performed during normal business hours, 8:00 AM until 5:00 PM Pacific Time, Monday through Friday except any federal and state holidays. Covered California will not permit project work or business operations services to be performed offshore (i.e., outside of Continental United States). At no time shall the
Vendor maintain, use, transmit, or cause to be transmitted information governed by privacy laws and regulations outside the United States and its territories Covered California and the Vendor will establish appropriate protocols to ensure that physical property / facility security and data confidentiality safeguards are maintained. Proposed Project Schedule Covered California anticipates the awarded Vendor to begin implementation of the project, configuring their technology and operations, by September, 2014. Scope of Work - Deliverables The following lists captures the deliverables Covered California expects the Vendor to produce during the implementation phase and after the system and processes are operational. Recurring Project Deliverables The following table provides a list of recurring deliverables that will be created by the Vendor during the life cycle of the project execution. Recurring Deliverables Task Deliverable Task R.1 — Project Monitoring and Status Reporting Deliverable 1 — Project Status Reporting (Recurring throughout the length of the project) Implementation Related Deliverables The following provides a list of deliverables that will be created by the Vendor during implementation. Covered California encourages responders to use industry best practices for project management and describe their recommended approach. Implementation Related Deliverables Task Deliverable Task I.1 — Project Initiation and Planning Deliverable 2 — Project Kick-off Presentation Deliverable 3 — Project Management Plan Deliverable 4 — Project Work Plan and Schedule Deliverable 5 — Monthly Project Status Reports Task I.2 — Requirements Validation Deliverable 6 — Requirements Methodology and Template Deliverable 7 — Detailed and Non-Functional Requirements Traceability Matrices Deliverable 8 – Development Standards, Project Standards and Reporting Strategy Task I.3 — System Design Deliverable 9 — Configuration Design Document Deliverable 10 – Business Intelligence/Analytics security – User-> Role Report -> Data field mapping
Deliverable 11 Technical Architecture Deliverable 12 — Data Integration and Interface Design Document Task I.4 — Configuration and Development Deliverable 13 — Client Review of Configuration Deliverable 14 — Unit/Assembly Testing Scripts and Results Deliverable 15 — Final Test Plan Task I.5 — Testing Deliverable 16 — Documented System Test Results Deliverable 17 — User Acceptance Task I.6 — Training Deliverable 18 — Training Plan Deliverable 19 — Training Materials Deliverable 20 — Documented Evidence of Successful End-User Training Task I.7 — Deployment Deliverable 21 — Deployment Plan Deliverable 22 — System Documentation Deliverable 23 — Performance SLAs Deliverable 24 — Rollout Production Task Related Deliverables – Data Aggregation The following table provides a list of deliverables that will be created by the Vendor during the production phase. Task Production Related Deliverables – Data Aggregation Task Deliverable Task P.1 – Data Submission Planning and Preparation Deliverable P.1 – Detailed data submission technical specifications Deliverable P.2 – Documentation of ETL processing methodology(ies), algorithms, report queries, etc. Deliverable P.3 –Methodology and algorithms documentation completion for i) master patient identifier, unduplicated across Issuers and other data suppliers, ii) integration and setup of consolidated all-QHP provider directory, iii) construction of master enrollment dataset per merging of Covered California and QHP enrollment data Deliverable P.4 – Interface and/or data extracts completion of documentation Deliverable P. 5 – Documentation of transition plan outlining methodology to transfer tools and knowledge to the State six (6) months prior to end of term or other date as requested by Covered California. Task P.2 – Data Collection and Quality Control Deliverable P.6 – Issuers Data Use Agreements and Business Associate Agreements Executed. Data Submission Request to Issuers Deliverable P.7 – Covered California Data Use Agreement Executed. Data Submission Request to Covered California (CalHEERs etc.) Deliverable P.8– Data quality reports for each submitter and interfaced system