Excellus BCBS

Excellus BCBS

Pharmacy Analytics Consultant I/II

Rochester, New York, United States of America · Mid

Sponsorship not specifiedDetected 35 days ago
SQLData AnalysisData ScienceStatisticsForecastingExcelSASSPSSResearchLeadershipCommunicationProblem SolvingMentoringAdaptabilityMicrosoft OfficeActuarial Science

About the role

  • Analyzes data to determine business problem, trends or opportunities for process improvements.
  • Communicate effectively with all levels of the organization related to, but not limited to, health plan cost, utilization trends and savings strategies.
  • Articulate results, insights and recommendations to management, steering committees and/or project sponsors.

Responsibilities

  • Level I Perform research on projects and manage and lead projects to successfully meet business objectives from across the enterprise.
  • Identify needs to develop new and innovative Pharmacy products, perform appropriate research, analyses, and evaluate feasibility of the administration and implementation of products.
  • Develop and deliver actionable insights to key enterprise stakeholders.
  • Actively participating in collaborative meetings with internal and external partners.
  • Provide analytics to support strategy development and innovative programs that align with enterprise and pharmacy goals and objectives.
  • Partner with business units to ensure compliance with governmental, contractual, and corporate guidelines, regulations, and policies and procedures.
  • Develop and establish standardized reporting and processes to support maintenance of business activities.

Requirements

  • In lieu of a degree, a minimum of two related years' experience in data or information analyses and reporting.
  • Ability to approach data analysis with different data mining techniques, statistical techniques (when applicable).
  • Working knowledge of Microsoft Office Suite.
  • Knowledge of basic statistical concepts and have strong analytical and problem-solving skills with attention to detail.
  • Demonstrated analytic abilities combined with capabilities for completing projects with minimum degree of supervision.
  • In depth knowledge of product and member desirable.
  • High degree of initiative, proactive attitude and commitment to teamwork.
  • Knowledge of advance statistical concepts and has strong analytical and problem-solving skills.
  • Must have the ability to work with large datasets (2TB or greater) and integrate large data across multiple sources (structured and unstructured).
  • Strong PC/programming skills including Microsoft Office Suite, VBA, SQL, Power Play and Impromptu and moderate proficiency in SAS required.
  • A minimum of three years' analytic experience in Healthcare industry.
  • Demonstrated ability to effectively interact with internal and external customers with particular strength translating user information needs into requirements and delivering high quality results.
  • Strong analytical, diagnostic, and problem-solving abilities with attention to detail.
  • Ability to quickly develop expertise in new application domains and analytic tools.
  • Consistently demonstrated high quality and accuracy of work.
  • Self-motivation, initiative, and an ability to perform under pressure with little supervision.
  • A minimum of five years' experience using statistical concepts and tools.
  • Master's Degree with at least two years of statistical analysis preferred.
  • Demonstrated expertise in relational database concepts.
  • Demonstrates advanced statistical capabilities, data mining, forecasting and predictive modeling skills, and/or actuarial techniques.

Benefits

  • Provide consultation and analytic support within the Pharmacy Division, other Health Plan departments and external vendors to ensure the most effective and affordable Pharmacy Benefit.
  • In partnership with Sales, Finance and Actuarial conduct comparative pricing analyses for pharmacy benefit Requests for Proposal.
  • Stay current with knowledge of Health Plans tools and data sources/structures to accurately pull and deliver data.

This listing is sourced directly from Excellus BCBS's careers page and normalized into a canonical job model.