VillageCare is a community-based, not-for-profit organization serving people with chronic care needs. As a Senior Actuarial Data Analyst, you will develop and maintain reports and analytics to empower leadership with insights for financial success in the healthcare sector.
Responsibilities:
- Develop, document, and maintain reports and analytics that empower leadership with key insights to drive financial success
- Ensure the accuracy and timeliness of routine and ad hoc reports
- Collaborate closely with both internal and external customers to guarantee successful report roll-ups and high customer satisfaction
- Utilize advanced tools such as SQL, Tableau, and RedShift to create customized dashboards for the Finance department
- Work with the IT team to automate reports for efficient metric monitoring
- Support the monthly close process
- Conduct claim reserve analysis
- Create member economics reports to aid strategic decision-making
- Lead medical claims reinsurance reporting
- Support the preparation of provider group financial statements
- Ensure compliance with regulatory reporting requirements
Requirements:
- Minimum 5 years of relevant professional work experience
- Experience working in an actuarial function with a focus on building the claims reserve updating claims triangles and IBNR estimation
- Ability to perform complex data analysis and report/dashboard development in a health care setting
- Excellent technical skills (MS Excel, SQL, Tableau, Access, Python, etc.)
- Capacity to multi-task at high detail-oriented level
- Strong communication skills (verbal, written, presentation, interpersonal)
- Strong analytical and logical skills paired with strong attention to detail
- Bachelor's degree in Healthcare, Finance or relevant field or equivalent years of experience required