Pharmacy Reporting Analyst

Essential Duties and Responsibilities

• Develops on-going knowledge of WellDyne’s varied data sources and structures to independently take in business requirements, design and execute on requests.
• Models and tracks pharmacy savings on a monthly basis and makes recommendations, as needed.
• Supports WellDyne’s need to support Employer Groups and Sales by collaborating on RFP’s to grow business. Assists in the bidding process to maintain current groups and potentially gain new business. This includes but not limited to re-pricing of claims, savings estimate, etc.
• Supports with claims submissions to various rebate vendors. Helps analyze competing offers on drug rebate to determine best deal.
• Participates in problem-solving and investigation, analyses, special projects and research projects as requested.
• Aids in identifying cost containment and quality improvement opportunities and makes recommendations to customers for further analysis opportunities.
• Researches, identifies, reviews and evaluates emerging trends that occur in the pharmacy industry.
• Organizes and prioritizes tasks, proposes work assignments so as to successfully complete projects in a timely manner.
• Manages multiple projects with competing deadlines to successful completion.
• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.

Education and Experience

• BS/BA in Business or related field (e.g. Finance, Computer Technology, etc.).
• Experience with Visual Analytic tools required (Tableau, SAS Visual Analytics, Power BI).
• Requires advanced data analytic skills with SAS, Business Objects, Microsoft Office (e.g. Access and Excel including VBA).
• Other data analytic experience is a plus (e.g. Crystal Reports, Unix, SQL/PL-SQL).
• Requires 3-5 years experience in health care (Health Plan, Pharmacy Benefit Management or government payer).

Knowledge, Skills, and Abilities

• Strong knowledge of excel and advanced excel features.
• Strong mathematical skills.
• Strong analytical and organizational skills.
• Strong people skills.
• Good understanding of the Pharmacy business.
• The ability to pick up new technology tools quickly.
• Accounting or financial experience a plus.
• Knowledge of SQL tables and data models a plus.