Senior Actuarial Data Analyst - Healthcare

Must reside in NY, NJ or CT. Join VillageCare as a Full-Time Senior Financial Data Analyst in the dynamic healthcare sector and play a pivotal role in shaping the financial strategies that impact our community.

About the role

As a Senior Financial Data Analyst at VillageCare, you will play a crucial role in developing, documenting, and maintaining reports and analytics that empower leadership with key insights to drive financial success. You will ensure the accuracy and timeliness of routine and ad hoc reports, collaborating closely with both internal and external customers to guarantee successful report roll-ups and high customer satisfaction. Utilizing advanced tools such as SQL, Tableau, and RedShift, you will create customized dashboards for the Finance department, while working with the IT team to automate these reports for efficient metric monitoring.

Your responsibilities will also include supporting the monthly close process, conducting claim reserve analysis, and creating member economics reports to aid strategic decision-making. Additionally, you will lead medical claims reinsurance reporting, support the preparation of provider group financial statements, and ensure compliance with regulatory reporting requirements.

Responsibilities

• Develop, document, and maintain financial reports and analytics
• Ensure accuracy and timeliness of routine and ad hoc reports
• Collaborate with internal and external customers for successful report roll-ups
• Create customized dashboards for the Finance department using SQL, Tableau, and RedShift
• Automate reports for efficient metric monitoring in collaboration with the IT team
• Support the monthly close process
• Conduct claim reserve analysis and create member economics reports
• Lead medical claims reinsurance reporting
• Support 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 healthcare setting
• Proficiency in MS Excel, SQL, Tableau, Access, and Python
• Capacity to multi-task at a 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

Benefits

• Work-from-home flexibility

Pay

$87,647.11 - $98,603.00

About VillageCare

VillageCare is a community-based, not-for-profit organization serving people with chronic care needs, as well as seniors and individuals in need of continuing care and managed care services. Our mission is to promote healing, better health, and well-being to the fullest extent possible. Our care is offered through a comprehensive array of community and residential programs, as well as managed care. VillageCare has delivered quality healthcare services to individuals residing within New York City for over 45 years.