Data Analyst

SCRIPT Data AnalystDepartment of Health & Human Services is seeking a SCRIPT Data Analyst. The SCRIPT Act Data Analyst will:Ingest, clean, and validate manufacturer price increase notices, new drug submissions, and other required data ensuring accuracy and completeness.Maintain and version the metric dictionary and annual report metric definitions.Develop, maintain, and refresh Power BI dashboards for both the public transparency portal and internal oversight/monitoring.Ensure strict confidentiality and data governance compliance, including trade secret protections and coordination with Legal/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 validationData quality assurance and accuracy checkingMaintaining data dictionaries, metadata, and documentationData governance, confidentiality, and compliance (HIPAA, trade secret rules)Monitoring submission activity and compliance metricsTrend analysis for pricing, cost drivers, and submission patternsCreating visualizations, analytic summaries, and automated reportingKnowledge of data integrity, security standards, and regulatory requirementsCollaboration with IT, Legal, and program teamsOptimizing workflows and data pipelinesStrong written documentation skillsSupporting policy analysis and ad hoc requestsRequired/Desired SkillsSkill - Required/Desired - Amount - of ExperiencePower BI development (dashboards, reports, automated refreshes) - Required - 5 YearsData ingestion, cleaning, and validation - Required - 5 YearsData quality assurance and accuracy checking - Required - 5 YearsMaintaining data dictionaries, metadata, and documentation - Required - 5 YearsData governance, confidentiality, and compliance (HIPAA, trade secret rules) - Required - 5 YearsMonitoring submission activity and compliance metric - Required - 5 YearsTrend analysis for pricing, cost drivers, and submission patterns - Required - 5 YearsCreating visualizations, analytic summaries, and automated reporting - Required - 5 YearsKnowledge of data integrity, security standards, and regulatory requirements - Required - 5 YearsCollaboration with IT, Legal, and program teams - Required - 3 YearsOptimizing workflows and data pipelines - Required - 5 YearsStrong written documentation skills - Required - 5 YearsSupporting policy analysis and ad hoc requests - Required - 3 Years