Data Analyst

JOB DESCRIPTION | Data Analyst

Job Title: Data Analyst

Location: Raleigh, NC

Duration: 13 months

Must-Have Skills

·        Data Governance

·        Documentation

·        Metadata

·        PowerBI

·        Quality Assurance

Client Notes

An in-person interview is required. Please submit 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