Williams College · 11 hours ago
Advancement Data and Reporting Analyst
Williamstown, MA (Main Campus)
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 bridge raw data and strategic decision-making, empowering fundraising and engagement teams to make informed business decisions.
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
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
Developing specifications and proposed layouts in partnership with end users
Maintaining and achieving 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
And more
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