Job Closed
This listing is no longer active.
UPSTARS – продуктова IT-компанія, з якою злітають і люди, і бренди. Наш основний фокус – технологічні рішення та B2B-послуги для міжнародних клієнтів.
Pharmacy Analytics Consultant I/II
Location
United States
Posted
100 days ago
Salary
$62.4K - $142K / year
Seniority
Mid Level
No structured requirement data.
Job Description
Pharmacy Analytics Consultant I/II
Excellus BlueCross BlueShield
Job Description: The Pharmacy Analytics Consultant provides direct support for both Pharmacy and Medical Drug information needs using a variety of analytic tools and applications. The Consultant will work with internal and external stakeholders and management, as required, to achieve Pharmacy Markets strategy, growth, compliance, and affordability objectives across the enterprise. The analyst collaborates with a multidisciplinary team (e.g., clinical, financial, sales, and Line of Business Leaders) to recommend actionable items leading to positive pharmacy financial performance. This position prepares and presents information to enable both senior management and our customers to better understand, evaluate, and support their goals. Essential Accountabilities: Level I - Perform research on projects and manage and lead projects to successfully meet business objectives from across the enterprise. - Analyzes data to determine business problem, trends or opportunities for process improvements. - 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. - Identify needs to develop new and innovative Pharmacy products, perform appropriate research, analyses, and evaluate feasibility of the administration and implementation of products. - 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. - Develop and deliver actionable insights to key enterprise stakeholders. Actively participating in collaborative meetings with internal and external partners. - In partnership with Sales, Finance and Actuarial conduct comparative pricing analyses for pharmacy benefit Requests for Proposal. - 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. Participate in all CMS and DOH compliance audits. - Develop and establish standardized reporting and processes to support maintenance of business activities. - Stay current with knowledge of Health Plans tools and data sources/structures to accurately pull and deliver data. Regularly review trends and best practices related to healthcare analytics - Compiles complex data sets tailored to customers needs. Evaluates and processes raw data for user friendly and provides actionable insight (visual and otherwise) to end users. - Consults with other specialized analytic units (i.e. Business Intelligence) to develop automated production reports, dashboards and cubes for efficiency when appropriate. - Engage with external partners and customers (i.e. Employer Groups, Brokers, Consultants, Providers, and Vendors) to help drive the success of Health Plan partnerships and goals. - Enhance Pharmacy knowledge and consulting skills to contribute to affordability and savings for the Enterprise and our customers. - Creates unified strategies with internal departments that target reducing costs of healthcare. - Manages, organizes and prioritizes tasks for multiple projects with competing deadlines to successful completion. - Collaborates with team members, leveraging skill sets across the team and aiding in growth and development as needed. - Proactively problem solves, investigates and brings forward concerns to management and/or business partners with relation to data pulls and analyses, as appropriate. - Builds collaborative relationship across functional teams and other analytic teams across the organization. - Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies’ mission and values and adhering to the Corporate Code of Conduct and leading to the Lifetime Way values and beliefs. - Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures. - Regular and reliable attendance is expected and required. - Performs other functions as assigned by management. Level II (in addition to Level I Accountabilities) - Assists in training and mentoring fellow analysts. - Participates and represents as a subject matter expert (SME) in cross-sectional team meetings or with business partner leads or other departments as needed. - Participates on departmental and Health Plan project teams to recommends and/or develops comprehensive data strategies for optimal SAS/BI Tool utilization and connectivity with other BI tools. - Devises strategy for producing deliverables, selecting and utilizing the most appropriate analytic tool, as well as, to begin to build process efficiencies. Level III (in addition to Level II Accountabilities) - Utilizes all relevant and available tools that optimize reporting efficiency for consumption by business partners and/or provides the business partners the user-friendly tools to run repetitive reports self-service. - Uses knowledge of both the claims data sets/warehouses available and the Medical/Pharmacy Management systems to produce reports that tie the information (claims plus health plan or vendor partner management) that illustrates the effectiveness of health plan and provider partner programs as they relate to trend, program development opportunities, value of management programs to be used both internally and externally. - Contributes, in partnership with Data Science to develop predictive cost savings models (or other types of models) and to quantify the value and impact of the department management programs (program specific) for business use to both external and internal partners, ultimately helping to sell programs to employer groups, as needed. - Provides expertise in relational database concepts to analytics areas, as well as, customers. - Seeks out opportunities to train and mentor fellow analysts within the framework of the department. - Demonstrates keen judgment on involved and complex assignments; devises methods and procedures to meet unusual conditions and makes original contributions to the solution of very difficult problems. Level IV (in addition to Level III Accountabilities) - Recommends to leadership advanced analytic models and/or research that financially impact pricing, cost containment, quality, marketing and risk management functions. - Develops large, complex advanced analytic models and performs data mining functions to identify trends in the data and/or opportunities for improved outcomes, as appropriate. - Provides consultation, complex performance analysis, and coaching expertise to team member around methods of continuous quality improvement. - Fosters a culture of continuous improvement that includes the use of performance data to understand health care cost and utilization trends, clinical and condition management analysis, health care cost containment, data quality measurement, and predictive modeling. - Improves visual analytics throughout the organization. - Interacts with Health Plan leadership to interpret model output and make business inferences that address strategic needs. - Assesses need and opportunity for upgrades to existing or new analytic products (i.e. SAS or Cognos products). - Prepares and submits studies for journal publication or presentation at national meetings, as needed. Minimum Qualifications: NOTE: We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities. All Levels - Bachelor’s degree in Mathematics, Statistics, Medical Informatics, Economics, or related field preferred. - In lieu of a degree, a minimum of two (2) related years’ experience in data or information analyses and reporting. - Knowledge and applicable use of all tools available to develop analyses, extract information and using the most appropriate tool for the given report is required (i.e. SAS, Cognos, Excel, Access, SPSS, DataFlux, AQT, Winscp, puTTy etc.). Ability to approach data analysis with different data mining techniques, statistical techniques (when applicable). - Proficient in using SAS and/or Cognos and Microsoft tools. - Working knowledge of Microsoft Office Suite. - Knowledge of basic statistical concepts and have strong analytical and problem-solving skills with attention to detail. - Demonstrates the ability to take complex data sets and simplify for all audiences to understand through both visual interpretation and highlighting data points of significant impact or potential areas for impactful program development (quality of care and controlling costs). - Willingness to develop relationships with partners within the health plan to both understand data requests and help to shape the request for more influential impact. - Demonstrates intermediate understanding of healthcare products and operational business knowledge. - Demonstrated analytic abilities combined with capabilities for completing projects with minimum degree of supervision. - Knowledge of the health care system and experience working with physician or hospital claims/group data preferred. In depth knowledge of product and member desirable. - Excellent oral and written communication skills with aptitude for communicating to a variety of audiences. - High degree of initiative, proactive attitude and commitment to teamwork. - Demonstrated ability to effectively and tactfully relate to internal and external customers. - Possess the ability to work collaboratively with requestors and/or business partners. Adaptable to constant industry change and rapidly changing priorities. Level II (in addition to Level I Qualifications): - A minimum of three years’ analytic experience in Healthcare industry. - Knowledge of advance statistical concepts and has strong analytical and problem-solving skills. - Demonstrated ability to effectively interact with internal and external customers with particular strength translating user information needs into requirements and delivering high quality results. - 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. - 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. Level III (in addition to Level II Qualifications): - 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. - Demonstrated skills in quality principles especially root cause analysis and problem solving. - Demonstrated business and technical problem-solving skills. - Extensive experience in analytic tools required (i.e. SAS, Cognos, SPSS, or others). Level IV (in addition to Level III Qualifications): - A minimum of three years’ health care specific predictive modeling experience or seven years of experience in health informatics. - MS or MA in Statistics, Economics or related discipline preferred. - Ability to create, develop/validate models independently. - SAS Base Certification required. SAS Advanced Certification preferred or similar Analytic Software certification. - Project Management/Process Improvement knowledge preferred. - Continued professional growth in analytic software tools (i.e. SAS competency as evidenced by successful passing of Advanced Certification Exam and/or Certified Predictive Modeler Exam) - Project Management (PMP, Six Sigma) experience desired. - Advanced analytic software programming proficiency required (i.e. experience with SAS EBI suite, Information Maps, Stored Processes, Web Report Studio, Information Delivery Portal). Physical Requirements: - Ability to work prolonged periods sitting at a workstation and working on a computer. - Ability to work while sitting and/or standing while at a workstation viewing a computer and using a keyboard, mouse and/or phone for three (3) or more hours at a time. - Typical office environment including fluorescent lighting. - Ability to work in a home office for continuous periods of time for business continuity. - Ability to travel across the Health Plan service region for meetings and/or trainings as needed. ************ In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position. Equal Opportunity Employer Compensation Range(s): E1, Level I Min: $62,400 - $84,000 E3, Level II Min: $62,400 - $106,929 E5, Level III Min: $71,880 - $129,384 E6, Level IV Min: $79,068 - $142,322 The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including, but not limited to, budget available, prior experience, knowledge, skill and education as they relate to the position’s minimum qualifications, in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance, retirement plan, wellness program, paid time away from work, and paid holidays. Please note: There may be opportunity for remote work within all jobs posted by the Excellus Talent Acquisition team. This decision is made on a case-by-case basis. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Related Guides
Related Categories
Related Job Pages
More Consultant Jobs
Joint Action to Stop Wasting Learning Consultant
AGORAUNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. UNICEF is committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF promotes and advocates for the protection of the rights of every child, everywhere, in everything it does UNICEF's global workforce must reflect the diversity of those children UNICEF encourages applications from all qualified candidates, regardless of gender, nationality, religious or ethnic backgrounds, and from people with disabilities
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description The purpose of this consultancy is to support the five frontrunner countries (Haiti, Kenya, Madagascar, Nigeria, and South Sudan) to document the implementation of the Joint Action to Stop Wasting (JASW) and produce learning briefs. The consultant will provide technical and methodological support throughout the learning process, including: - Design of data collection approaches - Facilitation of data gathering and analysis - Preparation of country-level learning briefs and multi-country thematic briefs - Facilitation of the synthesis of findings across countries - Identifying common patterns, good practices, and lessons learned to inform adaptive management and guide the JASW partnership model Qualifications - Advanced degree in Public Health, Nutrition, Social Sciences, or a related field - Minimum 5 years of professional experience in programme evaluation, implementation research, or learning documentation - Proven experience in qualitative and quantitative data collection and analysis in the area of nutrition - Demonstrated ability to synthesize findings and produce high-quality analytical reports - Experience working with UNICEF, WFP, or other UN agencies is an asset - Excellent writing and presentation skills in English (French desirable) Requirements - Routine monitoring data (based on JASW M&E framework) - Focus group discussions and key informant interviews to explore acceptability, feasibility, and barriers - Direct observations of service delivery to assess fidelity and quality - Surveys/questionnaires to assess participation, satisfaction, and user experiences (where possible) - Participatory workshops with communities and frontline workers to identify bottlenecks and propose solutions Benefits - Diverse opportunities for professional and personal development - Attractive compensation and benefits package Company Description UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. UNICEF is committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. - UNICEF promotes and advocates for the protection of the rights of every child, everywhere, in everything it does - UNICEF's global workforce must reflect the diversity of those children - UNICEF encourages applications from all qualified candidates, regardless of gender, nationality, religious or ethnic backgrounds, and from people with disabilities
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description The Associate Business Consultant supports client projects by analyzing data, providing actionable insights, and assisting in the configuration of customer experience (CX) solutions. This role involves increasing responsibility in managing tasks independently, collaborating with senior consultants, and developing expertise in CX technologies. The Associate Business Consultant plays a key role in ensuring the successful execution of client engagements and internal initiatives by applying analytical, technical, and communication skills. Responsibilities - Client & Internal Communication - Communicate effectively with internal teams and clients in a clear, professional manner. - Manage standard client communications, including updates, clarifications, and expectation-setting. - Escalate client issues to relevant stakeholders when necessary, ensuring timely resolution. - Demonstrate effective presentation skills, adapting communication style to suit different audiences. - Practice active listening, asking insightful questions that foster collaboration and deeper understanding. - Data Analysis & Insights - Analyze client data to identify trends, insights, and opportunities for business improvement. - Contribute to the design and development of dashboards, models, surveys, and workflows that reflect client requirements and best practices. - Develop knowledge of industry best practices and apply them to address client challenges effectively. - Project Coordination & Time Management - Independently manage and prioritize tasks to meet client project deadlines. - Monitor project timelines, proactively communicating potential delays or risks. - Maintain professionalism, punctuality, and reliability in all interactions. - Document meetings and follow up on action items to ensure completion within established timelines. - Technical & Configuration Solutions - Collaborate with senior team members to design and implement CX solutions aligned with client objectives. - Develop proficiency in Qualtrics and other CX tools to configure and customize solutions for client needs. - Conduct quality assurance (QA) checks on configurations to ensure solutions meet project goals. - Incorporate client feedback into solutions and strategies, ensuring continuous improvement and alignment with expectations. - Collaboration & Knowledge Sharing - Contribute to internal initiatives that enhance team efficiency and project success. - Share insights, tools, and techniques with colleagues to support knowledge development. - Actively seek opportunities to learn from peers, clients, and senior consultants to expand industry expertise and technical skills. - Apply industry knowledge to client challenges, assisting in the development of customized solutions. - Professional Development & Continuous Learning - Approach challenges with a problem-solving mindset, identifying solutions and executing effectively. - Take a proactive approach to learning, identifying and correcting potential errors in calculations or configurations. - Apply feedback to improve performance and refine skills, demonstrating a commitment to continuous improvement. - Ethics & Company Values - Align decision-making and project execution with the company’s vision and values. - Maintain professionalism and ethical behavior in all client and team interactions. - Seek feedback and demonstrate humility, prioritizing both personal and professional growth. Qualifications - 1–3 years of experience in customer experience consulting, data analysis, or a related field. - Strong analytical and problem-solving skills with the ability to interpret data and generate actionable insights. - Effective verbal and written communication skills for client and team interactions. - Understanding of CX principles and experience in applying them to client projects. - Growing proficiency with CX tools such as Qualtrics (or a demonstrated ability to learn quickly). - Strong organizational and time management skills, with the ability to handle multiple tasks and meet deadlines. - A self-motivated and proactive approach to learning and professional development. - Ability to work collaboratively in a team environment while also taking independent responsibility for tasks. Preferred - Bachelor’s degree in Business, Marketing, Data Analytics, or a related field. - Experience with data analysis software and tools. - Prior experience in customer experience management or consulting roles. Conclusion The Associate Business Consultant plays a vital role in delivering high-quality client solutions, contributing to data-driven insights, and supporting the configuration of CX technologies. Success in this role requires a blend of analytical thinking, effective communication, and a commitment to continuous learning and professional growth.
Client Benefits Consultant
AO Globe LifeAO Globe Life has supported working families for over 70 years, partnering with unions, credit unions, and veteran organizations nationwide. The company operates fully remotely and focuses on service, leadership development, and long-term career growth.
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description AO Globe Life is actively hiring professionals to join our fully remote team as Remote Client Benefits Consultants. This opportunity is ideal for individuals looking to advance their careers while maintaining flexibility and making a meaningful impact helping families access important supplemental benefits. All client appointments are scheduled in advance with individuals who have requested information. There is no cold calling, prospecting, or door-to-door outreach required. If you are ready to move beyond the traditional 9-to-5 structure and join a mission-driven team focused on growth and service, this opportunity may be a strong fit. - Conduct scheduled virtual consultations with individuals and families via Zoom - Assess client needs and recommend personalized supplemental benefit solutions - Clearly explain coverage options and guide clients through the enrollment process - Maintain accurate, compliant documentation within internal systems - Build and maintain long-term client relationships through consistent service and follow-up - Participate in team meetings, weekly training sessions, and ongoing professional development Qualifications - Experience in benefits consulting, client service, or consultative sales preferred - Strong communication skills with a professional presence during video consultations - Organized and self-motivated when working in a remote environment - Ability to follow established systems, processes, and compliance protocols - Authorized to work in the United States - Windows-based laptop or PC with webcam and reliable high-speed internet Benefits - Fully remote position available to U.S.-based professionals - Flexible scheduling to support work-life balance - Commission-based compensation with weekly payouts - Vested renewals for long-term income growth - Warm, pre-qualified leads provided—no prospecting required - Comprehensive training and ongoing mentorship - Licensing assistance for qualified candidates - Monthly and quarterly performance bonuses - Equity opportunity for qualifying team members - Clear leadership development and promotion pathways - Positive, team-oriented culture focused on growth and impact Company Description AO Globe Life partners with labor unions, credit unions, and veterans’ organizations to provide supplemental benefits to working families across the United States. With more than 70 years of industry experience, the organization offers stability, mission-driven work, and a remote-first culture designed to support professional growth. If you’re ready to build a meaningful career with strong income potential, flexibility, and leadership opportunities, we encourage you to apply and learn more about joining our team.
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This position is responsible for providing proactive intervention and care management consultation and support to promote high quality, whole person care for individuals with behavioral health (BH), intellectual/developmental disabilities (IDD), and/or traumatic brain injury (TBI) with or at risk for physical health complexities. The focus of this position is to ensure that individuals receive appropriate collaborative care assessment and services. This is a mobile position with work done in a variety of locations. Travel is an essential function of this position. Responsibilities - Provides physical health expertise and consultation - Serves as the point of contact regarding collaborative care for care management teams - Uses available data and medical information to provide proactive consultation and advice to the dedicated care managers regarding action steps needed to promote and/or improve member health - Provides direct care management support as needed (informing, educating, linking, phone communication with member or collaterals, participation in care team meetings) - Participates in clinical huddles/rounds with care managers, clinical and medical leadership - Takes lead on scheduling, presenting and providing updates in clinical huddles when indicated - Facilitates medication reconciliation - Assists department leadership in staff training and development, supporting care managers in development of necessary skills and resources to improve member health status - Provides guidance to care management staff on using Healthwise topics for health education and promotion with members - Measures results of intervention and treatment, including reduction in high risk events and inappropriate service utilization - Assists in quality of care monitoring through review of care plans, medical records, critical incident reports and other sources of information and provides consultation on quality of medical care or recommends areas for quality improvement - Analyzes medical, psychiatric, behavioral health diagnosis and medication data reports to identify potential contraindications in treatment on a scheduled basis - Participates actively in learning collaborative with other Care Management nurses - Will serve as tailored care manager for an identified high cost/high risk population and complete all needed assessments and reviews for care management - Will participate and complete other duties as assigned Qualifications - Ability to provide consultative supports for physical health diagnosis and treatment to include education, assessment, and care planning for whole person care - Understanding of the Diagnostic and Statistical Manual of Mental Disorders (current version) - Considerable knowledge of the IDD/TBI/MH/SUD service array provided through the network of the LME/MCO’s Providers - Knowledge of NC Medicaid, Managed Care, NC Innovations Waiver, 1915i option, LTSS, Tailored Plan and Standard Plans - Ability to analyze data and use data to drive decision-making - Ability to provide effective and clinically sound consultation/education/training to others - Ability to establish and maintain positive and effective working relationships with others both within the agency and community - Exceptional interpersonal and communication skills - Excellent computer skills including proficiency in Microsoft Office products (Word, Excel, Outlook, and PowerPoint) - Excellent problem solving, negotiation, arbitration, and conflict resolution skills - Detail-oriented, able to organize multiple tasks and priorities and effectively manage projects from start to finish - Ability to make prompt independent decisions based upon relevant facts, to establish rapport and maintain effective working relationships - Ability to change the focus of his/her activities to meet changing priorities Requirements - Licensed to practice as a Registered Nurse in North Carolina and two years of experience in intellectual and developmental disabilities, traumatic brain injury, and/or behavioral health - Must reside in North Carolina - Must have ability to travel regularly as needed to perform job duties Preferred Experience - Licensed to practice as a Registered Nurse in North Carolina and two years of experience in psychiatric nursing with dually diagnosed MH/IDD; care management/care coordination experience - Experience in collaborative care - Fluency in written and verbal bi-lingual Spanish/English language expertise Licensure/Certification Requirements - Must be licensed as a Registered Nurse in North Carolina - Employee is responsible for complying with respective licensure board’s continuing education/training requirements in order to maintain an active license Benefits - Competitive Compensation & Benefits Package - Annual incentive bonus plan - Medical, dental, and vision insurance with low deductible/low cost health plan - Generous vacation and sick time accrual - 12 paid holidays - State Retirement (pension plan) - 401(k) Plan with employer match - Company paid life and disability insurance - Wellness Programs - Public Service Loan Forgiveness Qualifying Employer

