Data Analyst - Pharmacy
HealthPlan Data Solutions
Data Science · Full-time
Columbus, OH, USA
Posted on Friday, May 19, 2023
Main Purpose of Job
The Data Analyst – Pharmacy, reporting to VP of Pharmacy, is responsible for the review and critical analysis of customer claims data. Using HDS proprietary software tools, the Data Analyst 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 working with business teams to understand and define problems for analysis
- Experience with analytical techniques used for data analysis, exploration, and forecasting
- Proficiency with Tableau or other data visualization tools
Required Background
· Bachelor’s degree in a business or scientific discipline
· 3 to 5 years of progressive work experience in a data analysis role
· 2+ years in a pharmacy related analysis role is strongly preferred
Additional Information
- Strong understanding of pharmaceutical industry, terms, and concepts
- Formal program management skills preferred
- SQL proficiency is preferred
- Experience with or knowledge of managed care is strongly preferred
HealthPlan Data Solutions is an equal opportunity employer.
