Job Title: Database Administrator
Department: Finance & Operations
Supervisor: Director of Operations
FLSA Status: Exempt
Salary Level: 17
Approved Date: May 15, 2017
Effectively plans, manages, and executes the on-line pledge campaigns for ePledge (Andar) and eWay (Frontstream), and identifies enhancements to the process, product, procedures or technologies to improve efficiency, effectiveness, and quality of the campaigns. This includes database administrative duties such as analysis and maintenance of CRM data, creation of executive campaign statistical reports, and performance of Database Mining Operations (DMO).
Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Essential Duties and Responsibilities: include the following.
1. Database Administration and Reporting
a. Understand the various Customer Relationship Management (CRM) tools to create, analyze, and implement reports for external and internal customers.
b. Execute data requests for the entire organization as back-up, (e.g., Finance & Operations, Donor Engagement, and Marketing).
c. Be the Subject-Matter-Expert (SME) on the CRM systems and consult with others as needed to answer questions, navigate the system, and provide business intelligence.
d. Monitor various sources for national account data and assist with data conversion, clean-up, and uploads.
e. Document procedures and training on the CRM tools and provide training as needed to the organization.
f. Research other available CRM modules in conjunction with IT and analyze/recommend whether the modules would be of benefit to the organization. If so, then identify productivity or quality improvement opportunities and create Cost/Benefit Analysis to show return on investment of dollars.
2. Plan, manage, and execute successful on-line campaigns utilizing a variety of systems and technologies, (e.g., Frontstream/Truist, eWay , Andar, ePledge, Volunteer Systems/Truist).
a. Creates and implements annual on-line plans for the donor companies that utilize these systems including the oversight and implementation of individual company campaigns, materials, documentation, and training.
b. Be the Subject-Matter-Expert (SME) on the systems and consult with others as needed to answer questions, navigate the system, and provide business intelligence.
c. Assists with electronic campaigns 'sales’ calls with donor companies.
d. Assists with rolling campaigns which includes account configuration and updating of websites, copying e-mail packages and customizing into each campaign, communications to potential recipient United Ways in regard to national campaigns, communicating with existing accounts to share new campaign "canned" messages and obtaining campaign dates, update and configure (HTML coding) customized messages such as e-mails, welcome messages, etc. Communicate deadlines and follow up to companies for receipt of data and any messaging customization.
e. Extract and communicate payroll deduction information to Company HR/Payroll Managers.
f. Adds newly eligible agencies and updates information in respective databases.
g. Attend and assist in client meetings for companies utilizing on-line tools or interested in on-line tools and technologies.
h. Establishes and maintains positive and professional relationships with donors, donor companies and colleagues and utilizes effective communication skills to build effective on-line campaigns.
i. Answer inquiries and/or complaints from internal and external customers, (e.g., donors or donor companies) and work effectively and professionally to answer and solve problems.
j. Work with representatives from other United Way organizations to coordinate national campaigns.
k. Document policies and procedures and cross train others to ensure back up for function.
l. Obtain and keep current professional certifications as necessary to perform the job.
m. Train others on systems and technologies including the building and utilization of reports.
3. Identify improvements to the process, product, procedures, or technologies to enhance the efficiency, effectiveness, and quality of the campaigns.
a. Keep current on software and participate in on-line training, webinars, and when possible, attend seminars to keep abreast of industry and system best practices and enhancements.
b. Create and implement projects when necessary to enhance the effectiveness of policies and procedures.
4. Create Reports
a. Create Database2 and other UWM statistical reports as required on a regular basis.
b. Create Campaign statistical reporting as required on a regular basis and import campaign reporting from other organizations. (e.g., UWW, Frontstream, other United Ways)
Marginal Duties and Responsibilities:
1. As needed, document, maintain, and train procedures for on-line campaign processing. (e.g., Nexus, Truist/eWay, and training and procedures for on-line campaign processing for Nexus, Truist, and Andar ePledge, serving as back-up to the Senior Financial Analyst).
2. Other duties as assigned.
This job has no supervisory responsibilities.
Education and/or Experience:
Bachelor's degree from four-year College or university in Business, Finance or related field; and five to seven years related experience.
Certificates, Licenses, Registrations:
Complexity of Duties:
A wide variety of duties requiring a general knowledge of related organization policies and procedures and their application to cases not previously covered.
Under general direction, works from policies and general objectives with little functional guidance. Rarely refers specific cases to supervisor unless clarification or interpretation of organization policies is involved.
Errors and Quality of Work:
Probable errors or impact on quality of work would be difficult to detect such as the improper or inadequate design of a service, recommendation of unsuitable equipment, people, processes, methods, plans, programs or facilities resulting in excessive costs. May have adverse effect on outside relationships, such as customer, client or community. Work not subject to audit or check; work involves considerable accuracy and responsibility.
English proficiency sufficient for communication with supervisors, co-workers, clients and customers. Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
To perform this job successfully, an individual should have knowledge of Database software; MS PowerPoint Design software; MS Project Management software; MS Excel Spreadsheet software and MS Word Processing software.
Must pass all applicable background checks.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.
Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually moderate.