Manager Project Management - Mainframe Applications

At CVS Health, we’re building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation’s leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

Position Summary

The position involves 2 areas of expertise:
Server based applications: Tableau, Alteryx, Access, GCP, etc.
Mainframe applications: JCL, Batch Jobs, SAS, SQL, ZEKE, etc.

The position is in a central hub of Claim data that comes from 3 main Claim Platforms and 2 minor ones.  The managerial position is to be the gatekeeper of changes and enhancements to the existing systems as well as create new ones. The Mainframe area deals with data sources of flat files as well as DB2 tables.  Need to create DB2 queries as well as SAS batch queries into the flat file data. Must also be familiar with Rumba applications and tools.  There are over a hundred batch jobs that will need to be maintained and modified with changing business directions.  The Batch jobs are scheduled via ZEKE in a sequence to feed many downstream applications.   The majority of the time is creating solutions to business needs with the data available.  Will need to create an Adhoc report with the findings or institute the changes into the existing report data producing Batch jobs.  Must be able to work with a team as well as individual contributions to reach management goals.

The Server based application would be to take the data from the Mainframe and put into existing reporting or create new reporting for the business.  Knowing how to handle millions of records and to create reporting based on that data is imperative. Familiarity with Alteryx to do the final preparations to the data and Tableau or Excel to present the report to management.  With the migration of data to Google Cloud some experience here would also be beneficial.

The individual must be a self-starter who can take on challenges, find an implement solutions across multiple technologies starting with Mainframe skills.

We support a hybrid work environment. If selected and you live near a suitable work location, you may be expected to comply with the hybrid work policy.  Under the policy, all hires for in-scope populations should be placed into a hybrid or office-based location, working onsite three days a week.
Aetna Service Operations office/hub locations will be discussed with the selected candidate
 

Required Qualifications
•    Deep expertise in strategic execution of data analytics and tools (e.g., Tableau, Alteryx, Access, GCP, etc).
•    Mainframe (Rumba) knowledge and experience with batch jobs and SAS
•    Strong communication, interpersonal and presentation skills.
•    Experience working in healthcare operations with knowledge of all lines of business.
•    Mastery of collaboration, problem solving, and decision making skills.


Preferred Qualifications

Alteryx and Tableau are essential.    

DB2 knowledge would be a plus.

GCP or Google Cloud experience would be a plus.

Education
Bachelor degree or equivalent experience

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$60,300.00 - $132,600.00

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls.  The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.  This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. 
 

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.

• No-cost programs for all colleagues