Junior Data Analyst
Weill Cornell MedicineAbout the role
Title: Junior Data Analyst
Location: Midtown
Org Unit: Institutional Reporting
Work Days:
Weekly Hours: 35.00
Exemption Status: Exempt
Salary Range: $74,700.00 - $84,100.00
*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices
Position Summary
Supports Budget & Financial Strategy and Institutional Reporting efforts by collecting, validating, and analyzing institutional data, maintaining reports and dashboards, and assisting in generating accurate, actionable insights to inform decision-making.
Job Responsibilities
- Generate and maintain recurring reports (monthly/quarterly budget reports, KPI tracking).
- Update and refresh dashboards (e.g., Power BI, Tableau) using pre-built data models.
- Ensure reports are accurate, timely, and clearly formatted for stakeholders.
- Assist in report automation efforts (e.g., Excel, SQL, Python).
- Pull and consolidate data from systems such as: Financial/HR ERP systems, Student Information Systems (SIS), Faculty Affairs SQL database, and other systems as assigned.
- Clean and validate datasets to ensure accuracy and consistency.
- Flag data discrepancies and escalate issues to senior team members.
- Perform descriptive analysis (trends, averages, growth rates) on financial and enrollment data.
- Create visualizations (charts, tables, dashboards) for internal use.
- Gather data from departments for surveys, rankings, and other reporting needs.
- Performs other related duties as directed.
Education
- Bachelor's Degree
Experience
Approximately 2 years of related experience.
Knowledge, Skills and Abilities
- Excel (advanced formulas, pivot tables)
- SQL (basic queries and joins)
- Visualization tools (Power BI, Tableau)
- Excellent communication skills (both verbal and written).
Licenses and Certifications
Working Conditions/Physical Demands
Ability to travel to and work in multiple locations as needed.
Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of “any person, any study.” No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law.
Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s