Data Analyst

If shortlisted, would you be able to attend an in-person interview within the next 7 10 days.

Data Analyst

Location: Raleigh NC (Hybrid)

Duration: 12 months

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:
5 years of experience in Power BI development (dashboards, reports, automated refreshes)
5 years of experience in Data ingestion, cleaning, and validation
5 years of experience in Data quality assurance and accuracy checking
5 years of experience in Maintaining data dictionaries, metadata, and documentation
5 years of experience in 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