CVS Health Advisor Application Develop in Smithfield, Rhode Island

Job Description

The Pharmacy Data Warehouse is looking for an Applications lead with relevant prior experience in working with and supporting data warehouse systems. The applications lead will work with individuals from within and outside the Pharmacy Data warehouse team to lead various aspects of a data warehouse life cycle such as software development, quality assurance, deployment planning, production stability and compliance management. The applications lead is expected to

  • Lead a team of designers, developers and test (QA) resources to successfully plan and execute projects

  • Lead application and system monitoring monitoring, capacity planning, disaster recovery, deployment management and Information Security/Compliance activities

  • Ensure production stability, identify root cause of production issues, plan and drive remediation, reduction and prevention of production issues

  • Manage overall compliance health of the data warehouse by working with Information security architects to understand compliance mandates and work with application designers, developers and system admins to implement the required solution

  • Effectively communicate and work with Business customers, IT management and Sr. leadership to articulate problem statements and solution options and track issues to closure

  • Facilitate complex discussions, reconciling differing opinions and drives decision making process

Required Qualifications

5+ years of related experience working with large and complex data warehouse system including the following:

  • Minimum 3 years of experience working with/supporting an Oracle/Exadata in a multi-terabyte database

  • Minimum 3 years of experience in production and customer support roles of a data warehouse system

  • Minimum 3 years of experience in SQL, PL/SQL

  • Minimum 3 years of experience with a batch scheduling tool

  • Knowledge of data warehouse concepts and software development life cycle (SDLC)

  • Knowledge of relational database concepts

Preferred Qualifications

  • General knowledge about the health care industry, understanding of underlying business functions

  • Data analysis and presentation using Microsoft Excel, PowerPoint


Bachelors degree in Computer Science or equivalent is required.

Business Overview

CVS Health, through our unmatched breadth of service offerings, is transforming the delivery of health care services in the U.S. We are an innovative, fast-growing company guided by values that focus on teamwork, integrity and respect for our colleagues and customers. What are we looking for in our colleagues? We seek fresh ideas, new perspectives, a diversity of experiences, and a dedication to service that will help us better meet the needs of the many people and businesses that rely on us each day. As the nation’s largest pharmacy health care provider, we offer a wide range of exciting and fulfilling career opportunities across our three business units – MinuteClinic, pharmacy benefit management (PBM) and retail pharmacy. Our energetic and service-oriented colleagues work hard every day to make a positive difference in the lives of our customers.

CVS Health is an equal opportunity employer. We do not discriminate in hiring or employment against any individual on the basis of race, ethnicity, ancestry, color, religion, sex/gender (including pregnancy), national origin, sexual orientation, gender identity or expression, physical or mental disability, medical condition, age, veteran status, military status, marital status, genetic information, citizenship status, unemployment status, political affiliation, or on any other basis or characteristic prohibited by applicable federal, state or local law. CVS Health will consider qualified job candidates with criminal histories in a manner consistent with federal, state and local laws. CVS Health will not discharge or in any other manner discriminate against any Colleague or applicant for employment because such Colleague or applicant has inquired about, discussed, or disclosed the compensation of the Colleague or applicant or another Colleague or applicant. Furthermore, we comply with the laws and regulations set forth in the following EEO is the Law Poster: EEO IS THE LAW at and EEO IS THE LAW SUPPLEMENT at

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. If you require assistance to apply for this job, please contact us by clicking Advice and Counsel at mailto:Advice&

CVS Health does not require nor expect that applicants disclose their compensation history during the application, interview, and hiring process.

For inquiries related to the application process or technical issues please contact the Kenexa Helpdesk at 1-855-338-5609. For technical issues with the Virtual Job Tryout assessment, contact the Shaker Help Desk at 1-877-987-5352. Please note that we only accept resumes via our corporate website: