Manager Project Management - Mainframe Applications

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 candidateRequired 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
40Time Type
Full timePay Range

The typical pay range for this role is:$60,300.00 - $132,600.00This 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 peopleWe 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 including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

For more information, visit https://jobs.cvshealth.com/us/en/benefitsWe anticipate the application window for this opening will close on: 05/31/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.