Junior Data Analyst

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.