Divisional Donor Data Analyst

LOCATION: SW DHQ

STATUS: FT/40hrs/wk

MISSION STATEMENT: The Salvation Army, an international movement, is an evangelical part of the universal Christian church. Its message is based on the Bible. Its ministry is motivated by the love of God. Its mission is to preach the gospel of Jesus Christ and to meet human needs in His name without discrimination.

QUALIFICATIONS:

• HS Diploma or GED required.
• Bachelor's degree in a Business or Information Technology discipline or equivalent experience strongly preferred.
• Experience with a customer-relationship management (CRM) database or Enterprise Resource Planning (ERP) software
• Experience with Microsoft reporting solutions such as SSRS, Report Builder, and Microsoft PowerBI required.
• Ability to write SQL queries to serve as report builder or PowerBI data sets
• Proficiency in Microsoft Office Suite and advanced knowledge of Microsoft Excel.
• Experience in creating dashboard views from raw data.
• Experience creating data visualizations.
• Capacity to learn donor services platforms/software.
• Nonprofit development experience preferred, with knowledge of donor relations.
• Extensive skills in multi-tasking, time management, and project management.
• Excellent written and verbal communication skills.
• Strong analytical and problem-solving skills.
• Ability to produce a high volume of work in a timely manner.
• Knowledge of office procedures and equipment.
• Ability to type 60-70 wpm.
• A pleasant and professional demeanor when interacting with all stakeholders.
• Ability to pass a criminal background check.

RESPONSIBILITIES:

• Evaluate, develop, and maintain the entirety of the current divisional reporting suite, ensuring that all identified stakeholders across the division receive accurate reports at the appropriate cadence.
• Make suggestions and execute creation for the continual enhancement of the divisional reporting suite to maximize the effectiveness of Major Gifts, Midlevel Fundraising, Donor Engagement, Corporate Relations, Gift Planning, and Grants.
• Develop and maintain visual dashboards utilizing Business Intelligence software including but not limited to Microsoft PowerBI.
• Collaborate with other data stakeholders to ensure accurate integration and representation of CRM data in reporting and visual dashboards.
• Audit reports and dashboards at prescribed intervals to ensure accuracy.
• Generate ad-hoc reports as directed by the Divisional Director of Donor Impact.
• Serves as the backup to the Divisional Director of Donor Impact in entering marketing and communications data into the CRM.
• Performs batch entry and global additions into CRM as appropriate and with approval from the Divisional Director of Donor Impact.
• Maintains knowledge of donor care systems utilized by the territory, including, but not limited to, GoFundMe Pro, Paypoint, and R360, and understands how to extract data from these systems.
• Communicates and collaborates with the divisional finance department in the accuracy of revenue data as appropriate.
• Communicates and collaborates with the Territorial Data Management team on utilization and optimization of reporting.
• Executes data cleanup and research projects assigned by the Divisional Director of Donor Impact.
• Attend departmental meetings and monthly THQ Data Management meetings.
• Maintains a professional, can-do attitude and can manage unanticipated changes that have tight turnaround times by adjusting schedules for other projects and clearly communicating those changes to stakeholders and team members.
• Assist the Development team during emergency needs and holiday season activities.
• Other duties as assigned as related to the position of Divisional Donor Data Analyst.

PHYSICAL REQUIREMENTS:

Qualified individuals must be able to perform the essential duties of the position with or without accommodation. A qualified person with a disability may request a modification or adjustment to the job or work environment in order to meet the physical requirements of the position. The Salvation Army will attempt to satisfy requests as long as the accommodation needed is reasonable and no undue hardship would result.

While performing the duties of this job, the employee is regularly required to walk, stand, climb or balance, stoop, kneel, crouch, crawl and reach with hands and arms on a continuous basis. The employee must regularly lift and/or move up to 5 pounds, frequently lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, depth perception and ability to adjust focus. Must have the ability to operate telephone, a desktop or laptop computer, as well as the ability to access and produce information from a computer, and to understand written information.