CRM Integrity Analyst

Williams College•Williamstown, MA

2d•$62,000 - $72,000•Hybrid

About The Position

We’re excited to introduce a newly created role at Williams College: the CRM Integrity Analyst . In this position, you’ll use superior analytical and problem solving skills to evaluate operational needs and use expertise and independent judgment to strengthen the systems that power our fundraising, alumni engagement, and career outreach efforts. Acting as the CRM and data systems expert, your work will directly improve the accuracy, functionality, and efficiency of our CRM and related tools, helping ensure our colleagues across campus can rely on high-quality data to do their best work to inform their work and decision-making. As part of the Office of College Relations (OCR), you’ll collaborate with colleagues to enhance data structures, build and maintain essential reports, streamline workflows, and automate processes within our CRM environment. You will design and implement system enhancements, including queries, validations, and data structures, while proactively identifying opportunities to improve processes and data integrity. You’ll evaluate, develop, code, test, implement, and document identified projects. Projects could include data imports, data exports, new data entry forms, new reports, dashboards or dashboard exports, system integrations, or modifications to existing reports and procedures. You’ll work toward simplifying and automating tasks as much as possible by reviewing existing processes to see where the CRM or other external programming systems can be useful. You’ll also support system integrations, troubleshoot technical and data issues, and provide user support to keep everything running smoothly. At times, you may also partner with our Data Management team on key data entry work, including donations and constituent records, handle ad hoc tickets received from end users, or serve as a backup when the Assistant Director is not available. This is a great opportunity for someone who enjoys solving problems, improving systems, and working collaboratively in a mission-driven environment. At Williams, we’re committed to fostering a diverse and inclusive community, and we value team members who thrive in and contribute to a workplace that reflects a wide range of backgrounds, experiences, and perspectives.

Requirements

Bachelor’s degree and at least 1 year of experience in data quality assurance or data maintenance, or an equivalent combination of education and experience
Experience with data quality, data maintenance, and attention to detail
Ability to quickly learn and navigate new software systems
Proficiency with Google applications
Strong discretion in handling confidential information
Experience evaluating processes and identifying improvements
Effective communication skills and ability to collaborate across teams
Ability to manage multiple priorities, work independently, and as part of a team

Nice To Haves

Experience with CRM queries, SQL, or other programming languages (preferred)
Experience with Slate CRM (preferred)
Experience with system integrations and data exchanges (SnapLogic a plus)
Familiarity with advancement systems and business processes (preferred)

Responsibilities

Enhance data structures
Build and maintain essential reports
Streamline workflows
Automate processes within our CRM environment
Design and implement system enhancements, including queries, validations, and data structures
Proactively identify opportunities to improve processes and data integrity
Evaluate, develop, code, test, implement, and document identified projects
Support system integrations
Troubleshoot technical and data issues
Provide user support
Partner with our Data Management team on key data entry work, including donations and constituent records
Handle ad hoc tickets received from end users
Serve as a backup when the Assistant Director is not available