Senior Revenue Analyst

This is a hybrid role that will require an onsite presence to the office in Somerville 1-2x/week.

The Senior Analyst plays a pivotal role in supporting all month-end close and audit activities for Finance Operations including but not limited to Commercial Accounts Receivable, Pharmacy Claims and Pharmacy rebates.  They are responsible for managing the monthly reconciliation of commercial accounts receivable, pharmacy payables and pharmacy rebate receivable balance sheet accounts. The Senior Analyst verifies Claims data submissions to ensure Vendors are paid appropriately. They take lead on all Pharmacy rebate journal entries and financial analysis.

The Senior Analyst must show a proven ability to work independently and fully utilize and apply financial operations and accounting methodologies. They demonstrate analytical and decision-making skills. The Senior Analyst will work collaboratively with other departments, demonstrate creative thinking skills, identify root-causes, and make appropriate recommendations to management.

Essential Functions:

• Review and resolve account receivable aging reports reconciling items. 
• Confirm and coordinate monthly Intermediary commission adjustments into QNXT.
• Work with IT to map CVS and Optum pharmacy rebate reporting to the general ledger
• Record Rebate Receipts at the product line level and manage the rebate accrual process. 
• Execute data queries and reviews findings with vendor and manager 
• Submit Vendor invoices to Accounts Payable upon verification
• Prepare of any G/L journal entries necessary to support Finance Operations month-end close including but not limited to Unearned premiums, Commercial AR reserves, Commercial write offs, Rebate receipts and rebate accruals.
• Prepare all audit support for Health Plan Audits.
• Reconcile commercial accounts receivable, pharmacy payables and pharmacy rebate receivable balance sheet accounts and provide explanations for quarter over quarter fluctuations
• Represent the department for all company-wide initiatives that impact premium billing, claims and pharmacy rebates. 
• Provides backup support for peers within Finance Operations department as needed
• Works collaboratively with IT to enhance automation of processes; establish data warehouse standards and definitions; and to identify opportunities to generate new queries and/or improve existing queries. 
• Work closely with the Pharmacy department to understand the Pharmacy rebate reporting and any ensure all rebate pull backs are reserved for and expected payments are accrued for.
• Hold self and others accountable to meet commitments.
• Anticipates and meets, or exceeds, internal and/or external customer expectations and requirements; establishes and maintains effective relationships with customers and gains their trust and respect.

Required:

• Bachelor's Degree in Finance-related discipline 
• Advanced proficiency with data analysis, generating queries (SQL) 
• High proficiency in MS Office suite of products (particularly Excel) 
• 5-7 years of experience in an accounting or related position 
• Prior experience working for a health plan or in a managed care setting 
• Month-end Financial Close Reconciliation and general ledger experience required