Edtech.com's Summary

Columbia University is hiring a Senior Operations and Data Analyst to support the Industrial Engineering and Operations Research Department. This role involves designing and maintaining automated data tools, managing admissions and academic data, generating reports and dashboards, and developing analytical models to enhance academic and operational functions.

Highlights

Design, build, and maintain automated tools and scalable workflows for academic, career, and operational processes.
Manage student and admissions data, ensuring accuracy and consistency across systems.
Develop reports, dashboards, and data visualizations for diverse academic and administrative stakeholders.
Create analytical models for scheduling, enrollment, and academic planning.
Provide technical and on-site support for departmental events and maintain departmental website content.
Proficient in programming/scripting languages such as Python and JavaScript, and skilled in SQL, Google Sheets, and Excel.
Experienced with CRM systems, preferably Slate, and integrating multiple institutional data sources.
Minimum of a bachelor's degree or equivalent experience with 3–5 years of relevant data experience; graduate-level education preferred.
Strong analytical, problem-solving, and communication skills with ability to work independently and manage priorities.
Salary range: $85,000 to $93,500, based on qualifications and experience.

Senior Operations and Data Analyst Full Description

Position Summary

Reporting to the Director of Academic and Student Affairs. The Senior Operations and Data Analyst enables efficient, data-driven management and support of the academic, admissions, career, and operational functions of the Industrial Engineering and Operations Research (IEOR) Department.

Responsibilities

Data Systems, Automation & Applications (30%):

Design, build, and maintain automated tools and scalable workflows to support academic, career, and operational processes across different functional teams within the department.
Develop, optimize, and manage internal databases, data pipelines, and centralized repositories that integrate and synchronize multiple institutional data sources.
Create, deploy, document, and maintain in-house applications and system integrations to streamline cross-functional operations.
Automate recurring administrative and reporting tasks using scripting, macros, APIs, and platform-specific automation tools to improve efficiency and reduce manual errors.

Academic & Admissions Operations Support (30%):

Manage and maintain student and admissions data across internal systems, repositories, and communication platforms, ensuring data integrity and consistency.
Support admissions operations by building, refining, and maintaining queries, reports, dashboards, and tracking tools for application and enrollment management in Slate CRM.
Monitor, audit, and validate data accuracy across systems; investigate discrepancies and implement corrective workflows to maintain compliance and reliability.
Enhance staff workflows by designing structured data tools, templates, and documentation that improve operational transparency and collaboration.

Reporting, Communication & Data Access (20%):

Create, maintain, and automate reports, dashboards, and data visualizations tailored to stakeholders across academic and administrative teams.
Manage large-scale, data-driven communications, including automated mail merges, targeted outreach campaigns, and dynamic distribution lists.
Navigate and integrate emerging data systems and institutional platforms to respond efficiently to complex reporting and analysis requests.
Translate complex datasets and technical findings into clear, structured, and actionable insights for non-technical stakeholders and leadership.

Analytics, Algorithms & Optimization (15%):

Develop analytical models and logic frameworks to support tasks like matching, scheduling, and enrollment management, while identifying conflicts.
Build projection, simulation, and modeling tools to support academic planning.
Analyze historical academic, admissions, and operational data to generate reports, trend analyses, forecasts, and decision-support insights.

Administrative and Events Operations (5%):

Provide on-site support for departmental events, programs, and initiatives as needed.
Offer technical support during events, including setup and troubleshooting of presentation equipment, software, and virtual platforms.
Provide and update content for the Departmental website in the areas of admissions, academic and student affairs, and curricular changes.
Other tasks as needed.

Minimum Qualifications

A bachelor's degree or equivalent experience is required; graduate-level work is preferred. Minimum of 3–5 years of experience working with data.

Technical Skills: Experience with programming or scripting (Python, JavaScript, macros) and automating tasks.
Data Skills: Experience managing and organizing data, creating reports, and using tools like SQL, Google Sheets, and Excel.
Systems & Integrations: Familiarity with CRMs (Slate preferred), internal tools, and connecting different systems for smooth workflows.
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 communicator with both technical and non-technical audiences; adaptable, collaborative, forward-thinking, and solution-oriented.

Ability to work independently and under pressure, with a high level of attention to detail. Must be able to prioritize multiple tasks with minimal supervision.

Candidates must exercise good judgment and flexibility, with a student-wellness mindset. Positive, mission-oriented, forward-thinking attitude.

Salary Range: $85,000 to $93,500

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.

Equal Opportunity Employer / Disability / Veteran

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

Original Job Description

Position Summary

Responsibilities

Data Systems, Automation & Applications (30%):

Design, build, and maintain automated tools and scalable workflows to support academic, career, and operational processes across different functional teams within the department.
Develop, optimize, and manage internal databases, data pipelines, and centralized repositories that integrate and synchronize multiple institutional data sources.
Create, deploy, document, and maintain in-house applications and system integrations to streamline cross-functional operations.
Automate recurring administrative and reporting tasks using scripting, macros, APIs, and platform-specific automation tools to improve efficiency and reduce manual errors.

Academic & Admissions Operations Support (30%):

Manage and maintain student and admissions data across internal systems, repositories, and communication platforms, ensuring data integrity and consistency.
Support admissions operations by building, refining, and maintaining queries, reports, dashboards, and tracking tools for application and enrollment management in Slate CRM.
Monitor, audit, and validate data accuracy across systems; investigate discrepancies and implement corrective workflows to maintain compliance and reliability.
Enhance staff workflows by designing structured data tools, templates, and documentation that improve operational transparency and collaboration.

Reporting, Communication & Data Access (20%):

Create, maintain, and automate reports, dashboards, and data visualizations tailored to stakeholders across academic and administrative teams.
Manage large-scale, data-driven communications, including automated mail merges, targeted outreach campaigns, and dynamic distribution lists.
Navigate and integrate emerging data systems and institutional platforms to respond efficiently to complex reporting and analysis requests.
Translate complex datasets and technical findings into clear, structured, and actionable insights for non-technical stakeholders and leadership.

Analytics, Algorithms & Optimization (15%):

Develop analytical models and logic frameworks to support tasks like matching, scheduling, and enrollment management, while identifying conflicts.
Build projection, simulation, and modeling tools to support academic planning.
Analyze historical academic, admissions, and operational data to generate reports, trend analyses, forecasts, and decision-support insights.

Administrative and Events Operations (5%):

Provide on-site support for departmental events, programs, and initiatives as needed.
Offer technical support during events, including setup and troubleshooting of presentation equipment, software, and virtual platforms.
Provide and update content for the Departmental website in the areas of admissions, academic and student affairs, and curricular changes.
Other tasks as needed.

Minimum Qualifications

A bachelor's degree or equivalent experience is required; graduate-level work is preferred. Minimum of 3–5 years of experience working with data.

Technical Skills: Experience with programming or scripting (Python, JavaScript, macros) and automating tasks.
Data Skills: Experience managing and organizing data, creating reports, and using tools like SQL, Google Sheets, and Excel.
Systems & Integrations: Familiarity with CRMs (Slate preferred), internal tools, and connecting different systems for smooth workflows.
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 communicator with both technical and non-technical audiences; adaptable, collaborative, forward-thinking, and solution-oriented.

Ability to work independently and under pressure, with a high level of attention to detail. Must be able to prioritize multiple tasks with minimal supervision.

Candidates must exercise good judgment and flexibility, with a student-wellness mindset. Positive, mission-oriented, forward-thinking attitude.

Salary Range: $85,000 to $93,500

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.

Senior Operations and Data Analyst

Edtech.com's Summary

Senior Operations and Data Analyst Full Description

CPMS Systems Administrator / Information Technologist II

College of Arts & Letters, Information Technology – Student Assistant

Digital Workspace Analyst

Associate Data Center Administrator

Student Computer Support Technician - SAAC