Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver. Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.Position SummaryThe Analyst, Reporting – Client Operations will be responsible for working with internal business partners in providing analysis and development of new reports; and, applying maintenance to existing reports for new/existing clients each plan year. As part of this team you will primarily use RxClaim query as well as tools like those available in the MS Office suite or products to provide key operational reports in support of various business units within the PBM. This includes:
Reporting: Defining, documenting, developing, and testing queries/scripts and reports
Analyzing complex problems and performing root cause
Executing and monitoring daily ,weekly, and monthly processes, per defined work instructions and schedule
Maintaining knowledge of RxClaim data files and tables Documentation
Provide review, maintenance and input into work instructions, policies, procedures documentation as required
Providing status to management and internal partners as needed regarding assigned projects
Work with Team members and assigned tasks as requested by management
Required Qualifications
Proficient in Sequel (SQL) programming and scripting
Working knowledge of MS Access and Excel, and be able to use those tools as needed to support operational processes, procedures, and reporting needs
Able to complete assigned tasks for larger scale projects, taking direction from a designated project lead
Intermediate to advanced skills in MS Excel and MS Access
Ensure adherence to CMS guidelines and regulations when applicable and follow Policies and Procedures
Excellent written and verbal communication skills
Excellent organizational and time management skills
Excellent interpersonal and collaborative skills
Requires attention to detail
Preferred Qualifications
RxClaim/AS 400 Sequel/Query experience
Knowledge of DB2, Oracle or other relational databases
MS Excel and MS Access experience
Associates or higher
Education
HS Diploma or GED required plus 2 years equivalent experience
Pay RangeThe typical pay range for this role is:$40,600.00 - $85,100.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. In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies. For more detailed information on available benefits, please visit jobs.CVSHealth.com/benefits We anticipate the application window for this opening will close on: 05/16/2024We are an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.