What are the responsibilities and job description for the Advancement Data and Reporting Analyst position at Williams College and Careers?
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:
- Bachelor’s 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 $75,000-$85,000, 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
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 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 (413) 597-2681 or email at
hr@williams.edu
.Salary : $75,000 - $85,000