The Cornell University Student Health Plan (CUSHP) is a self-funded insurance plan regulated under by the New York State Department of Financial Services and the Federal Department of Health and Human Services (HHS), and serves students of Cornell University and their qualified dependents. In its' fifth year of operation, the health plan is one of the ways in which Cornell University ensures its students have access to quality health care at a reasonable cost, enabling a student's readiness to engage socially and academically at the University.
The CUSHP provides multiple benefit products (SHP, SHP-Plus, Dental and Vision) serving the Ithaca and Cornell Tech campuses with an enrollment of ~12,000 covered lives and annual premiums in excess of $33M. The Analyst reports to the Director, Risk Management and Insurance and works with the Student Health Plan Manager who is charged with providing operational management for the CUSHP and ensuring financial and regulatory compliance with the Plan's Certificate of Authority. The analyst position supports all of the financial and data needs associated with CUSHP's Certificate of Authority.
This position is responsible for data and financial analyses associated with the Student Health Plan (SHP) products (SHP and SHP-Plus). The position focuses on financial controls (account reconciliations, claims payment reporting and reconciliations, variance analyses), routine analysis (supporting monthly, quarterly and year-end reporting), non-routine analysis (to assist with projects and process improvement), and support for SHP rate development, annual Data Requirements submission, and audit/examination proceedings. The position serves as initial resource for monthly financial and claim reconciliations, reports and analyses for both internal and external customers (including state and federal agencies), and conducts routine and ad hoc internal audits and transactions to identify and resolve underlying data and transactional issues.
The position also serves as a resource in Student Health Plan operational meetings (compiling materials and data for review and serving as a resource for analytical projects) and stakeholder committee meetings (preparing materials, coordinating schedules and timelines, and monitoring objectives and milestones).
Ours is a values based organization where all employees are accountable for supporting the organization's values of collegiality, integrity initiative, excellence, civility and stewardship as well as support university sustainability goals.
Bachelor's degree with at least 2 – 4 years' of experience working with data to provide financial or accounting decisions and support, or an equivalent combination of education and experience.
Proven written and oral communication skills.
Strong problem solving, critical thinking and logical reasoning skills.
Requires accuracy and attention to detail.
Ability to work under tight timelines and deadlines within the allocated budget, and handle confidential information.
Ability to work independently and with a team involved in common goals is a must.
Expert proficiency in Microsoft Office Suite, most importantly Excel, including the use of pivot tables.
Masters or other professional degree in related Health Care or business field, with experience in financial reporting and monitoring of health services and/or health insurance related data.
Experience in managing and using relational databases. Experience in reporting from health or insurance information systems.
Experience with data visualization tools (e.g. Tableau), with Hyperion Brio or other data query tools, and/or with statistical analysis software.
When applying through our system, please remember to attach your application materials (Resume/Cover Letter/CV) in either Microsoft Word or PDF format. In the Experience section of your application, use the 'Drop Files Here' box to manually drag document(s) into your application. For a more detailed description and instructions on how to apply online please click here as an external candidate or click here if you are an internal candidate. Please note: Cornell Employees must apply through the Internal Cornell Career site.
No Visa sponsorship is available for this position.
No relocation assistance is available for this position.
University Job Title:
Data Analyst II
Pay Rate Type:
Number of Openings:
If you currently work at Cornell University, please exit this website and log in to Workday using your Net ID and password. Select the Career icon on your Home dashboard to view jobs at Cornell.
Online Submission Guidelines:
Most positions at Cornell will require you to apply online and submit both a resume/CV and cover letter. You can upload documents either by ‘dragging and dropping’ them into the dropbox or by using the ‘upload’ icon on the application page. For more detailed instructions on how to apply to a job at Cornell, visit How We Hire on the HR website.
If you require an accommodation for a disability in order to complete an employment application or to participate in the recruiting process, you are encouraged to contact Cornell University's Office of Workforce Policy and Labor Relations at voice (607) 255-6866, fax (607) 255-0298, or email at firstname.lastname@example.org.
Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also visit the office of Workforce Recruitment and Retention Monday - Friday between the hours of 8:30 a.m. – 4:30 p.m. to use a dedicated workstation to complete an online application.
Notice to Applicants:
Please read the required Notice to Applicants statement by clicking here. This notice contains important information about applying for a position at Cornell as well as some of your rights and responsibilities as an applicant.
Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, Protected Veterans and Individuals with Disabilities. Cornell University is an innovative Ivy League university and a great place to work. Our inclusive community of scholars, students, and staff impart an uncommon sense of larger purpose, and contribute creative ideas to further the university's mission of teaching, discovery, and engagement.
Internal Number: WDR-00017291
About Cornell University
In 1865, Ezra Cornell founded an institution "where any person can find instruction in any study." From the beginning, all students were welcome, regardless of race, gender, ideology, or socioeconomic status. Today, we invite you to join our talented and diverse students and accessible faculty who, together, form a living and learning community unmatched in its breadth of opportunities.Cornell University's college, schools, and other academic units offer more than 4,000 courses, 70 undergraduate majors, 93 graduate fields of study, undergraduate and advanced degrees, and continuing education and outreach programs.