Advancement Data and Reporting Analyst

Williams College is seeking a curious and analytical Advancement Data & Reporting Analyst to join the Office of College Relations (OCR). The Analyst will be a bridge between raw data and strategic decision-making. By interpreting complex datasets and visualizing trends the Analyst will empower our fundraising and engagement teams to make informed business decisions that support the mission of the College. As part of the Advancement Operations team the Analyst will also identify and resolve data integrity/quality issues within our database.

Responsibilities:

Reporting to the Director of Data Analytics Prospect Management & Research the Advancement Data and Reporting 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 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 Advancement Data and Reporting 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 Advancement Data and Reporting 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:

• Bachelors degree (preferably in a quantitative field (Mathematics Computer Science Data Science Statistics etc.)
• Minimum of two years of technical experience in a professional office environment.
• Strong analytical skills with the ability to collect organize and analyze significant amounts of information with attention to detail and accuracy
• Ability to translate and disseminate data for non-technical audiences
• Exceptional attention to detail ability to work in a team environment and ability to manage multiple concurrent projects
• Excellent written and verbal communication skills including the ability to communicate with all levels of the department including senior staff
• Demonstrated experience with Power BI (preferred) Tableau or similar business intelligence tools.

Highly Preferred Qualifications:

• Experience with Slate CRM database
• Full time working experience in a higher education or non-profit environment

Preferred Qualifications:

• Innovative energetic flexible and highly organized who thrives in a collaborative environment
• Intermediate to Advanced SQL skills and experience handling large complex datasets
• Knowledge of statistics and experience using statistical packages for analyzing datasets (R Excel SPSS SAS etc.)
• Technical expertise with creating models to forecast trends and in data mining and segmentation techniques
• Adept at data visualization and analysis in addition to writing queries report writing and presenting findings

Additional Details:

This is a full-time benefitted position on the Williams College campus in Williamstown MA. The pay range for this position is $75000-$85000 commensurate with experience.

Williams invests in our employees offering generous health care and retirement plans tuition reimbursement professional development opportunities paid leave access to gym facilities discounts with local vendors and more.

Remote Work:

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.

To Apply:

In addition to your resume 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.

Application review will begin on March 5th 2026. For best consideration please include all required materials and submit your application by this date.

Visit 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 applicable. Decisions regarding appointments promotions and conditions of employment comply with applicable federal or state law prohibiting discrimination based on race color sex national origin religion age disability marital status sexual orientation gender identity or expression ancestry or military service.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Beyond meeting fully its legal obligations for non-discrimination Williams College is committed to building a diverse and inclusive community where members from all backgrounds can live learn and thrive. As part of this commitment we will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process please feel free to contact us via phone at or email at .