Data Analyst

Position Description:Department of Health & Human Services is seeking a SCRIPT Data AnalystThe 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 requestsThe 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 requestsSkills Table:SkillRequired / DesiredAmountof ExperiencePower BI development (dashboards, reports, automated refreshes)Required5YearsData ingestion, cleaning, and validationRequired5YearsData quality assurance and accuracy checkingRequired5YearsMaintaining data dictionaries, metadata, and documentationRequired5YearsData governance, confidentiality, and compliance (HIPAA, trade secret rules)Required5YearsMonitoring submission activity and compliance metricRequired5YearsTrend analysis for pricing, cost drivers, and submission patternsRequired5YearsCreating visualizations, analytic summaries, and automated reportingRequired5YearsKnowledge of data integrity, security standards, and regulatory requirementsRequired5YearsCollaboration with IT, Legal, and program teamsRequired3YearsOptimizing workflows and data pipelinesRequired5YearsStrong written documentation skillsRequired5YearsSupporting policy analysis and ad hoc requestsRequired3YearsQuestion 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?