Business Intelligence Analyst

Kenyon College; Gambier (OH); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Tuition waivers

Health insurance

Retirement plan

Professional development opportunities

Job summary

Kenyon College seeks a Business Intelligence Analyst in the Enrollment Division to provide BI reporting, data analysis, and AI-enabled decision support for recruitment and enrollment efforts.

The analyst will design reporting environments, automate tasks with AI, gather requirements, and deliver predictive insights while ensuring data accuracy and privacy.

This role partners with campus offices to support Board presentations and enrollment strategy.

Qualifications

• Proven BI, reporting, or data analysis experience.
• Experience using AI tools to automate data tasks and generate queries.
• Strong SQL skills and data manipulation capabilities.
• Experience with data visualization tools and self-service dashboards.
• Familiarity with data privacy and ethics in student data.

Responsibilities

• Design and manage a data reporting environment for Enrollment Division.
• Use AI tools to automate tasks and speed insights.
• Gather requirements from Enrollment staff and provide training and documentation.
• Analyze enrollment trends to deliver predictive reporting.
• Support leadership with data for Board presentations.

Skills

BI reporting

SQL

AI tools

Data visualization

Education

Bachelor’s degree in data analytics or related field

Experience with CRM systems or student data (preferred)

Tools

Tableau

Power BI

Slate

FrontRush

PowerFAIDs

Job description

Kenyon College seeks a Business Intelligence Analyst to join its Enrollment Division. Reporting to the Associate Vice President for Enrollment Strategy, Technology & Analytics, the Business Intelligence Analyst provides primary business intelligence, reporting, and AI-enabled decision-support for the Enrollment Division. This key data role serves as the chief report writer, data analyst, and business intelligence strategist in support of all recruitment and enrollment efforts. The Analyst is expected to leverage artificial intelligence and automation to enhance data accuracy, accelerate reporting cycles, and provide predictive insights that inform enrollment strategy.

Key Responsibilities

• Design, develop, and manage a comprehensive data reporting environment for the Enrollment Division, coordinating with central IT services, the Registrar, the Office of Institutional Research, and other institutional partners as appropriate.
• Serve as the division’s expert in utilizing AI tools to automate repetitive data tasks, generate complex queries, and enhance the speed of insight delivery.
• Gather business requirements from Enrollment staff on reporting needs; provide development support, AI-assisted training, and documentation.
• Proactively analyze enrollment trends and funnel data to provide creative, viable, and predictive reporting solutions that help end-users meet recruitment goals.
• Assist the Vice President of Enrollment and the Division’s leadership team in the production of presentation for the College’s Board of Trustees, Senior Staff, and enrollment management committees
• Ensure data integrity and accuracy across all repositories. Act as a data steward by maintaining data dictionaries, standardizing definitions, and verifying AI-generated outputs for accuracy and bias.
• Develop and maintain self-service data discovery and exploration functions (dashboards) to empower staff to make data-driven enrollment decisions.
• Provide individual and group training for staff on reporting, analytical tools, and the responsible use of AI in data interpretation.
• Work as part of the Enrollment Strategy, Technology & Analytics team to support other platforms and technologies as part of a skill redundancy plan.

Key Skills / Requirements

• Proven experience in Business Intelligence, institutional reporting, or data analysis.
• Demonstrated ability to use AI tools (e.g., LLMs, automated workflows) for data manipulation, query generation, and process improvement.
• High degree of comfort working with all data types, calculations, formulas, and expressions.
• Deep knowledge of database structures, data warehouses/lakes, and data manipulation (importing/exporting).
• Strong SQL skills with a deep understanding of commands, joins, and optimization.
• Experience with data visualization tools (e.g., Tableau, Power BI) and self-service discovery platforms.
• Understanding of data privacy, security, and the ethical implications of using AI with student data.

Preferred Qualifications

• Bachelor’s degree in data analytics, computer science, information systems, statistics, mathematics, business, or a related field is preferred, or an equivalent combination of education and relevant professional experience.
• Experience with CRM systems (e.g., Slate, FrontRush) and Student Financial Aid systems (e.g., PowerFAIDs).
• Experience writing complex data expressions in SQL and utilizing AI for code generation or debugging.
• Familiarity with third-party application platforms (e.g., Common App, Coalition).
• Relevant technology experience that demonstrates a working knowledge of systems, predictive data analysis, and higher education enrollment strategy.

Benefits

Kenyon offers benefits for employees and their family members. Children of employees are eligible for 100% tuition waivers at Kenyon, and through the Great Lakes Colleges Association, children of employees are eligible for 90% tuition waivers at twenty-three other of the nation's finest liberal arts colleges.

We also offer health, dental and vision insurance, TIAA retirement, and many other benefits, including provisions for a spouse, families, and domestic partners. Details about benefits as well as conditions of employment are described more fully in our Staff Handbook.

Kenyon is a unique place to live and work.

Kenyon College is an equal opportunity employer, and we welcomeapplications from all qualified individuals. It is the College's policy to evaluate qualified applicantswithout regard to race, color, national origin, ancestry, sex, gender, gender identity, gender expression,sexual orientation, physical and/or mental disability, age, religion, medical condition, veteran status,marital status, or any other characteristic protected by institutional policy or state, local, or federal law.Kenyon College has a strong commitment to an inclusiveenvironment thatwelcomes all voices and perspectives.