Edtech.com's Summary

Columbia University is hiring an Operations and Data Analyst to support data systems and reporting for the Department of Industrial Engineering and Operations Research. The role maintains admissions and academic data across Slate and other institutional systems while building dashboards, automations, and recurring reports for departmental stakeholders. It also troubleshoots data issues and translates outputs into clear summaries for non-technical audiences.

Highlights

Maintains departmental data tools, workflows, and integrations across academic, admissions, and career functions
Executes recurring automations for scheduled data refreshes and standardized reporting
Supports admissions operations in Slate, maintaining queries, dashboards, and tracking tools
Conducts routine data audits and resolves discrepancies across systems
Produces dashboards and data visualizations for departmental stakeholders
Runs established analyses for scheduling, enrollment management, and capacity planning
Provides on-site technical support for departmental events and programs
Requires a bachelor's degree and at least 2 years of experience working with data
Offers a salary range of $67,300-$83,000 for the 35-hour-per-week role
Calls for familiarity with Python, SQL, Excel, and CRM systems such as Slate

Operations and Data Analyst Full Description

Position Summary

Under general supervision of the Senior Associate Director of Academic and Student Affairs, the Operations and Data Analyst provides operational and technical support for established data systems, reporting, and routine automation used across the academic, admissions, career, and administrative functions of the IEOR Department. Duties vary and the incumbent exercises judgment in selecting appropriate methods to complete assignments, verifying the accuracy of data and outputs, and taking corrective action when needed. Work products (e.g., reports, dashboards, queries, documentation, and data extracts) are relied upon as final source material, with review conducted periodically and/or on a sample basis.

The position focuses primarily on maintaining existing systems and reports, executing recurring processes, ensuring data integrity, and responding to department reporting and operational needs. The role collaborates with staff and stakeholders to support consistent use of tools, improve efficiency through incremental enhancements, and escalate complex technical issues as appropriate.

Responsibilities

Data Systems, Automation & Applications (30%)

Maintain and support departmental data tools, workflows, and integrations used for academic, admissions, career, and operational processes
Execute and maintain recurring automations for routine tasks such as scheduled refreshes, standardized data pulls, and notifications, updating scripts and workflows as requirements change
Document data processes, configurations, and standard operating procedures to promote continuity and consistent usage
Monitor system performance and data flows, implement corrective updates for routine failures, and escalate complex issues to appropriate technical resources

Academic & Admissions Operations Support (30%)

Maintain student and admissions data across approved systems, repositories, and communication platforms, ensuring accuracy, consistency, and appropriate access
Support admissions operations in Slate by maintaining existing queries, reports, dashboards, and tracking tools, and implementing updates aligned to admissions cycle needs
Conduct routine audits and validations of data across systems, investigating discrepancies and documenting resolutions
Update and maintain structured templates, shared tools, and operational documentation that support transparent workflows and cross-team coordination
Troubleshoot routine data and system issues, coordinating with colleagues and vendors on issues requiring elevated support

Reporting, Communication & Data Access (15%)

Produce and maintain recurring reports, dashboards, and data visualizations for departmental stakeholders, ensuring timely refresh and accuracy
Respond to standard and ad hoc reporting requests by extracting data from departmental and institutional systems
Translate data outputs into clear summaries for non-technical stakeholders, including definitions, assumptions, and known limitations
Maintain distribution methods and access pathways, such as shared drives, dashboards, and scheduled sends, in accordance with University data practices

Analytics, Algorithms & Optimization (15%)

Maintain existing analytical logic, templates, and models that support scheduling, matching, enrollment management, and related processes
Run established analyses such as trend summaries, cycle metrics, and capacity/scheduling checks, flagging conflicts or anomalies for follow-up
Prepare tables, charts, and standardized summaries for leadership and operational teams to support routine planning and decision-making

Administrative and Events Operations (5%)

Provide on-site operational and technical support for departmental events and programs, including set-up and troubleshooting of presentation and virtual meeting tools
Maintain designated sections of the departmental website related to admissions, academic and student affairs, and curriculum updates
Perform related duties and responsibilities as assigned

Minimum Qualifications

A bachelor’s degree or equivalent experience is required; graduate-level work is preferred
Minimum of 2 years of experience working with data
Technical Skills: familiarity with programming, scripting, or automation tools such as Python, JavaScript, macros, or similar technologies
Data Skills: experience working with data and reporting tools such as SQL, Excel, and Google Sheets
Systems: ability to learn and work within CRM and institutional systems, with experience with Slate or a similar CRM preferred
Problem-Solving & Learning: ability to troubleshoot data or system issues, understand how systems work, and quickly learn new tools
Professional Strengths: strong analytical and problem-solving skills, clear communication with technical and non-technical audiences, and an adaptable, collaborative, forward-thinking mindset
Ability to work independently and under pressure, with a high level of attention to detail and the ability to prioritize multiple tasks with minimal supervision
Exercises good judgment and flexibility, with a student-wellness mindset and a positive, mission-oriented, forward-thinking attitude

Equal Opportunity Employer / Disability / Veteran

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

Let me find your next job.

Thanks - you're signed up.

Operations and Data Analyst

Edtech.com's Summary

Operations and Data Analyst Full Description

Manager, Endpoint Security & M365 Engineering

Director of Software Applications and Support

Computing Support Specialist

System Integration Engineer - Rivier University, Nashua, NH

AI Governance Lead