SQL Developer - Senior

Job Description
Are you interested in a flexible WORK FROM HOME schedule? An opportunity where you can balance priorities in and outside of work while helping people on their path to better health? If so, consider a role at CVS Health, a Fortune 5 company, as a Senior SQL Developer!

As a Senior SQL Developer, you will use internal CVS Health systems to design, develop, and produce professional applications, extracts and reports for several areas in Member Services. Additionally, the senior consultant could support multiple Member Services teams ensuring that proper changes are implemented and documented. This role allows you to also interface with other areas within the organization as new processes are written to support our Business Operation counterparts. As part of Member Services Reporting, you will be a key member in the success and operational structure.

The Senior SQL Developer will respond to user requests for new tables, procedures, views and reports and design, develop, implement and tune complex enterprise level reporting database systems. Supporting the development and maintenance of existing and new application requests and providing support for production systems, including rotational on-call support, when required. In this role, the Senior Consultant 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.

The success of this position is directly coupled to bringing SQL development best practices to build manageable, scalable, and high-performance SQL code. You will use your knowledge of writing SQL queries, stored procedures, functions and views for ad-hoc, and recurring standard reports or file builds. Additional responsibilities will include utilizing your understanding and exposure of multiple RDBMS, as well as complex SQL Report Development skills across a variety of Database platforms such as Oracle and Teradata for database design and physical data modeling.

We offer a comprehensive benefits package which includes medical, dental, vision insurance as well as a wide-ranging list of supplemental benefits and discount programs. In addition to sixteen paid days off for employees, we also offer ten paid holidays.

Required Qualifications
3+ years of experience in the following;

• Writing SQL queries, stored procedures, functions and views for ad-hoc, and recurring standard reports or file builds
• Microsoft SQL Server Integration Services (SSIS), and Microsoft SQL Server Reporting Services (SSRS)
• Microsoft SQL Server database development experience, troubleshooting, tuning Microsoft SQL and proficiency with database query optimizations
• SQL Server 2014/2016 versions
• Database design and logical and physical data models.
• Development of web-based applications utilizing an asp.net platform. Software Development Life Cycle process and knowledge to insure the delivery of a Quality Reporting application with the appropriate documentations and on-going support.

Preferred Qualifications
• Prior experience with health plans, Medicare Part D, enrollment systems or coverage determination & appeals and/or government programs
• Prior experience with the development of web-based applications providing input/manipulation of data with SQL server backend.
• Experience with CVS Caremark internal systems such as RxClaim, PeopleSafe, Avaya, Enrollment, CAS, or MedHOK.
• Advanced level proficiency in Microsoft Office Suite, particularly Word, Access, Visio, and Excel.

Education
• Bachelor's Degree in Management Information Systems or related degree