Sr. Analyst - Drug File Administration

CVS Health Scottsdale , AZ 85250

Posted 7 months ago

Job Description:

As a Senior Analyst

  • Drug File Administration you will be responsible for reviewing and validating drug data received from external vendors and used in support of prescription claims processing. Various data is received at various intervals (i.e. daily, weekly, monthly) from multiple vendors. The Senior Analyst

  • Drug File Administration is essential to ensuring that thorough analysis of the data is performed on a daily basis for purposes of validating its accuracy. As issues are identified, the individual in this position is responsible for investigating further and leading efforts toward resolution.

    Issue resolution often times requires working collaboratively with internal business partners or directly with the applicable data vendor. Additional responsibilities include managing certain proprietary drug data processes and serving as drug data subject matter expert in support of related projects and client/regulatory audits.

Required Qualifications
4+ years of Excel experience; specifically using VLOOKUPs and pivot tables

Preferred Qualifications

  • 4+ years of PBM or related healthcare industry experience.

  • Demonstrable experience working with large, disparate data sets and performing detailed analyses

  • Working knowledge of Microsoft Excel macros and Visual Basic for Application (VBA) coding language

  • Intermediate to advanced knowledge of MS Access

  • CPhT, certified pharmacy technician


Associates degree or equivalent work experience

  • Bachelor's degree in a related field is strongly preferred

Business Overview

It's a new day in health care.

Combining CVS Health and Aetna was a transformative moment for our company and our industry, establishing CVS Health as the nation's premier health innovation company. Through our health services, insurance plans and community pharmacists, we're pioneering a bold new approach to total health. As a CVS Health colleague, you'll be at the center of it all.

We offer a diverse work experience that empowers colleagues for career success. In addition to skill and experience, we also seek to attract and retain colleagues whose beliefs and behaviors are in alignment with our core values of collaboration, innovation, caring, integrity and accountability.

CVS Health is an equal opportunity/affirmative action employer. Gender/Ethnicity/Disability/Protected Veteran we highly value and are committed to all forms of diversity in the workplace.

We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities. We comply with the laws and regulations set forth in the following EEO is the Law Poster: EEO IS THE LAW and EEO IS THE LAW SUPPLEMENT.

We provide reasonable accommodations to qualified individuals with disabilities. If you require assistance to apply for this job, please contact our Advice and Counsel Reasonable Accommodations team. Please note that we only accept applications for employment via this site.

If technical issues are preventing you from applying to a position, contact Kenexa Helpdesk at 1-855-338-5609 or For technical issues with the Virtual Job Tryout assessment, contact the Shaker Help Desk at 1-877-987-5352.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Consultant Product Administration


Posted Yesterday

VIEW JOBS 10/13/2019 12:00:00 AM 2020-01-11T00:00 If you're passionate about becoming a Nationwide associate and believe you have the potential to be something great, let's talk. Number 57 on the Fortune Magazine 100 Best Places to Work. Job Description Summary Compensation Grade: H3 * ADDITIONAL INFORMATION - PLEASE READ CAREFULLY* The information between the asterisks contains specific information about this position while the information after the asterisks contains general information about jobs in this job family at Nationwide. * Additional Job Details: Product Administration Leader Nationwide job title: Sr. Consultant, PL Product Mgmt Job Summary: Leads the development, submission, management and compliance of the Nationwide pet insurance product portfolio. Develops strategy and oversees coordination to ensure all filings are submitted and approved with the state departments of insurance. Partners closely with Product Channel leaders on filing needs, strategies and timing. * JOB SUMMARY: Responsible for design, development and maintenance of the most complex and/or largest PL product lines for a region with respect to design, profitability and growth. Makes or implements recommendations regarding the design, pricing, underwriting, agency management, distribution, claims, and other processes related to managing the product in the field. Accountable for the profitability, growth and overall success of products in assigned region across multiple distribution channels (EC, IC, and Direct). Job Description Reports to: PL product leader, dotted line to RVP; Direct reports may include Associate Product Managers and Product Analysts. Key Responsibilities: Develops and executes an integrated short term and long term product strategy (including pricing and design features) across PL product lines. Ensures appropriate placement of the product in the marketplace to achieve the strategic goals and maintain compliance with all regulatory requirements. Provides direction on system changes necessary to enhance product performance. Validates and confirms effective technology implementation of rate changes and other enhancements. Directs new business development and implementation within the region. Designs financial objectives and strategies on communicating financial results. Analyzes and reviews financial results, product profitability, business mix and competitive information and designs forecasting models for region. Functions as an advanced technical resource on regional PL product issues. Reviews pricing, design features, and associated processes such as distribution and claims to ensure appropriate product design and placement. Partners with comparative rater team. Conducts detailed research on all aspects of a PL product line to help make policy and practice decisions. Proactively identifies product opportunities in present markets or new markets and coordinates the organizations response. Works with and through others to meet overall project timelines and maximize workflow. Designs project work plans for new business or new implementation. Anticipates regional needs. Develops long-term business product plan that drives profitable growth at the local market level. Functions as a technical resource to leadership. Works collaboratively with the regional underwriting leadership in the development of standards and guidelines. Conducts loss and revenue planning. Recommends the development of additional features/capabilities for PL products with responsibility for PL product growth and profitability in the assigned region. Consults with sales on distribution planning and product placement within the market. Communicates product design decisions and plans to internal and external partners within the region. Communicates and coordinates work across regions. Acts as a leader on the product team and provides coaching to Product Managers and Associate Product Managers. Partners with peers internal and external relationships through regular contact with respect to PL product premium growth, success and profitability. Build strong relationships with sales and distribution partners to build market knowledge to ensure appropriate product placement. Identifies training needs. Partners with the training department to develop and deliver new product training as appropriate. Leads in the coordination and implementation of new PL product and product changes. Performs other duties as assigned. MINIMUM JOB REQUIREMENTS: Education: Undergraduate studies such as insurance, actuarial science, mathematics, risk management, economics, finance, accounting, business administration or related field. License/Certification/Designation: Insurance licenses or designations such as CPCU, ARM, CLU, FLMI, ChFC, CFP, NASD etc preferred. Experience: Minimum of six years experience in personal lines insurance, financial services, marketing, or communications including two years previous product management experience. Knowledge: In-depth knowledge of analytical tools, core business functions, underwriting policies and best practices, performance measurement techniques, and systems required. Knowledge of related pricing, marketing, insurance models/contracts, and financial analysis necessary. Skills/Competencies: Excellent verbal and written communications necessary to effectively influence, train others, present information, communicate with management, agents, and policy holders. Must be skilled in the use of related systems and analytical tools. Ability to drive for results, deal with ambiguity, solve problems, learn on the fly, make decisions, see trends/patterns within regions necessary. Excellent project management skills necessary. Values: Regularly and consistently demonstrates the Nationwide Values and Guiding Behaviors. Staffing Exceptions to the above Minimum Job Requirements must be approved by the:hiring manager's leader and HRBP. JOB CONDITIONS: Overtime Eligibility: Not Eligible (Exempt) Working Conditions: Normal office environment. Additional hours as required. Some overnight travel required. ADA: The above statements cover what are generally believed to be principal and essential functions of this job. Specific circumstances may allow or require some people assigned to the job to perform a somewhat different combination of duties. Job Evaluation Activity: KMP 9-2014 Nationwide Scottsdale AZ

Sr. Analyst - Drug File Administration

CVS Health