netForum/Salesforce/AMS Database Manager

Americans for the Arts
Washington, DC
Oct 10, 2019
Oct 22, 2019
Full Time
ABOUT AMERICANS FOR THE ARTS Americans for the Arts builds recognition and support for the extraordinary and dynamic value of the arts and serves, advances, and leads the network of organizations and individuals who cultivate, promote, sustain, and support the arts in America. The vision of Americans for the Arts is that the arts are recognized as integral to the lives of all people and essential to healthy, vibrant and equitable communities across the nation. Founded in 1960, Americans for the Arts is the nation's leading nonprofit organization for advancing the arts and arts education. Americans for the Arts has headquarters in Washington, DC and a second office located in New York, NY. POSITION SUMMARY The netForum/Salesforce/AMS Database Manager will manage all databases, enterprise reporting, and business intelligence solutions, plus be responsible for setting standards, training staff, and documentation for our database functions. The organization's current CRM is Abila netForum Enterprise and current accounting package is MS Dynamics SL. The netForum/Salesforce/AMS Database Manager will actively participate in driving CRM strategy by working closely with departments to establish their information needs, defining technical requirements and procedures for the database to help staff perform their work, defining and building reports, pulling complex and simple queries, and training staff in database use and procedures. The netForum/Salesforce/AMS Database Manager will regularly use their technical knowledge of SQL and SQL tools to build queries and reports and provide data to drive organizational decision making. The Manager will be responsible for building collaborative and productive relationships with staff and to be proactive and anticipate organization-wide needs. The netForum/Salesforce/AMS Database Manager will be a key member of a team to evaluate current and planned systems needs as the organization overhauls its current systems to increase functionality and productivity. The netForum/Salesforce/AMS Database Manager will work directly with management and staff to define system requirements, design and propose solutions, customize the software and train employees. As new systems are put in place, the netForum/Salesforce/AMS Database Manager will be responsible for continuous improvement, making recommendations to expand and increase functionality, and act as the Subject Matter Expert for the new system(s). The netForum/Salesforce/AMS Database Manager will work with the organization's managers and process owners to identify processes and practices that need to be added, modified or changed. System changes will focus on improving or replacing our CRM and e-commerce functionality, implementing new organizational financial management systems and processes, expanding data warehousing tools and dashboard for business intelligence, identifying and implementing integration points between systems to improve efficiencies and work flow, updating current and writing new SOPs to improve processes, and other tasks as defined. The netForum/Salesforce/AMS Database Manager will function as part of a larger web and technology strategies department that maintains the organization's databases, websites, and network systems. KEY DUTIES AND RESPONSIBILITIES Key duties and responsibilities include, but are not limited to: * Managing Abila netForum database to maintain the integrity of data to ensure that systems and procedures are taught, understood, and practiced consistently * Creating and running database queries for ad-hoc information retrieval as regularly requested through our help desk ticketing system * Answering various database related help desk tickets submitted by staff, meeting standards outline in your yearly performance goals which include turn-around time and level of communication provided for status updates. * Developing standard database reports and customizing base-line netForum reports, using SQL Server Reporting Services (SSRS) o Where possible, convert standing, regular query requests into reports and empower other staff how to run these reports themselves * Proactively anticipating problems and acting to prevent them; evaluating system performance issues and implementing solutions * Working with vendor on projects to integrate or improve functionality of netForum * Oversee the management and development of Nucleus dashboard displaying events, membership and fundraising data from netForum * Participate in the evaluation, selection and deployment of new systems, which may include a new CRM, to improve the organization's ability to manage finances, programs, and data related to daily business * Sound understanding of accounting principles and systems to provide technical support in the deployment and maintenance of accounting, budgeting, forecasting, grants and other related systems * Creating user accounts and managing database user security * Researching, proposing, testing, and implementing improvements to netForum to expand the functionality and effectiveness of the database. Such things could include but are not limited to: o Utilizing the netForum Toolkit module to make changes to forms and wizards o Creating new extender tables, forms, and other tools to expand the data captured o Making adjustment to netForum settings and SQL expressions to improve and expand front end query results o Using SSRS, Visual Studio, netForum reporting server, and adjusting netForum settings to improve, expand, and create reports * Performing manual updates of information in the database as needed * Empowering and training staff about database-related needs, including updating data with accuracy and consistency to uphold business rules, performing simple queries, running reports, and answering user questions * Working with staff to set policies and procedures to strategically code lists of prospects, partners, and stakeholders added to netForum for better data analysis and market segmentation * Understanding the cross-module functions of netForum to determine the impact of database changes on other systems and processes * Writing and updating Standard Operating Procedures (SOPs), end user software documentation, and training materials including quick reference guides * Leading and building regular work plans to test applied netForum service packs and upgrades to ensure data integrity and functionality of the database. This task will require you to: o Create SQL scripts to analyze data and execute test scripts o Test all routine functions of the database currently in use o Run reports and queries to verify accuracy o Anticipate a minimum of 1 annual database upgrade and a minimum of 7 service pack upgrades per calendar year * Troubleshoot advanced netFORUM problems as they arise, submit and follow-up on help desk tickets to Abila ensuring timely resolution of database problems and anomalies * Networking and establishing relationships with Abila staff and members of the Avectra User's Group (AUG) community to solicit support and learn best practices * Work with other staff to integrate other software programs with netFORUM and monitor the integration * Help other departments use netFORUM where possible to streamline currently manual processes thereby increasing productivity QUALIFICATIONS * Bachelor's degree in Information Technology, Database Management, or a related field required * A minimum of five (5) years database development and administration experience with accounting exposure * Technical expertise in SQL 2008, Microsoft SQL Server Reporting Services (SSRS) to build complex queries and reports is necessary to perform minimum requirements of the job * Knowledge of AMS and CRM systems and demonstrable knowledge of Abila netForum, Salesforce or comparable CRM systems * Finance/Accounting experience and familiarity with financial concepts is a plus * Demonstrated experience managing systems in hosted environments and working with vendors to troubleshoot problem. This position has no duties in the administration of SQL Servers as they are hosted and maintained off site by vendors. * Understanding systems development life cycle * Project management experience including leading teams, adhering to timelines, documenting progress, and keeping projects within scope and budget * Strong communications skills and the ability to bring teams of people together to accomplish a common goal * Strong organizational skills and the ability to handle multiple projects with changing priorities * Strong Personal Computer (PC) skills and advanced MS Excel skills required * A positive attitude and an earnest interest in providing quality customer service to our colleagues, members, stakeholders, and partners * Ability to maintain healthy interpersonal relationships and collaborate effectively with colleagues * Ability to work with minimal supervision * Broad experience working within a nonprofit/association environment applying database tools to the functions and processes of Accounting, Membership, Fundraising, Events * Dedication to quality and accuracy * Excellent written and oral communication skills with both technical and non-technical team members * Prior association/nonprofit experience preferred WORKING CONDITIONS * This position works 37.5 hours per week Monday through Friday around core business hours (10:00 am - 4:00 pm ET) * Some travel may be required CULTURAL EQUITY COMPETENCIES Americans for the Arts acknowledges the existence of systemic and structural biases and believes it is necessary to be strategic and intentional in pursuing cultural equity in all aspects of governance, operations, and programming. As an employee, you are expected to: * Pursue substantive learning to achieve greater cultural consciousness by attending at least one Americans for the Arts Learning Lab per quarter and/or other professional development opportunities * Support adoption of best practices to create a more diverse, equitable, and inclusive work experience for colleagues and external partners * Strive to consider the people, places, and cultures that might be missing from your work and look for opportunities to increase inclusivity in all the work you do. * Support the mission and vision of Americans for the Arts in all interactions with colleagues, members and stakeholders * Encourage colleagues and external stakeholders to advance cultural equity by adhering to the standards outlined in the Staff Values & Behavior Agreement in all interactions EQUAL OPPORTUNITY EMPLOYER Americans for the Arts believes that one of its greatest strengths is the rich diversity of its staff. We provide equal employment opportunity without regard to race, color, creed, gender and gender identity or expression, age, mental or physical disability, medical condition, including pregnancy and childbirth, religion, national origin, marital status, sexual orientation, ancestry, genetic information, political belief or activity, veteran or military discharge status, or any other basis protected by local, state or federal law and regulations under Title VII. The policy applies to all employment practices, including but not limited to recruitment, hiring, training and development, promotion, transfer, termination, layoff, compensation, benefits, social and recreational programs, and all other conditions and privileges of employment in accordance with applicable federal, state, and local laws. All employees have the right to work in a workplace that is free of discrimination. Any person who believes they have been subjected to discrimination of any kind should contact their immediate supervisor or the Director of Human Resources. All complaints will be thoroughly investigated and any person violating this policy may be subject to disciplinary action up to and including termination. The law prohibits retaliation against any employee for reporting discrimination or perceived discrimination, or for participating in an investigation of incidents of discrimination or perceived discrimination. PandoLogic. Keywords: Database Manager, Location: Washington, DC - 20005