The SCRIPT Act Data Analyst will:
Ingest, clean, and validate manufacturer price increasenotices, new drug submissions, and other required data ensuring accuracy andcompleteness.
Maintain and version the metric dictionary and annualreport metric definitions.
Develop, maintain, and refresh Power BI dashboards forboth the public transparency portal and internal oversight/monitoring.
Ensure strict confidentiality and data governancecompliance, including trade secret protections and coordination withLegal/Privacy.
Monitor submission activity and compliance metrics,providing internal dashboards and automated reporting to support program operations.
Analyze trends in drug pricing, cost drivers, submission patterns, and non compliance risks to support program and policy decision making.
Develop automated visualizations, reports, and analytic summaries for leadership, program managers, and external inquiries.
Ensure data integrity, security, and regulatory compliance under state and federal requirements (e.g., HIPAA, trade secret statutes).
Collaborate with IT, Legal, and program teams to optimize data pipelines, workflows, and portal functionality.
Create and maintain documentation, metadata, and governance standards to support the transparency program.
Provide ad hoc analytical support for policy development, legislative requests, and external stakeholders.
The SCRIPT Act Data Analyst will:
Ingest, clean, and validate manufacturer price increasenotices, new drug submissions, and other required data ensuring accuracy andcompleteness.
Maintain and version the metric dictionary and annualreport metric definitions.
Develop, maintain, and refresh Power BI dashboards forboth the public transparency portal and internal oversight/monitoring.
Ensure strict confidentiality and data governancecompliance, including trade secret protections and coordination withLegal/Privacy.
Monitor submission activity and compliance metrics,providing internal dashboards and automated reporting to support program operations.
Analyze trends in drug pricing, cost drivers, submission patterns, and non compliance risks to support program and policy decision making.
Develop automated visualizations, reports, and analytic summaries for leadership, program managers, and external inquiries.
Ensure data integrity, security, and regulatory compliance under state and federal requirements (e.g., HIPAA, trade secret statutes).
Collaborate with IT, Legal, and program teams to optimize data pipelines, workflows, and portal functionality.
Create and maintain documentation, metadata, and governance standards to support the transparency program.
Provide ad hoc analytical support for policy development, legislative requests, and external stakeholders.
| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Power BI development (dashboards, reports, automated refreshes) | Required | 5 | Years |
| Data ingestion, cleaning, and validation | Required | 5 | Years |
| Data quality assurance and accuracy checking | Required | 5 | Years |
| Maintaining data dictionaries, metadata, and documentation | Required | 5 | Years |
| Data governance, confidentiality, and compliance (HIPAA, trade secret rules) | Required | 5 | Years |
| Monitoring submission activity and compliance metric | Required | 5 | Years |
| Trend analysis for pricing, cost drivers, and submission patterns | Required | 5 | Years |
| Creating visualizations, analytic summaries, and automated reporting | Required | 5 | Years |
| Knowledge of data integrity, security standards, and regulatory requirements | Required | 5 | Years |
| Collaboration with IT, Legal, and program teams | Required | 3 | Years |
| Optimizing workflows and data pipelines | Required | 5 | Years |
| Strong written documentation skills | Required | 5 | Years |
| Supporting policy analysis and ad hoc requests | Required | 3 | Years |
| 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 agree to this requirement? |
| Question2 | Hybrid expectation is 2 days/week ONSITE. Do you agree to this requirement? |
| Question3 | Your candidate must be able to attend an in-person interview. Do you agree to this requirement? |
| Question4 | What is your candidate's email address? |
| Question5 | How soon can your candidate start if selected for this opportunity? |
| Question6 | Vendors are encouraged to submit candidates that are available for the duration of the assignment. Do you anticipate your candidate being able to work until the proposed end date listed on this VectorVMS req? |
| Question7 | Vendors must disclose to the agency if the candidate will be subcontracted at the time of submission. Is your candidate an employee of your company or a subcontractor? Please be sure to notify a CAI Account Manager if your candidate's employee status changes. |
| Question8 | Vendors must notify the agency if any portion of the requirements listed in this task order will be outsourced to other countries. Do you anticipate outsourcing any work being done for this assignment to another country? |
| Question9 | Candidates submitted above the hourly Vendor Rate of $$$ may not be considered for this assignment. Do you agree to this requirement? |
| Question10 | Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the Vendor to adhere to any applicable compensation laws including payment for overtime hours. Do you agree to this requirement? |
| Question11 | Have you thoroughly validated, and attest to the accuracy of, the credentials listed throughout your candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440? |