NCDHHS-802497 DHHS Data Analyst

Complete Description:

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 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