DATABASE & DATA INTEGRITY MANAGER - STORM KING ART CENTER

Jessica Carey

About the Position

The newly created Database & Data Integrity Manager is a key member of the Operations Department that ensures data integrity and proper programming, maintenance, and use of our organization-wide database, Altru by Blackbaud. Altru contains over 100,000 records and supports the success of several departments, primarily Visitor Operations and External Affairs (Development). This is a critical role that ensures continuity of the Art Center’s business and enforces best-practices with respect to data records management. Maintaining reliable, accurate, and consistent data is crucial for analysis, forecasting, and reporting to make informed business decisions.

The Database & Data Integrity Manager is primarily responsible for the integrity of all data records and the oversight of the point-of-sale and online sales systems. These systems contain sales orders, constituent records, reports and queries, and webforms. The Database & Integrity Manager is also responsible for programming and maintaining webforms for organization-wide individual and group admission, merchandise, events, and program ticketing.

To ensure systems are configured optimally, the Database & Data Integrity Manager ensures proper data entry, according to documented standards and leads clean-up and correction on an on-going basis to ensure data integrity. Serving as the main point of contact for questions and issues with the use of Altru, the Database and Data Integrity Manager will continually increase their knowledge of the Altru system, including from the community discussion board, and will teach back to users by answering questions and developing and updating usage guides. Working collaboratively with other department managers, the Database & Data Integrity Manager will monitor and ensure the integrity of constituent data, maintain, and distribute written Altru and database policies and procedures based on best practices museum and industry, and compliance demands.

Primary/Essential Responsibilities and Duties

• Resolve daily issues pertaining to all functions within Altru; escalate any issues to Blackbaud Support and beyond if they are beyond Blackbaud Support.
• Serve as an institutional liaison and co-chair regular Altru user group meetings with subject matter experts from multiple departments.
• Help with complex and intricate reporting and data needs using Altru by creating and customizing queries.
• Identify opportunities to streamline departmental processes and procedures and aid in the roll out.
• Stay current with Altru system updates; inform staff of updates and changes; and implement changes to the Altru system integrate updates.
• Implement a plan to proactively audit and monitor integrity of data across constituent systems with a focus on Altru.
• Program ticketing, discount and webforms for both online and onsite sales of admission for individuals and groups, merchandise, events, and programs.
• Drive ongoing refinements to data integrity in Altru, including large and small-scale clean up and maintenance projects, in keeping with best practices and in response to evolving user needs.
• Serve as project manager to departments for all database and website integration related projects. Includes managing online web forms and generating timely progress reports.
• Design, build and maintain reports, dashboards, and other strategic information for users.
• Create policies and procedures for Altru use and maintenance, based on best practices and consistent with department policies.
• Update accounting GL codes in Altru as necessary.
• Regularly check and fix unresolved sales orders; undelivered emails; and reporting issues
• Maintain Altru user account security and print access.
• Lead training and documentation for all Altru users.
• Advise on add on software opportunities and act as Project Manager for their implementation.
• Assist IT in physical point-of- sales systems including components such as credit card processor, receipt printers, and ticket printing.
• Design and maintain VG files for all ticketed programs and ensure the digital and physical printing of these tickets by all users.
• Other duties as assigned.

Required Skills and Qualifications

• Associate degree is required; Bachelor’s degree preferred.
• Minimum of 2 years demonstrated database administrator experience within a customer relationship database (i.e. Altru, Raiser’s Edge, Salesforce, Tessitura, etc.), including data import/exports, complex queries and custom reporting.
• Minimum of 2 years’ experience in a non-profit or office environment
• Experience working with sensitive personnel or customer data or files
• Experience with data entry procedures
• Experience with back-office, bookkeeping, or fundraising operations
• Understand and value honesty, integrity, consistency, and accuracy and the risks associated with compromise in those areas
• Must be aware of and keep track of relevant compliance demands regarding data/records retention
• Working knowledge of Microsoft Windows 7 or newer
• Working knowledge of Microsoft Office (2013 or 365), particularly Excel
• Self-driven and independently motivated, able to independently set daily goals
• Must be able to create and work through assigned projects and tasks
• Must be able to handle competing requests and priorities from other staff
• Must be trustworthy, due to the sensitive, confidential nature of personal and financial recordkeeping
• Excellent attention to detail and organization skills
• Excellent presentation and communication skills
• Able to translate and describe technical information to non-technical audiences
• Able to teach others or troubleshoot issues in-person, over the phone, or via email
• Able to perform work accurately and thoroughly
• Requires strong ability to follow instructions, manage time, remember details, organize, multi-task, research, communicate verbally and in writing.
• Ability to work occasional nights and weekends.

Preferred Skills and Qualifications

• Previous development experience with advanced knowledge of fundraising systems and process/best practices
• Blackbaud certifications, or training
• Knowledge or experience with Blackbaud Altru or Raiser’s Edge
• Experience with browser-based or desktop POS systems
• Knowledge of third-party reporting software such as Tableau or Crystal Reports
• Knowledge of database queries
• Knowledge of macOS
• Knowledge of web programming such as CSS
• Knowledge of design of SVG files
• Demonstrated teaching skills
• Experience training others to use computer software
• Experience working in a museum or cultural institution

Physical Requirements and Working Conditions

• Works in an office environment
• Frequently sits for long periods of time
• Frequently speaks, reads, writes and uses a computer keyboard
• Must be able to work and walk outside in a variety of weather conditions
• Requires standing, lifting, stooping, or bending
• Occasionally works on weekends and evenings to support open season

To Apply

Please submit your resume and cover letter via email to employment@stormkingartcenter.org with “Database Manager” in the subject line. No phone calls please.

Benefits and Pay Range

This full-time, exempt (FLSA status) position is eligible for our generous benefits package as outlined below. The hiring annual salary range is between $60,000 – $65,000 depending on qualifications.

Information on Benefits Offerings

Full-time Positions
(year-round, more than 30 hours per week)

• Medical, vision, and dental benefits after the 1^st of the month following 30 days of employment.
• Low medical copays and premium costs absorbed mostly by Storm King.
• 403(b) Retirement Plan with an annual discretionary employer contribution.
• Long-term disability, life, and accidental death and dismemberment insurance, and flexible spending medical and dependent care plans.
• Additional Voluntary-Short Term Disability Plan employee contribution that offers salary continuation at 60% of your gross monthly base earnings (maximum of $1,500 per week).
• Generous parental leave (maternal and paternal) during new child’s first year (born into family or adopted).
• 19 days of paid time off (PTO) that are accrued and prorated upon hire with additional days tiered with years of service.
• 11 Paid Holidays, plus paid time when offices are closed the week between Christmas and New Year’s Day.
• Employee discount at our Museum Store and Outdoor Café and free access to the Art Center for friends and family.
• Flexible work schedules with the ability to work remotely based on position requirements.
• A mobile phone subsidy is available based on position requirements.

Storm King Art Center is dedicated to fostering a diverse workplace. Storm King Art Center is an equal opportunity employer and makes employment decisions on the basis of merit.

People who are of color, gender oppressed, LGBTQ, immigrants with work permission, and people of diverse social and economic backgrounds are encouraged to apply. Storm King Art Center does not discriminate based on race, color, religion, creed, sex, marital status, registered domestic partner status, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, sexual orientation, gender identity or expression, or any other related consideration.