Power BI Data Analyst

Key Responsibilities

• Ingest, clean, validate, and maintain manufacturer price increase notices, new drug submissions, and related datasets.
• Maintain metric dictionaries and annual report metric definitions.
• Develop, maintain, and refresh Power BI dashboards for public transparency portals and internal monitoring.
• Monitor submission activity and compliance metrics through automated reporting and dashboards.
• Analyze trends in drug pricing, cost drivers, submission patterns, and compliance risks.
• Create visualizations, reports, and analytic summaries for leadership and stakeholders.
• Ensure data integrity, security, confidentiality, and compliance with HIPAA and trade secret regulations.
• Collaborate with IT, Legal, and program teams to improve workflows, portals, and data pipelines.
• Maintain documentation, metadata, governance standards, and reporting processes.
• Support policy development, legislative requests, and ad hoc analytical initiatives.

Required Skills & Experience

Skill

Experience

Power BI development (dashboards, reports, automated refreshes)

5 Years

Data ingestion, cleaning, and validation

5 Years

Data quality assurance and accuracy checking

5 Years

Data dictionaries, metadata, and documentation

5 Years

Data governance, confidentiality, and HIPAA compliance

5 Years

Monitoring compliance metrics and submission activity

5 Years

Trend analysis and data analytics

5 Years

Visualizations, reporting, and analytic summaries

5 Years

Data integrity, security standards, and regulatory compliance

5 Years

Workflow optimization and data pipelines

5 Years

Collaboration with IT, Legal, and business teams

3 Years

Policy analysis and ad hoc reporting support

3 Years

Strong written documentation skills

5 Years