Sr Data Analyst, Simon Admissions

DataJobs; City of Rochester (NY); On-site; USD 64,000 - 96,000; Full time

Job summary

DataJobs is seeking a data-driven professional to support institutional decision-making by turning admissions and financial data into predictive models, forecasts, and leadership-ready insights. You will build models for yield, financial aid impact, and revenue optimization, and create dashboards tracking application volume, yield, and tuition revenue.

The role requires strong SQL/Excel skills, experience with Tableau or Power BI, and the ability to translate complex data into clear

Qualifications

• Bachelor's degree and 5 years of relevant experience required.
• 2 years of experience in higher education, enrollment management, or finance preferred.
• Ability to translate complex data into actionable insights.
• Experience with SQL and Excel; data visualization with Tableau/Power BI.

Responsibilities

• Build predictive models to support enrollment, finances, and revenue optimization.
• Create short- and long-term enrollment forecasts by program, modality, and student segment.
• Develop revenue projections including tuition, scholarships, and institutional aid.
• Run scenario modeling to inform leadership planning and budget development.
• Analyze admissions funnel data from inquiry through enrollment to identify trends and growth opportunities.
• Develop dashboards and recurring reports for application volume, yield, financial aid utilization, and net tuition revenue.
• Monitor KPIs related to enrollment, discount rate, melt, retention, and revenue.
• Ensure data accuracy across CRM, SIS, financial aid, and finance systems.
• Translate analytical findings into actionable recommendations for Admissions, Financial Aid, and senior leadership.

Skills

Data visualization

Tableau

Power BI

SQL

Excel

R

Python

Predictive modeling

Admissions funnel knowledge

Education

Bachelor's degree

Tools

Tableau

Power BI

SQL

Excel

R

Python

CRM

SIS

Job description

Support institutional decision-making by turning admissions and financial data into predictive models, forecasts, and leadership-ready insights.

Responsibilities

• Build predictive models to support:
  • Application and enrollment yield
  • Financial aid impact on student decision-making
  • Revenue optimization and discount rate management
• Create short- and long-term enrollment forecasts by:
  • Program
  • Modality
  • Student segment
• Develop revenue projections incorporating:
  • Tuition
  • Scholarships
  • Institutional aid
  • Enrollment scenarios
• Run scenario modeling (best case, expected, worst case) to inform leadership planning and budget development
• Analyze admissions funnel data from inquiry through enrollment to identify:
  • Trends
  • Conversion drivers
  • Growth opportunities
• Develop dashboards and recurring reports for:
  • Application volume
  • Yield
  • Financial aid utilization
  • Net tuition revenue
  • Cohort performance
• Monitor KPIs related to enrollment, discount rate, melt, retention, and revenue
• Ensure data accuracy and integrity across CRM, SIS, financial aid, and finance systems
• Analyze scholarship effectiveness and ROI
• Support aid packaging strategy by modeling award elasticity and enrollment outcomes
• Partner with Finance to align enrollment forecasts with institutional budget planning
• Evaluate pricing strategies and program-level profitability
• Translate analytical findings into recommendations for Admissions, Financial Aid, and senior leadership
• Support recruitment strategy by identifying high-value student segments and markets
• Present insights to cross-functional stakeholders using clear visualizations and narratives
• Provide ad hoc analysis for leadership initiatives and special projects
• Perform other duties as assigned

Requirements

• Ability to translate complex data into actionable insights
• Excellent verbal and written communication skills, with the ability to present complex information clearly and concisely
• Strong problem-solving skills with a strategic mindset
• Experience with data visualization tools such as Tableau, Power BI, or similar
• Strong understanding of statistical analysis and predictive modeling
• Strong experience with SQL and Excel
• Experience building predictive models and forecasts using R, Python, or advanced Excel
• Demonstrated ability to analyze large datasets and communicate insights clearly
• Knowledge of admissions funnels, financial aid processes, and tuition revenue concepts

Technologies

• Tableau
• Power BI
• SQL
• Excel
• R
• Python
• CRM
• SIS

Minimum Education & Experience

• Bachelor's degree and 5 years of relevant experience required
• 2 years of experience in higher education, enrollment management, or finance preferred
• Or an equivalent combination of education and experience

Location: Rochester, NY (onsite)

Salary: USD 64,200 - 96,200 per year