Job search

Apply Now    
Job Title :
Oracle Architecture - Sr. Advisor
Job ID :
Location :
RI - Smithfield
Street Address :
935 Douglas Pike
Category :
Information Systems
Description :
Job Description
The Pharmacy Data Warehouse is looking for an accomplished Senior Data Warehouse Architect with previous experience designing data warehouse systems consisting of transactional, analytical and big data components. The Technical Lead is responsible for developing architectural blueprints, patterns, applying enterprise thinking to drive value
beyond the current project and for delivering high quality estimates, design and project deliveries. The Senior Architect will drive the data architecture solutions that are consistent with enterprise standards. Create and provide direction and oversight for data modelers on the design of relational and dimensional models. Interface with upstream system architects, developers and program managers to resolve data issues and drive capture of data needed by business customers. Evolve and support the basic tenets of good data architecture. The Technical Lead works on one or more projects at all stages of the system lifecycle (define, design, and build).
- Provide technical leadership in developing vision, strategy, architecture and overall design for assigned domain and for solutions.
- Lead teams, technical projects or programs, and has overall leadership responsibility for project architecture and design.
- Actively facilitate complex design and technical discussions, reconciling differing opinions and drives decision making process.
- Review and ensure architectural designs are consistent, maintainable, flexible, and cost
- Provide technical leadership and mentoring throughout the project lifecycle
- Proactively identify reuse opportunities.
- Articulate the tradeoffs, benefits and risks of all architecture and design solutions.
- Own strategy of: System monitoring, Capacity planning, Disaster recovery, Production
implementation and architecture.

Required Qualifications
* Minimum 8 years of related responsible experience working with large and complex data warehouse systems with hands-on data architecture experience
* Minimum 8 years of recent experience working with Oracle in a multi terabytes environment
* Minimum 8 years of hands-on experience in database and SQL performance tuning (Teradata BTEQ,
Oracle PL/SQL)
* Minimum 5 years of experience in designing & developing logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schemas, conformed dimensions data architecture, early/late binding techniques, and data modeling
*The candidate must have hands on knowledge of Big Data landscape, specifically hands on working with Hadoop (Hortonworks), Unix/Linux operating systems as well as storage
configurations. Working knowledge of open source tools such as: Hadoop technology (Hadoop, Sqoop, Hive,etc.), Python and bash.
* Extensive hands-on technical knowledge of Data Warehouse Architecture, ETL, Database & SQL performance tuning
* Knowledge of data warehouse software development lifecycles (SDLC) including Project Management
and BI analytics using Lean and Agile
* Leadership/ staff mentoring ability
* Multi-tasking ability
* Interpersonal communications skills

Preferred Qualifications
*General knowledge about the health care industry, understanding of underlying business functions
* Experience with Data Quality & MDM and working with data governance teams
* Experience with Metadata Management tool

Bachelors degree in Computer Science, Information Systems or related field.

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 and EEO IS THE LAW SUPPLEMENT

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 EEO AA CVS Health

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:

Apply Now    
Link for schema

Our culture

CVS Health core values of Innovation, Collaboration, Caring, Integrity, and Accountability not only support our purpose of helping people on their path to better health for our customers and patients, but they also apply to how we support our more than 250,000 colleagues. You will find our culture at CVS Health, and our leaders encourage personal and professional growth.

Changing the future of health care at CVS Health

CVS Health Opens Talent Connect Center (TCC) at Fort Bragg

Colleague Resource Groups at CVS Health