Data Analyst

Position Description:
Department of Health & Human Services is seeking a SCRIPT Data Analyst

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.

Job requirements include experience in the following:
Power BI development (dashboards, reports, automated refreshes)
• Data ingestion, cleaning, and validation
• Data quality assurance and accuracy checking
• Maintaining data dictionaries, metadata, and documentation
• Data governance, confidentiality, and compliance (HIPAA, trade secret rules)
• Monitoring submission activity and compliance metrics
• Trend analysis for pricing, cost drivers, and submission patterns
• Creating visualizations, analytic summaries, and automated reporting
• Knowledge of data integrity, security standards, and regulatory requirements
• Collaboration with IT, Legal, and program teams
• Optimizing workflows and data pipelines
• Strong written documentation skills
• Supporting policy analysis and ad hoc requests
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.

Job requirements include experience in the following:
Power BI development (dashboards, reports, automated refreshes)
• Data ingestion, cleaning, and validation
• Data quality assurance and accuracy checking
• Maintaining data dictionaries, metadata, and documentation
• Data governance, confidentiality, and compliance (HIPAA, trade secret rules)
• Monitoring submission activity and compliance metrics
• Trend analysis for pricing, cost drivers, and submission patterns
• Creating visualizations, analytic summaries, and automated reporting
• Knowledge of data integrity, security standards, and regulatory requirements
• Collaboration with IT, Legal, and program teams
• Optimizing workflows and data pipelines
• Strong written documentation skills
• Supporting policy analysis and ad hoc requests

Skills Table:
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

Question 
Hybrid expectation is 2 days/week ONSITE.  Do you agree to this requirement?

Question 
Your candidate must be able to attend an in-person interview.  Do you agree to this requirement?