Position Description:
Position Title - Data Analyst
Job Location - Raleigh, NC, USA
Bill Rate Range - $35/hr
Estimated Duration (In Months) - 13
Work Model - Hybrid
Must have Skills/Attributes - Data Governance, Documentation, Metadata, PowerBI, Quality Assurance
Shift - Monday through Friday 8 to 5
Note: An in-person interview is required. Local candidates only. Candidates must have experience in the Healthcare/Medicaid domain, along with 5+ years of experience as a Data Analyst and/or Business Intelligence Analyst, and Advanced expertise in Power BI dashboard design, development, and reporting.
Required Skills:
• Power BI development (dashboards, reports, automated refreshes) (5 Years)
• Data ingestion, cleaning, and validation (5 Years)
• Data quality assurance and accuracy checking (5 Years)
• Maintaining data dictionaries, metadata, and documentation (5 Years)
• Data governance, confidentiality, and compliance (HIPAA, trade secret rules) (5 Years)
• Monitoring submission activity and compliance metric (5 Years)
• Trend analysis for pricing, cost drivers, and submission patterns (5 Years)
• Creating visualizations, analytic summaries, and automated reporting (5 Years)
• Knowledge of data integrity, security standards, and regulatory requirements (5 Years)
• Collaboration with IT, Legal, and program teams (3 Years)
• Optimizing workflows and data pipelines (5 Years)
• Strong written documentation skills (5 Years)
• Supporting policy analysis and ad hoc requests (3 Years)
Job Duties:
• 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