Data Analyst

Williams College is pleased to announce an opening for the position of Data Analyst. The Data Analyst supports the Office of College Relations (OCR), interpreting data to provide actionable insight to inform business decisions for all departments within OCR. As part of the Advancement Operations team, the Data Analyst will also work to identify data integrity/quality issues within the data repository and resolve. 

Responsibilities:

Reporting to the Director of Data Analytics, Prospect Management & Research, the Data Analyst is responsible for data analytics using statistical methods and models to generate graphs, charts, heat maps, and other visualizations to assist end users in understanding the meaning behind the data.

The Data Analyst will also support OCR by designing and maintaining dashboards (using primarily Power BI) for data analysis to promote data visualization, identify trends, share insights, review historical data, and identify key performance indicators (KPIs). In addition, the Data Analyst will be responsible for writing and validating complex queries for data mining, designing rich data visualizations to communicate complex ideas to leadership, and developing specifications and proposed layouts in partnership with end users. 

Collaborating with other teams within the Office of College Relations, the Data Analyst will work to maintain and achieve the highest level of data quality to build and sustain confidence in the reporting and visualization end products.

Requirements:

• Bachelor’s degree in a related area (such as Mathematics, Computer Science, Data Science, Information Science, or Statistics), with a minimum of two years technical experience in an office environment, or an equivalent combination of education and experience

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

• Demonstrated experience handling large and complex data sets

Highly Preferred Qualifications:

• Experience with Slate CRM database

• Experience with tools such as PowerBI or Tableau

• Knowledge of statistics and experience using statistical packages for analyzing datasets (R, Excel, SPSS, SAS, etc.)

Preferred Qualifications:

• Innovative, energetic, flexible, and highly organized

• Operates most efficiently in a collaborative, team-oriented environment

• Technical expertise creating models to forecast trends and in data mining and segmentation techniques

• Experience with data quality and data integrity

• Adept at data visualization and analysis in addition to writing queries, report writing, and presenting findings

• Strong attention to detail, ability to work in a team environment, and ability to manage multiple concurrent projects

• Experience working in a higher education or non-profit environment 

• Strong written and verbal communication skills 

Williams College is committed to building a broadly diverse and inclusive community where members from all backgrounds can live, learn, and thrive.

Application review will begin on August 22th, 2025. The pay range for this position is $72,000-$82,000, commensurate with experience. A cover letter is required in order for your application to be considered.  In your letter, please address your interest in this particular position and the strengths you would bring to the Williams College Office of College Relations in this role.  Applicants should highlight relevant experience with building, working with, and supporting a broadly diverse employee community and are encouraged to include information in regard to meeting the highly preferred and preferred qualifications outlined above.

In select circumstances, hybrid on-site/remote work arrangements may be available up to 2 days per week with approval for employees based in NY, MA, CT, or VT, subject to review and revision as policy evolves. This position requires a minimum 3 days per week of on-campus, in person work, following a fully in-person onboarding period.

Please visit careers.williams.edu to apply. 

Employment at Williams is contingent on the verification of background information submitted by the applicant, including the completion of a criminal record check, and education when applica