Senior Financial Analyst
$46,988–$112,200 year
On-siteHartford, Connecticut, United States
Job Summary
Assist the Commercial Finance team with monthly financial close for the commercial pharmacy business and perform reconciliations of pharmacy claim data to data sources used by other teams. Update and maintain dashboard reports and models to explain drivers of variance to financial forecasts, while creating weekly reporting on pharmacy metrics and projection factors. Conduct ad hoc analyses for pricing and underwriting support of Aetna's self-insured pharmacy business. This role supports the Aetna Commercial Pharmacy Actuarial team, collaborating with Finance, Underwriting, and Actuarial partners to analyze the fully insured, self-insured, and specialty commercial business lines.
Required Qualifications
- 2–4 years of experience in financial planning & analysis, corporate finance, or a related analytical role
- Experience with Microsoft Excel (complex models, lookups, data manipulation) and PowerPoint (executive-level presentation design)
- Experience working with large data sets and financial reporting systems
- Bachelor's Degree required in finance, business, technical, or related field
Desired Qualifications
- Prior experience in healthcare, PBM, or insurance industries
- Demonstrated ability to manage multiple deliverables under strict deadlines with a high degree of accuracy and attention to detail
- Strong written and verbal communication skills, with the ability to translate financial data into clear, concise narratives
- Knowledge of or prior work with creating SQL queries to extract and manipulate data from large databases
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.