Columbia U.: Data and Research Analyst

Work closely with the Director to develop, manage, and maintain various data-driven processes and applications, including reporting and analysis, data integrity and security to support Columbia College and its units.

Columbia University, Columbia College At: Columbia University
Location: New York City, NY

DEPT/SCHOOL: Columbia College

Apply online.

**Recruiting for Two Open Positions**

BASIC FUNCTION: The Data & Research Analyst works closely with the Director to develop, manage, and maintain various data-driven processes and applications, including reporting and analysis, data integrity and security to support Columbia College and its units, which serve students in multiple schools including Columbia College and The Fu Foundation School of Engineering and Applied Science.

This includes working with large data sets, performing various processes including ETL, and expertly understanding various data sources to effectively perform analysis, assessment, and reporting. The incumbent is an integral member of a team that focuses on data mining, reporting, analysis, research design, implementation and analysis and will participate in implementing the strategic plan for the team to meet larger goals and objectives around analytics and data.


1. Work with the Director and partner offices to create, maintain and document innovative, user friendly, front end reporting tools and platforms that provide point and click ability to produce reports, for operational and analysis needs. Build and maintain databases and automate data processes, including ETL, SQL, stored procedures, SSRS, SSIS, etc, for in-house and third-party databases. Create and provide ad hoc reports and datasets in response to requests from various departments in Columbia College.

2. Provide quantitative and qualitative analysis and feedback for research, surveys, and assessments and help facilitate design, execution, and reporting on research findings for use in strategic planning and policy development/implementation across Columbia College. Create framework for forecasting and modeling projects.

3. Locate and evaluate available source data and extract, clean, and manipulate datasets for use. Facilitate processes that translate data into actionable insights in order to solve problems, provide insight, and optimize operational processes and improve efficiency. Develop procedures, reports, and processes to verify the integrity of information and ensure data security and maintain the quality and integrity of all data used to develop reports by creating processes to clean synchronize and/or update data.

4. Work with Director, Executive Director, and other team members to plan short and long-term projects, and participate in implementing strategic initiatives around research, forecasting, analysis, and reporting.

5. Work on special projects as deemed relevant, be available as needed for technical and other support during critical periods, and perform other related duties as assigned.

Bachelor's degree or equivalent required.
  • Minimum two years related experience or combination of education and experience required.
  • Proficiency in SQL and query and reporting analysis tools required.
  • Experience with data and analysis processes such as ETL, Cubes, and Reporting services required, Experience with Crystal Reports, SQL Server Reporting Services, or other enterprise level reporting tool is preferred.
  • Familiarity with database design, Visual Basic, relational database software or equivalent, and student information or related system.Knowledge of an object-oriented language such as Java, C++, desirable.
  • Knowledge of and experience with both qualitative and quantitative statistical methods in survey, research, or assessments is preferred.
  • Experience with statistical analysis software such as SPSS, R, and Python preferred.
  • Proficiency in MS Office, especially MS Excel and Word required.Ability to prioritize and manage multiple tasks under short and changing deadlines, while ensuring timely and accurate execution.
  • Proven ability to create project plans and successfully complete projects.
  • Excellent analytical, communication, organizational and interpersonal skills required; ability to analyze and interpret complex data sets, make findings relevant, and explain data and technology to a general (non-technical) audience.
  • Must be an innovative and analytical thinker who has the ability to work collaboratively and independently.
  • Excellent attention to detail as well as ability to conceive of the larger picture in relation to strategic planning required.
  • Must have the ability to exercise sound judgment, discretion and tact in a highly confidential professional setting.