Advancement Data and Reporting Analyst

Williams College, London • Williamstown, MA

1d • $75,000 - $85,000 • Hybrid

About The Position

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.

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.

Nice To Haves

• 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
• 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.

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, 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level