Career Center

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

Position Summary

The Office of Planning and Institutional Research (OPIR), part of the Office of the Provost, supports Columbia???s senior leadership through the collection, analysis, and reporting of data on issues of institutional importance. Reporting to the Associate Provost, the Research Analyst contributes to and collaborates with other team members to help realize the goals of the office???s goals of presenting important institutional data to diverse audiences and executing research projects that address strategic questions for the University.

Responsibilities

• Producing research reports and briefs relating to survey data, student outcomes, faculty trends, and research funding, among other topics, and presenting these findings to audiences internal and external to the University.
• Designing and updating automated reports for University constituents, using business intelligence software for data visualization or other reporting tools.
• Responding to surveys and requests for information about the University and its schools from various external entities including but not limited to the Middle States Commission, New York State Education Department, National Council for State Authorization Reciprocity Agreements (SARA), and the federal National Center for Education Statistics (IPEDS).
• Working with colleagues across the University on Provost???s Office projects to collect and summarize data for internal reporting and to inform decision-making.
• Assisting with the design, documentation, development, maintenance, and oversight of OPIR website and database.
• Ensuring data integrity and consistency across multiple institutional data systems through systems design, planning, and data cleaning/reconciliation, often in collaboration with administrative teams around the University.
• Other related duties, as assigned.

Minimum Qualifications

• B.A. and/or its equivalent required. Two years??? relevant data science and/or quantitative research experience required, including familiarity with extracting data and producing basic descriptive statistics.

Preferred Qualifications

• Master???s degree in statistics, computer science, information technology, social science, or related discipline.
• Project Management Experience
•  

Other Requirements

• Experience with the Microsoft Office suite, particularly Excel and PowerPoint.
• Data visualization: Graphical reports and interactive dashboards; advanced design of visualizations in statistical software packages such as R or JavaScript-based visualization packages; business intelligence software; Drupal, HTML/CSS.
• Statistical and empirical analysis: Statistical packages such as Stata, SPSS, R, or Python data analysis libraries; survey design and analysis.
• Data management: Data warehousing; process automation; advanced SQL syntax; relational database design; data dictionaries and metadata; version control.
• Experience with scripting languages such as Python or Perl. Interest in large datasets and producing analyses from multiple, unstructured data sources.

Note: Finalists will be expected to demonstrate basic SQL and statistical proficiency, and will be asked to submit samples of their work.  

Hybrid work possible

A resume and cover letter must be submitted to be considered for the position.

Equal Opportunity Employer / Disability / Veteran

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

About Columbia University

Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.

Connections working at Columbia University