CRM Administrative Analyst

Job Description

Under the direction of the Assistant Director Database Services, provide a broad range of administrative, analytical, support, and operational functions in support of the Housing Services department. Major duties include maintain relevant question and answers in the Housing FAQ database as information changes including updating existing answers as well as creating new answers to better serve students; preparing analytical reports on Housing Services’ processes, customer audits, and Housing FAQ database metrics. Maintain customer queue of questions to ensure timely responses by Housing Services staff. Act as primary point of contact for other departments using the Customer Relationship Management (CRM) system to send out information via mass mailings and surveys as well as any training needs. Maintain an email schedule to combine redundant contacts or overlap of content when possible. Proof read and edit mailings and surveys using HTML to ensure accuracy, readability, and brevity. Ability to perform an annual database upgrade including developing a test plan, completing full regression testing, and developing a user acceptance testing process. Editing the department web pages as needed. Editing the student facing portal for Housing Services. Maintain user security to the CRM database to ensure accurate security levels based on job function. Additional responsibilities include assisting with customer service on telephones, email, and in person, as well as daily mail room coverage. Develop and update ad hoc reports based on requests for data. Supervision of Housing Services Offices as needed for coverage.

Job Qualifications

Experience in customer service in person, email, and telephone.
Required

Ability to edit and develop mailings, surveys, and webpages using HTML and CSS.
Required

Understanding of a relational database.
Required

Skill in analyzing operating procedures and data to recommend necessary changes or trends consistent with accepted analytical practices.
Required

Organizational skills to manage changes to information to ensure customer facing content is updated timely and accurately.
Required

Ability to set goals and priorities, which accurately reflect the relative importance of job responsibilities, when faced with fluctuating workloads, deadlines and competing requirements.
Required

Ability to establish and maintain effective working relationships with staff, coworkers, and other University personnel and interact diplomatically with a diversified public.
Required

Experience in writing routine business and customer correspondence, operating procedures, and presentation materials using grammatically correct language.
Required

Working knowledge of online FAQ’s on demand systems.
Required

Ability to give clear, concise, logical presentations to senior management.
Required

Working knowledge of web content management program.
Required

Skill in keyboarding with speed and accuracy.
Required

Ability to learn concepts quickly and to apply this knowledge to other job functions.
Required

Ability to perform duties independently and with a great degree of accuracy, while meeting established deadlines.
Required

Skill in performing a variety of duties, often changing from one task to another of a different nature.
Required

Ability to accept equivocal circumstances and take action where answers to a problem are not readily apparent.
Required

Skill in speaking concisely and logically, using grammatically correct language to convey information and explain policies and procedures in a professional manner.
Required

Working knowledge of Microsoft Suite products.
Required

Experience developing and executing a database upgrade regression plan including organizing issues, developing a user acceptance testing plan, and holding milestone meetings.
Preferred

Ability to quickly assess and analyze overlapping or redundant content.
Preferred

Experience maintaining user security including timely adding and removing of access as well as maintaining user access levels.
Preferred

Working knowledge of basic accounting and collections practices and principles, internal cash handling and controls.
Preferred

Working knowledge of computerized hotel or billing and receivable systems.
Preferred

Ability to write and edit SQL queries.
Preferred

Working knowledge of housing database systems.
Can be trained