The Data and Research Analyst develops, manages, and maintains various data-
driven processes and applications for reporting and analysis related to
academic and curricular reporting for Columbia College. The Analyst supports
data integrity and data security, while working with large data sets and
performing various processes utilizing ETL. The incumbent will work with
various data sources to perform analysis, assessment, and reporting. As an
integral member of the team, the analyst will assist with data mining,
research design, and strategic goals and objectives around analytics and data.
This position works closely with Academic Planning and Administration, the
Committee on Instruction, and the Center for the Core Curriculum. The Center
for the Core Curriculum supports Columbia faculty, lecturers, post-doctoral
fellows and preceptors, representing over twenty departments, who teach in the
Core. The incumbent will model the need for Core sections and handle the Core
pre-registration and placement.
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.
Provide quantitative and qualitative analysis and feedback for research,
surveys, and assessments; help facilitate design, execution, and reporting
on research findings for use in strategic planning and policy
development/implementation. Create framework for forecasting and modeling
Research and evaluate available sources of data to 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.
Orchestrate student pre-registration data load via batch, with the
assistance of the Core Curriculum staff, of Core courses into the
University's student information system. Coordinate with partner offices
and relevant stakeholders to ensure accurate data for this pre-
Develop and maintain the enrollment model used for registration and
resource planning within the Core office.
Collate and analyze evaluation data to support data-informed decision
making by Core administrators and course chairs.
Create longitudinal analyses on enrollment behavior for College
administrators. Generate analyses for the Committee on Instruction (COI)
to support academic policy and decision making.
Collaborate with team members to plan short- and long-term projects, and
participate in implementing strategic initiatives around research,
forecasting, analysis, and reporting.
Work on special projects as deemed relevant and be available as needed for
technical and other support during critical periods.
Other related duties as assigned.
Bachelor's degree or equivalent required.
A minimum of 2 to 4 years of experience, or combination of education and
The ability to work with a high degree of independence and accountability
as a member of a cohesive team.
Excellent verbal and written communications skills.
Proficiency in SQL and query and reporting analysis tools including ETL,
cubes, and reporting services.
Familiarity with relational database design.
Proficiency with the Microsoft Office Suite, especially Excel.
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, 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)
Act as an analytical thinker with the ability to work collaboratively and
Must have the ability to exercise sound judgement, discretion and tact in
a highly confidential professional setting.
Applications received without a resume and cover letter will not be
Experience with SQL Server Reporting Services (SSRS) or other
enterprise-level reporting tool is preferred.
Knowledge of an object-oriented language such as Python or R.
Experience with both qualitative and quantitative statistical methods in
survey design, research, or assessments is preferred.
Experience using student information systems (SIS) and/or high-level
enterprise resource planning (ERP) systems.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Applications open: Jan 06 2022 Eastern Standard Time
The University of Gothenburg tackles society's challenges with diverse
for Collective Action Research, (CeCAR), Governance and Local Development
(GLD), and the Swedish National Election Studies Programme.
Local Development (GLD), directed by Professor Ellen Lust, is...
The Department of Ophthalmology at Stanford University School of Medicine is
seeking a highly motivated, hard-working, and professional Data Scientist to
across multiple departments, including Biomedical Data Science, Research IT,
The incumbent will work with...
The Advanced Cyberinfrastructure for Education and Research (ACER) is
growing our team of engineers, computational scientists, and data scientists
to deliver on UIC's inspiring 5-year (2021-2025) Research
ACER seeks a qualified Data Scientist to join...
Behavioral Sciences is seeking a Research Data Analyst 1 to manage and analyze
development and maintenance of our toolboxes and processing pipelines.
computational researchers to develop and scale up our current data processing
Intelligence, Machine Learning, Modeling/Simulation, Aerospace, Aircraft, Data
aerospace/mechanical data analysis to be part of a predictive maintenance and
Core job responsibilities include post-flight data analysis and conditioning,
python/Matlab algorithm development for modeling and trend analysis,...