| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Expert knowledge of SAS tools, SAS MACROS, Enterprise Guide, Design Studio. | Required | 7 | Years |
| Expert Cognos and SQL experience including table joins to extract data in a normalized data warehouse. | Required | 7 | Years |
| Expert ability to effectively diagnose, isolate, and resolve complex problems pertaining to data and its infrastructure. | Required | 7 | Years |
| Expert ability to manage client data requests and/or issues; experienced with discerning requirements for analysis, hands-on design, and development. | Required | 7 | Years |
| Desirable to have experience working with Medicaid claims data and information. | Highly desired | 0 | |
| Demonstrated experience with Cognos framework manager, dashboard/report design, and deployment. | Required | 7 | Years |
| Excellent communication and organizational skills. Able to effectively work with broad spectrum of constituents. | Highly desired | 0 | |
| Expertise in Cognos report performance tuning processing terabytes of data | Required | 0 | |
| Demonstrated experience in design & development of advanced drill down reports and dashboards using Cognos Analytics | Required | 0 | |
| Demonstrated experience in architecting efficient Cognos metadata models using Cognos framework manager and Data modules | Required | 0 | |
| Desirable to have experience working with Medicaid claims data and information. | Highly desired | 0 |
| No. | Question |
|---|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? |
| Question2 | All work must be completed on site. Do you accept this requirement? |
| Question3 | Please list candidate's email address HERE that will be used when submitting E-RTR. |
| Question4 | Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. |
| Question5 | Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? |
| Question6 | Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement? |
| Question7 | Candidates submitted above the rate of - may not be considered. Do you accept this requirement? |
| Question8 | Please note that if your candidate is selected for hire, the Iran Divestment Act Certification form must be completed and uploaded to the Compliance tab as a part of the onboarding process. This form must be received within a timely manner (expectation 1 business day). Without this form, the Purchase Order cannot be generated and your candidate cannot begin work. Do you accept this requirement? |
| Question9 | Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm? |