Data Analyst - Pharmacy Intern

HealthPlan Data Solutions

HealthPlan Data Solutions

Data Science · Full-time, Intern
Columbus, OH, USA
Posted on Friday, May 19, 2023

The Data Analyst – Pharmacy Intern will be responsible for the review and critical analysis of customer claims data. Using HDS proprietary software tools, the Data Analyst Intern will review claims files, run scans, analyze results produced, create reports, and present findings.

Key Duties and Responsibilities

  • Work with our clients and channel partners to develop effective reporting and needed analytics
  • Compile, analyze, and validate healthcare information using various technology tools and databases to deliver actionable reports
  • Prepare deliverables and dashboards linked to detailed data
  • Perform complex data extractions and manipulations
  • Conceptualize, design, and validate reports to meet routine needs. Ensure the data is methodologically and statistically sound and accurate
  • Work with IT to automate reports.
  • Monitor, analyze & present operational trends and pharmacy drug utilization to develop & suggest strategies to create efficiencies, reduce costs & improve health outcomes
  • Perform any other job-related instructions, as required.
  • Create, maintain, and update portal database tables as assigned

Required Skills, Knowledge, and Attributes

  • Highly developed critical thinking skills
  • Strong organization and prioritization skills
  • Capacity and commitment to learn pharmacy industry concepts and terminology
  • Demonstrated ability to work with both speed and accuracy
  • Highly effective listening and communication skills
  • Advanced analytical and problem-solving skills
  • Proficient with MS Office suite
  • Highly proficient in MS Excel (Pivot Tables, V Look Ups, Power Query) and SQL
  • Experience with analytical techniques used for data analysis, exploration, and forecasting
  • Proficiency with Tableau or other data visualization tools

Additional Information

  • Strong understanding of pharmaceutical industry, terms, and concepts
  • Formal program management skills preferred
  • Experience working with business teams to understand and define problems for analysis preferred
  • SQL proficiency is preferred
  • Experience with or knowledge of managed care is strongly preferred
HealthPlan Data Solutions is an equal opportunity employer.