Analyst, FP&A
CVS Health is dedicated to shaping a more connected and compassionate health experience. The Analyst, FP&A position involves preparing financial statements, regulatory reports, and supporting documentation while assisting with accounts payable and various accounting functions.
Responsibilities
- Complete all necessary analysis and research for monthly financial statement reporting, balance sheet reconciliation and journal entries by utilizing Excel, QuickBase, banking information and the Great Plains Accounting System. Complete weekly research related to claim payments that involve bank research and stop payments and reissuance in Accounts Payable. Completing reoccurring payments and tracking in Excel for vendors/providers. Complete monthly wires for provider capitation payments that require entering the payment into QuickBase including the calculation support for approval. This position will be completing monthly bank account reconciliations and prepare and assemble all required supporting documentation for all the above listed work
- Prepare regulatory reports adhering to all contractual reporting obligations to our regulatory agent on a quarterly and annual basis per the reporting guide from Mercy Care regulators (AHCCCS & CMS). This position will complete the MCA/Medicare report that will encompass detailed financial information and required variance analysis quarter over quarter. Excel is utilized to complete this work and the data sources are the financial statements and other supplemental reports that are created to complete the regulatory reports. Finance Mngt reviews them prior to submission to AHCCCS for review and comment
- Assist with accounts payable review and audit requirements Audit controls require an Accountant to upload AP check payment data to the bank. Our fiscal year audit will require all Accountants complete Workpapers requested by our auditors. These are assigned as needed and have quick turnaround
- Prepare other ad-hoc reports as needed by Management, i.e. payment analysis for one provider for the requested period of time, payment research related to a missing payment or over/under payment, a contract change for capitation payments, this can vary
Skills
- 1+ years of experience in a corporate accounting or finance department or public accounting experience
- Proficiency with Microsoft Excel, Word, Access and Outlook
- Strong analytical and problem solving abilities
- Must reside in Phoenix Metro area - this is a hybrid position that will require certain days in the office
- 2+ years in corporate accounting
- Healthcare experience
- Experience with Microsoft Dynamics Great Plains
- Strong Excel skills with proficiency in using pivot tables and various formulas (lookups, SUMIFS, etc.)
- High attention to detail to ensure work is formatted consistently and in a presentable manner
- Ability to multitask
Benefits
- This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
- This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families.
- The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.
Company Overview