The Institutional Research and Data Analyst

Columbia University in the City of New York

New York (NY)

On-site

USD 80,000 - 90,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Columbia University in the City of the City of New York seeks an Institutional Research and Data Analyst to support reporting, data governance, and data hub initiatives. The role focuses on SQL data extraction, reproducible workflows, and collaboration with multiple university offices.

Responsibilities include preparing recurring reports and dashboards, ensuring data quality, and translating complex data into clear insights for diverse audiences.

Qualifications

  • Experience with relational databases and hands-on SQL to join, aggregate, transform, and validate data.
  • Experience developing recurring reports, reproducible workflows, and data quality checks.
  • Experience with Power BI, Tableau, Oracle Analytics Cloud, or comparable tools; Excel proficiency.

Responsibilities

  • Prepare and validate recurring federal, state, accreditation, and other required reports; track deadlines and submissions.
  • Compile data for Statistical Abstract, Columbia FACTS, and Common Data Set; produce dashboards.
  • Develop, maintain, and improve recurring reports; respond to ad hoc data requests.
  • Translate institutional questions into analyses; communicate findings clearly.
  • Automate recurring extraction, validation, and report preparation; maintain code and run instructions.

Skills

Relational databases
Hands-on SQL
Data analysis
Power BI
Tableau
Oracle Analytics Cloud
Excel
Communication
Deadline management

Education

Bachelor's degree in social science, information or data science, statistics, computer science, business analytics, or related field

Tools

SQL Server

Job description

  • Job Type: Officer of Administration
  • Regular/Temporary: Regular
  • Hours Per Week: 35
  • Salary Range: $80,000-$90,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

Position Summary

The Office of Planning and Institutional Research (OPIR), in the Office of the Provost at Columbia University, supports senior leadership in advancing institutional goals through rigorous data collection, analysis, and reporting. OPIR’s mission is to enable strategic, evidence-based decision making by delivering timely insights into the University’s academic, administrative, and operational landscape.

The Institutional Research and Data Analyst (Analyst) is an integral member of the OPIR team, supporting institutional reporting, data integrity, and data governance. Working closely with OPIR leadership and stakeholders across the University, the Analyst prepares recurring compliance reports and contributes to public-facing resources, including the Statistical Abstract, Columbia FACTS, and the Common Data Set.

The position uses strong hands‑on SQL skills to extract, transform, reconcile, and analyze complex administrative datasets covering enrollment, employees, salaries, tuition, finance, financial aid, research, facilities, and space. The Analyst translates these data into clear reports and visualizations for technical and non-technical audiences.

The Analyst also strengthens workflows through consistent standards, clear documentation, and automation. The position will play an instrumental role in implementing OPIR’s data hub as a reliable, well-documented source of information for university stakeholders. This is an opportunity for a skilled and strategic researcher to contribute to high-impact, collaborative, and fast-evolving institutional initiatives.

Responsibilities
Institutional Reporting and Analysis
  • Prepare and validate recurring federal, state, accreditation, and other required reports assigned to OPIR; track deadlines, document requirements, and assemble submissions for review and approval by designated University officials.
  • Compile and reconcile data for the Statistical Abstract, Columbia FACTS, the Common Data Set, and other institutional publications and surveys.
  • Develop, maintain, and improve recurring reports and dashboards; respond to ad hoc data requests as they arise.
  • Apply consistent reporting specifications, population definitions, time periods, and calculation methods across reporting products.
  • Translate institutional questions into analyses and reporting specifications; communicate findings, trends, and limitations clearly.
Data Management Governance and Reporting Workflows
  • Write, test, and maintain SQL queries, joins, transformations, and stored procedures in approved reporting environments, including SQL Server, to prepare reproducible datasets and reporting outputs.
  • Validate record counts, reconcile totals to source systems and prior submissions, investigate discrepancies with data owners, and document resolutions and quality checks.
  • Automate recurring extraction, validation, and report preparation within approved tools; maintain reusable code, change histories, run instructions, and checks for failed or incomplete refreshes.
  • Maintain data dictionaries, business definitions, source mappings, reporting logic, and lineage for OPIR reporting assets and the institutional data hub.
  • Follow approved data governance, access, confidentiality, and retention practices; identify data quality issues and recommend improvements to OPIR leadership and data stewards.
Institutional Data Hub and Collaboration
  • Support OPIR’s institutional data hub by defining analytical requirements, preparing and validating reporting datasets, and testing data integration and reporting changes with CUIT.
  • Collaborate with CUIT, Human Resources, Finance, schools, and other data owners to clarify definitions, resolve reporting discrepancies, and document accepted business rules.
  • Develop clear visualizations and support users in interpreting reporting outputs; stay current with institutional research, higher education reporting, and analytical practices.
Minimum Qualifications
  • Bachelor's degree in social science, information or data science, statistics, computer science, business analytics, or a related field, or an equivalent combination of education and experience, with 3-5 years of relevant professional experience.
  • Demonstrated experience using relational databases and hands‑on SQL to join, aggregate, transform, and validate complex data.
  • Experience developing recurring reports, reproducible reporting workflows, and data quality checks.
  • Experience with Power BI, Tableau, Oracle Analytics Cloud, or comparable reporting and visualization tools; proficiency with Excel.
  • Strong analytical, organizational, and communication skills, including the ability to explain technical concepts and findings to diverse audiences.
  • Ability to manage competing deadlines accurately, work collaboratively in a complex organization, and exercise discretion with confidential data.
Preferred Qualifications
  • Experience in higher education or institutional research, particularly with federal and state compliance reporting, institutional data governance, SQL Server, and reporting automation.
  • Experience with compliance reporting, SQL Server, data governance, reporting automation, or analysis using R or Python.
Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Decision Support Research Analyst
Decision Support Research Analyst

Columbia University • New York (NY)

On-site
USD 75,000 - 105,000
Operations and Data Analyst
Operations and Data Analyst

Columbia University • New York (NY)

On-site
USD 67,000 - 83,000
Full Time Institutional Research Analyst (On-Site Presence)
Full Time Institutional Research Analyst (On-Site Presence)

NC Community Colleges • Hamlet (NC)

On-site
USD 54,000 - 81,000
Full Benefits
Data Reporting & Query Analyst
Data Reporting & Query Analyst

Community College of Philadelphia • Philadelphia

On-site
USD 75,000 - 105,000
Institutional Data Analyst & Insights Lead
Institutional Data Analyst & Insights Lead

Columbia University in the City of New York • New York (NY)

On-site
USD 80,000 - 90,000
Institutional Research Programmer Analyst
Institutional Research Programmer Analyst

University of Idaho Careers • Moscow (ID)

On-site
USD 65,000 - 73,000
On-site work
Monitoring, Evaluation, and Learning Data Analyst
Monitoring, Evaluation, and Learning Data Analyst

Columbia University • New York (NY)

On-site
USD 66,000 - 74,000
Institutional Research Programmer Analyst
Institutional Research Programmer Analyst

University of Idaho • Moscow (ID)

On-site
USD 65,000 - 73,000
Data Analyst
Data Analyst

Tyler Junior College • Tyler (TX)

On-site
USD 55,000 - 85,000
Academic Division Data Analyst
Academic Division Data Analyst

Denison University • Granville Township (OH)

On-site
USD 55,000 - 75,000