Lead Enrollment Analyst

Teachers College, Columbia University; New York (NY); Hybrid; USD 88,000 - 95,000; Full time

Job summary

Teachers College, Columbia University seeks a Lead Enrollment Analyst to advance predictive analytics, enrollment intelligence, financial aid modeling, and market research to guide data-informed enrollment planning and decision-making. The role focuses on transforming complex data into actionable insights supporting yield forecasting, tuition revenue planning, and strategic priorities.

The incumbent will build predictive models, data pipelines, and reporting solutions using SQL, Python/R, and

Qualifications

• Bachelor's degree in a quantitative field
• 5+ years of data analytics or related experience
• Proficiency in SQL and programming languages (Python/R)
• Experience developing predictive models and handling large datasets
• Experience designing interactive dashboards (Tableau)
• Ability to communicate complex findings to technical and non-technical audiences
• Strong project management and analytical skills

Responsibilities

• Apply advanced statistical methods, predictive analytics, and ML to support enrollment planning
• Develop and maintain predictive models for yield forecasting and retention analyses
• Create Tableau dashboards and executive reports for stakeholders
• Perform market research and competitive benchmarking to identify enrollment trends
• Extract, integrate, and analyze data from multiple sources and build data pipelines
• Collaborate with enrollment management and IT to support data-informed decision-making
• Share knowledge and provide guidance on Tableau, analytics, and data troubleshooting

Skills

SQL

Python

R

Data visualization

Communication of analytics

Education

Bachelor's degree in Data Science/Statistics/Applied Math/CS/Economics/Analytics

Master's degree preferred

Tools

Slate CRM

Tableau

Pentaho/BI tools

Job description

The Division of Enrollment Management is seeking a Lead Enrollment Analyst who will provide advanced analytical expertise in predictive modeling, strategic enrollment intelligence, financial aid analytics, and market research to support data-informed enrollment planning and institutional decision-making.

Job Summary/Basic Function

The Lead Enrollment Analyst will serve as a subject matter expert, advancing the College’s use of predictive analytics, strategic enrollment intelligence, financial aid modeling, and market research to support enrollment institutional planning and decision-making. Reporting to the Director of Enrollment Research and Strategy, the incumbent will be responsible for transforming complex institutional and external data into actionable insights that inform enrollment growth, student success, tuition revenue planning, and long-term strategic priorities. The Lead Enrollment Analyst will apply advanced analytical methodologies to transform complex institutional and external data into strategic insights that support enrollment planning and institutional decision-making. Utilizing SQL and other programming languages (e.g., Python, R), and advanced visualization tools, the incumbent will develop predictive models, build and maintain data pipelines, and create sophisticated reporting solutions that support yield forecasting, enrollment trend analysis, attrition risk identification, financial aid optimization, and tuition revenue planning. Working closely with enrollment leaders and campus stakeholders, the Lead Enrollment Analyst will provide analytical expertise that advances data-informed decision-making and supports the College's strategic enrollment priorities.

Characteristic Duties And Responsibilities

Predictive Analytics & Statistical Modeling

• Apply advanced statistical methodologies, predictive analytics, and machine learning techniques and related tools to support strategic enrollment planning and institutional decision-making
• Develop and maintain predictive models related to yield forecasting, melt risk identification, enrollment pipeline health, and student retention analyses
• Conduct complex analyses and translate findings into actionable recommendations that support recruitment strategies, enrollment planning, and resource allocation decisions.

Financial Aid Modeling & Optimization

• Develop and maintain financial aid and enrollment models to assess the relationship between aid strategies, enrollment outcomes, and tuition revenue
• Utilize regression analyses and other statistical methodologies to support enrollment forecasting, scenario planning, and merit aid optimization.
• Provide analytical support for strategic financial aid decisions and enrollment management initiatives.

Advanced Data Visualization & Executive Reporting

• Design, develop, and maintain Tableau dashboards, executive reports, and interactive reporting tools that support data-informed decision-making
• Create visualizations and reporting solutions that effectively communicate enrollment trends, forecasts, and outcomes to a variety of stakeholders
• Ensure the accuracy, consistency, and usability of enrollment reporting resources across the College.

Market Research & Competitive Benchmarking

• Conduct market research, competitive benchmarking, demographic analyses, and prospective student studies to identify trends and opportunities impacting enrollment performance
• Analyze internal and external data sources to support recruitment strategies, program planning, and enrollment initiatives
• Provide insights regarding market conditions, student demand, and competitor activity to support strategic planning efforts

Data Management & Systems Integration

• Extract, integrate, validate, and analyze data from multiple internal and external sources to support enrollment analytics and reporting needs
• Develop and maintain complex datasets, automated reporting processes, and data pipelines that improve data accessibility, quality, and efficiency
• Utilize Slate CRM and other institutional systems to support data collection, analysis, reporting, and forecasting activities.

Collaboration & Subject Matter Expertise

• Serve as a resource to Enrollment Management and institutional stakeholders on enrollment analytics, reporting methodologies, and data visualization best practices
• Develop analytical resources and foundational datasets that support research, reporting, and strategic planning efforts across the division
• Collaborate with colleagues across Enrollment Management, Institutional Research, Information Technology, and other campus partners to support data-informed decision-making
• Share knowledge and provide guidance to colleagues and student employees regarding Tableau, statistical analysis, reporting practices, and data troubleshooting
• Other duties as assigned

Minimum Qualifications

• Bachelor's degree in Data Science, Statistics, Applied Mathematics, Computer Science, Economics, Information Technology, Analytics, or a related quantitative field
• Five (5) + years of progressively responsible experience in data analytics, institutional research, business intelligence, data science, enrollment analytics, or a related field
• Advanced proficiency in SQL and demonstrated experience utilizing Python, R, or comparable statistical programming languages
• Experience developing predictive models, conducting advanced statistical analyses, and working with large, complex datasets
• Experience designing and maintaining interactive dashboards and business intelligence solutions utilizing Tableau or similar platforms
• Demonstrated ability to communicate complex analytical findings to both technical and non-technical audiences
• Strong project management, problem-solving, and analytical skills.

Preferred Qualifications

• Master's degree in Data Science, Statistics, Applied Mathematics, Analytics, Computer Science, Economics, Higher Education Administration, or a related field
• Experience developing machine learning models and predictive analytics solutions
• Experience supporting enrollment management, admissions, financial aid, institutional research, or higher education strategy functions
• Experience with Slate CRM, Banner, Argos, Tableau, and higher education reporting systems
• Knowledge of enrollment forecasting, financial aid modeling, tuition revenue planning, and market research methodologies
• Demonstrated experience translating data into strategic recommendations for executive leadership.

Salary Range

$88,000 - $95,000

Work Modality

Hybrid

Competitive Compensation And Benefits

The salary range reflects the College’s good faith and reasonable estimate of the compensation for the position at the time of the job posting. Salary decisions are dependent on several factors including but not limited to market and organizational considerations, experience, and qualifications of a selected candidate as well as internal and external equity. Our benefits contribute significantly to the total compensation package that includes medical, dental, vision, and supplemental insurance plans; flexible and hybrid work schedules; tuition remission; life insurance; short- and long-term disability insurance; an exceptional employer retirement matching program; health savings accounts (HSA), flexible spending accounts (FSA), Public Service Loan Forgiveness eligibility, and a robust Employee Assistance Program (EAP).

Hybrid/Remote

Teachers College maintains a hybrid work environment, which provides employees with flexible work arrangements while ensuring we preserve the important aspects of our unique in-person college-campus culture. Depending on role and business needs, colleagues will either work onsite or in a hybrid model (a combination of in-office and virtual days). Employees are expected to live within a 150-mile radius of the College.