CVS Health

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Reporting Consultant - Senior

at CVS Health

Posted: 9/10/2019
Job Reference #: 1057495BR
Keywords: technical

Job Description

Job Description
As a Senior Consultant Reporting, you will use internal CVS Health systems to design, develop, and produce professional applications, extracts and reports for several areas within Customer Care Metrics. Additionally, the Senior Consultant could support multiple Customer Care Metric initiatives, ensuring that optimal changes are implemented and documented. This role allows you to interface with other areas within the organization as new processes are written to support our Business Operation counterparts. As part of Customer Care Metrics, you will be a key member in the success and operational structure.
Additional responsibilities of the Senior Reporting Consultant include:
* Responding to user requests for analysis or reports; by creating new data sets, tables, procedures, views, ETL’s and/or RDL’s.
* Designing, developing, implementing and tuning simple to complex queries within multiple reporting database systems.
* Becoming the technical lead within the reporting team to ensure consistencies and accuracy within SQL based reporting solutions.
* Providing support for production systems, including rotational on-call support, when required.
* In this role, you will design, code, test, debug, document, deploy, and support solutions that ultimately improve health outcome, quality of care, and patient safety. This includes the timely handling of all CMS/Compliance and SLA reporting requirements.

Required Qualifications
1. Senior level (three years or greater) experience with SQL, SSIS, and SSRS is essential.
2. Experience and proficiency with SQL Server 2014/2016 versions is required.
3. Strong knowledge of writing SQL queries, stored procedures, functions and views for ad-hoc, and recurring standard reports or extracts.
4. Experience with querying data various database platforms, such as SQL Server, DB2, Oracle, and Teradata.
5. Ability to mentor a less experience team members and drive compliance for best practices, methods, standards and processes..
6. Poses an innovative and learning mind to implemented creative but scalable solutions, and with continued knowledge growth of new tools and techniques.

Preferred Qualifications
1. Prior experience with health plans, Medicare Part D, enrollment systems or coverage determination & appeals and/or government programs is preferred.
2. The success of this position is directly coupled to bringing SQL development best practices to build manageable, scalable, and high-performance SQL code.
3. Has good understanding of various data modeling techniques such as Star and Snowflake schemas.
4. Experience with Tableau is a plus.
5. Experience with CVS Caremark internal systems such as RxClaim, PeopleSafe, Avaya, SPARCS, SPRx or Cas.
6. Candidate should be proficient in Microsoft Office Suite, particularly Word, Access, Visio, and Excel.
7. Preferred 5+ years of experience.

Bachelor Degree or equivalent experience.

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.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!