CRM & IT Administrator
FREIGHTREPORTS TO: Director of Events & Facilities SUPERVISES: None EMPLOYMENT TYPE: Full-time, exempt LOCATION: Berkeley, CA, hybrid SCHEDULE: Monday - Friday daytime, some evenings/weekends PAY: $73,000-$75,000/year POSITION OVERVIEW The CRM & IT Administrator is responsible for monitoring, maintaining, and administering The Freight’s CRM database, Tessitura, and the day-to-day point person for technology. They should keep Tessitura running, accurate, and useful for Box Office, Marketing, Development, and Finance, and coordinate with our contracted IT provider on other technology needs. The role is responsible for learning, supporting, and developing the databases that comprise Tessitura and other database applications in the organization’s environment. They should also help ensure data integrity. Additionally, this role oversees IT management and serves as a liaison between the organization and Clear Tech, our contracted IT company. RESPONSIBILITIES Lead the integration and administration of Tessitura with various applications and websites. Oversee and maintain the Tessitura hosting environment, including performance, security, and user access. Includes routine maintenance such as rebuilding tessitura database encryption key, annually, and scheduling monthly/bimonthly PROD → TEST data copies, Research, plan, implement, and troubleshoot Tessitura upgrades, ensuring system optimization. Work closely with Tessitura extended-services on Tessitura-related tasks, including but not limited to executing SQL queries and reporting. Run Tessitura reports including sales, engagement, fundraising, and other reports as requested by other department leaders. Update and maintain Tessitura system tables and ensure data accuracy Support Finance and philanthropy team with discrepancies, adjustments, and other requests. Lead upcoming implementation of reserved seating in Tessitura, including seat maps, pricing, holds, and assisting Box Office with seating needs. Partner with department heads to identify how Tessitura can support organizational operations via Tessitura-driven data insights. Create a future Tessitura product implementation roadmap and ensure alignment with the organization’s goals. Engage with the wider Tessitura user community via forums, networks, and other channels. Stay updated with the latest Tessitura developments and assess their applicability to The Freight. Provide ongoing Tessitura support and training for the Box Office. Organize and schedule Tessitura webinars and training sessions, ensuring staff is well-equipped to utilize the system. Act as a company-wide resource for Tessitura assistance. Track company technology inventory including computers and laptops. Manage VoIP phone and internet systems, and work with vendors to resolve issues. Act as the primary liaison with our IT vendor (ordering software, assisting with network issues, etc.). Provide IT support for major events a few times a year, including ticketing and check-in setup and event-day troubleshooting. DISCLAIMER: This job description is not designed to cover or contain an exhaustive listing of all activities, duties or responsibilities that are required of the employee. There may be additional duties as assigned. SKILLS, KNOWLEDGE & ABILITIES 2-3 years of experience administering a CRM or similar database system Previous working experience with other database/inventory management systems Impeccable attention to detail Working knowledge of SQL Excellent interpersonal skills; able to collaborate with and build working relationships across departments. Independent problem-solving skills Strong organizational skills with the ability to prioritize multiple tasks in a creative, fast-paced, service-oriented environment Analytic mind with the ability to interpret data to help inform business development decisions Preferred Experience using Tessitura Experience in a nonprofit setting Experience with basic IT support: user accounts, hardware, netwo…