*** Mode of Interview:- WebCam Interview *** Very long term project( initial PO for 1 year, expect to go for 4+ years) ***Hybrid (3days per week Onsite ) at Raleigh-NC***
Short Description:-
The SCRIPT Act Data Analyst /Power BI 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.
Key Job Requirements :-
Experience in the following is required:
- 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
Skills/Requirements
- Power BI development (dashboards, reports, automated refreshes) Required 5 Years
- Data ingestion, cleaning, and validation Required 5 Years
- Data quality assurance and accuracy checking Required 5 Years
- Maintaining data dictionaries, metadata, and documentation Required 5 Years
- Data governance, confidentiality, and compliance (HIPAA, trade secret rules) Required 5 Years
- Monitoring submission activity and compliance metric Required 5 Years
- Trend analysis for pricing, cost drivers, and submission patterns Required 5 Years
- Creating visualizations, analytic summaries, and automated reporting Required 5 Years
- Knowledge of data integrity, security standards, and regulatory requirements Required 5 Years
- Collaboration with IT, Legal, and program teams Required 3 Years
- Optimizing workflows and data pipelines Required 5 Years
- Strong written documentation skills Required 5 Years
- Supporting policy analysis and ad hoc requests Required 3 Years
Never miss an opportunity! Create an alert based on the job you applied for.
