Director, Financial Planning & Analysis – Auto
GEICO
SQL
Financial Analyst II
Health Care Service Corporation
full-time
Posted on:
Location Type: Hybrid
Location: Chicago • Illinois, Montana, New Mexico, Oklahoma, Texas • 🇺🇸 United States
Visit company websiteSalary
💰 $54,800 - $121,100 per year
Job Level
Mid-LevelSenior
Tech Stack
SQLVBA
About the role
- Performing moderate to complex Value Based Care Provider performance financial analyses
- Conducting financial modeling of Revenue and Cost contribution to VBC financial, MLR performance
- Preparing all necessary financial analyses and periodic financial statements
- Analyzing total cost of care and revenue trends
- Monitoring VBC contract financial performance across several programs
- Monitoring and performing contracted provider validation
- Establishing control analytics on various types of financial contractual arrangements
- Leading workgroup forums, creating presentations, and facilitating discussions across various functional leads
- Ensuring outcomes and standards are defined and executed as standard operating procedures
- Managing line of credit process and procedures and overseeing outstanding provider recoupments
Requirements
- Bachelor Degree in Accounting or Finance
- 4 years experience conducting financial analysis
- Ability to create Executive business level presentations related to financial topic
- Ability to inform VBC provider contract performance risks, and collaborate cross-functionally to perform corrective action when applicable
- Advance expertise PC experience in Windows, Word, Excel, Access, PowerPoint, and other business related/associated databases
- Knowledge of SQL (or similar languages such as VBA)
- Experience with Value Based Care arrangements
- Sponsorship will not be provided for this role
Benefits
- Health and wellness benefits
- 401(k) savings plan
- Pension plan
- Paid time off
- Paid parental leave
- Disability insurance
- Supplemental life insurance
- Employee assistance program
- Paid holidays
- Tuition reimbursement
- Other incentives
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
financial analysisfinancial modelingcost analysisrevenue analysiscontract validationcontrol analyticsSQLVBAfinancial statementsline of credit management
Soft skills
presentation skillscollaborationleadershipfacilitationcommunicationproblem-solvinganalytical thinkingcross-functional teamworkrisk assessmentstandard operating procedures
Certifications
Bachelor Degree in AccountingBachelor Degree in Finance
