Manager, Trade, FP&A & Rebates

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 Summary:

As part of the Data Enablement team, you will assist in the development, upkeep and management of databases used for data analysis and data mining to help produce close/forecasts, and FP&A reporting. You will assist in the extraction of diverse information from multiple data warehouses, tables, and other sources and bring the data together in databases to calculate complex client rebate terms.

In this role, you will support the formulary rebate business and will review and account for all rebates from drug manufacturers. You will work to understand client contracts and track their performance against them. Your experience in data systems, applications and the management of data inputs will allow you to directly impact the Company's P&L.

You will gain heavy insight into complex, varying contract terms and our data environment to be able to accurately calculate and report the financial position of rebates and analyze variances and drivers. By utilizing your expertise in SQL, Microsoft Access, and Microsoft Excel you will perform data mining activities. Knowledge of Visual Basic is a plus.

The Data Enablement team is an exciting and challenging environment where you will need to strive to improve your skillset. We highly value excellent customer service and we aim to provide accurate and timely information. Our team is responsible for budgeting, forecasting, and accounting for all formulary rebates for CVS Health.

Position Duties & Responsibilities:

• Ability to create automate, and improve databases, including creating tables, and knowledge/use of stored procedures.
• Advanced proficiency in Structured Query Language (SQL).
• Proficient in MS Access, Excel and VBA or Python.
• Participate in the corporate close, forecasts and budgets ensuring the latest client specific assumptions are layered into the database and correct calculations and outcomes are predicted.
• Provide variance analysis to understand potential risk and opportunities with respect to financial results.
• Complete ad-hoc reporting and analysis to support broader finance group as needed.
• Work with business partners to determine contract impact on future financial performance and communicate to financial organization.

Required Qualifications:

• 3 years of professional experience in Data Management, Financial Planning & Analysis, or other Analytic role(s).
• 3 years of experience in writing complex SQL, stored procedures, functions and working with large datasets.
• 3 years using Microsoft Access, Excel, VBA, or Python.
• Experience with Teradata, Oracle, SQL Server database and applications to extract and summarize data from large data warehouses.
• Database design and working knowledge of logical and physical data models.
• Initiative-taker, goal-oriented, ability to manage multiple assignments with strict deadlines.

Preferred Qualifications

• Experience with Tableau, Alteryx, and Salesforce.
• Have excellent verbal and written communications skills.
• Experience using business analytics to solve data-driven questions.
• Experience working in a large corporate environment.
• Visio experience a plus

Education:

Bachelor's Degree.

Pay Range

The typical pay range for this role is:

$60,300.00 - $136,500.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.

CVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated.

You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.

CVS Health is committed to recruiting, hiring, developing, advancing, and retaining individuals with disabilities. As such, we strive to provide equal access to the benefits and privileges of employment, including the provision of a reasonable accommodation to perform essential job functions. CVS Health colleagues can initiate a request for a reasonable accommodation, including a qualified interpreter, written information in other formats, translation or other services through myHR . If you have a speech or hearing disability, please call 7-1-1 to utilize Telecommunications Relay Services (TRS). We will make every effort to respond to your request within 48 business hours and do everything we can to work towards a solution.