Data Analyst :: Raleigh, NC (Hybrid)

Data AnalystLocation: Raleigh, NC (Hybrid)Duration: 12 MonthsResponsibility: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.Experience:Power BI development (dashboards, reports, automated refreshes) - 5 YearsData ingestion, cleaning, and validation - 5 YearsData quality assurance and accuracy checking - 5 YearsMaintaining data dictionaries, metadata, and documentation - 5 YearsData governance, confidentiality, and compliance (HIPAA, trade secret rules) - 5 YearsMonitoring submission activity and compliance metrics - 5 YearsTrend analysis for pricing, cost drivers, and submission patterns - 5 YearsCreating visualizations, analytic summaries, and automated reporting - 5 YearsKnowledge of data integrity, security standards, and regulatory requirements - 5 YearsCollaboration with IT, Legal, and program teams - 3 YearsOptimizing workflows and data pipelines - 5 YearsStrong written documentation skills - 5 YearsSupporting policy analysis and ad hoc requests - 3 Years