Williams College · 5 hours ago
Advancement Data and Reporting Analyst
Williamstown, MA
Full-time
Hybrid
Entry, Mid Level
$75K/yr - $85K/yr
2+ years expWilliams College is seeking a curious and analytical Advancement Data & Reporting Analyst to join the Office of College Relations (OCR). The Analyst will interpret complex datasets and visualize trends to empower fundraising and engagement teams in making informed business decisions that support the College's mission.
Education
Responsibilities
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
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)
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
Maintain and achieve the highest level of data quality to build and sustain confidence in the reporting and visualization end products
Qualification
Required
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
Preferred
Experience with Slate CRM database
Full time working experience in a higher education or non-profit environment
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
Benefits
Generous health care and retirement plans
Tuition reimbursement
Professional development opportunities
Paid leave
Access to gym facilities
Discounts with local vendors
Company
Williams College
Williams College is a private, liberal arts college.
1001-5000 employees
H1B Sponsorship
Williams College has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (12)
2023 (6)
2022 (7)
2021 (8)
2020 (8)
Funding
Current Stage
Late StageLeadership Team
Abigail Wattley
Chief Investment Officer
Ashley Kyu-ri Kim
Founder, President, & Co-Communications Leader of Music to Fulfill
Recent News
Venture Capital Firms
2025-09-12
Seattle TechFlash
2025-04-28
Company data provided by crunchbase