Senior Financial Data Analyst

VillageCare; New York (NY); Hybrid; USD 88,000 - 99,000; Full time

Job summary

VillageCare in New York, NY, is hiring a Senior Financial Data Analyst in a hybrid role (must reside in NY/NJ/CT). The position combines finance analytics, reporting, and regulatory compliance to drive financial strategy.

Expect a $87,647.11 to $98,603.00 salary with work-from-home flexibility and Monday–Friday schedule. As a Senior Financial Data Analyst, you will build and automate dashboards using SQL, Tableau and RedShift, support monthly close, and conduct reserve analyses to guide

Qualifications

• Minimum 5 years of relevant professional work experience in a healthcare setting.
• Experience in an actuarial function focusing on claims reserves, claims triangles and IBNR estimation.
• Proficiency in MS Excel, SQL, Tableau, Access and Python for data analysis and reporting.

Responsibilities

• Develop, document and maintain reports and analytics for leadership insights.
• Support monthly close process and claim reserve analyses.
• Create member economics reports to aid strategic decision-making.
• Lead medical claims reinsurance reporting and provider group financial statements.
• Ensure compliance with regulatory reporting requirements.

Skills

MS Excel

SQL

Tableau

Access

Python

RedShift

Education

Bachelor's degree in Healthcare, Finance or related field

Tools

RedShift

Job description

Location: Hybrid (Must Reside in NY/NJ/CT)

Work Schedule: Monday - Friday, 9:00am - 5:00pm

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. This position offers work-from-home flexibility, allowing you to balance your professional responsibilities with your personal life while contributing to meaningful healthcare solutions. Based in New York, NY, you will be part of a dedicated team that values excellence and customer-centricity in its mission to provide outstanding healthcare services. Your analytical expertise will drive decision‑making in an energetic and forward‑thinking environment.

With a competitive salary range of $87,647.11 to $98,603.00, this opportunity not only offers rewarding challenges but also financial recognition for your skills and contributions.

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 health care services to individuals residing within New York City for over 45 years.

Make a difference as a Senior Financial Data Analyst - Healthcare

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, all while demonstrating VillageCare's commitment to Service Excellence.

Does this sound like you?

To excel as a Senior Financial Data Analyst at VillageCare, you will need a robust skill set and a solid professional background. A minimum of five years of relevant experience, particularly in an actuarial role focused on claims reserves, claims triangles, and IBNR estimation, is essential. Your ability to conduct complex data analyses and develop insightful reports and dashboards in a healthcare environment will be crucial. Proficiency in technical tools such as MS Excel, SQL, Tableau, Access, and Python is required, enabling you to manipulate and present data effectively. Additionally, the capacity to multi‑task while maintaining a high level of attention to detail is vital for success in this role.

Strong communication skills, both verbal and written, along with robust presentation capabilities, will enhance collaboration with internal and external stakeholders. A Bachelor's degree in Healthcare, Finance or a related field is required, or equivalent years of experience, to support your analytical and problem‑solving abilities in a fast‑paced setting.

Knowledge and skills required for the position are:

• 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
• Capacity to multi‑task at high detail‑oriented level
• 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.