Database Analyst
Department: Finance and Support Services
Reports To: Information Systems and Technology Manager
Exempt Status: Non-Exempt
Work Schedule: Full-Time with core hours of Monday-Friday, 8 a.m.- 4:30 p.m.
Purpose of Position: To collect, clean and analyze data on fundraising, donor engagement, and program outcomes to support strategic decision-making, improve operational efficiency, assess organizational impact and improve the organization’s data fluency. Key responsibilities include creating dashboards and reports, identifying trends in data, ensuring data integrity, collaborating with internal teams, presenting actionable insights to leadership and building data literacy through training and support to staff.
Essential Functions
- Data Collection and Management: Gather data from various sources, clean it for accuracy, and maintain databases.
- Data Analysis: Use statistical techniques to analyze donor data, fundraising efforts, program performance, and operational metrics.
- Reporting and Visualization: Develop dashboards, reports, and presentations to communicate data-driven insights and trends to stakeholders and leadership.
- Strategic Support: Provide data-driven recommendations to improve fundraising campaigns, optimize resource allocation, and enhance program effectiveness.
- Collaboration: Work closely with fundraising, development, and program teams to understand data needs and ensure data accuracy.
- Compliance and Integrity: Ensure data integrity for reporting purposes and monitor compliance with regulations.
- Staff Training and Capacity Building: Develop and deliver employee training (data usage, best practices, data entry and collection), create user-friendly resources, promote data fluency (data-driven culture) and provide technical support.
General Database Maintenance and Oversight:
- Maintain and update donor records and ensure data accuracy, consistency, confidentiality and security.
- Database maintenance including but not limited to account merging, cleanup, scheduling and monitoring rebuilds, importing of files and other data and other trouble shooting tasks.
- Create and maintain database authorities and user accounts, including staff and non-staff users.
- Maintain data standards and best practices within the database.
- Co-lead the staff database user group to enhance the utilization of the database and relay developed solutions to finance team.
Reporting and Analysis:
- Support the collection and reporting of revenue data including interpreting data, analyzing results, providing ongoing reports and partnering with appropriate staff members to resolve any discrepancies.
- Generate regular and ad-hoc reports to support fundraising efforts, donor breakdown and board reporting.
- Analyze giving trends, donor retention and campaign performance to inform strategy.
- Update and maintain ease-of-use elements such as custom dashboards and bio tabs.
Data Integration and Optimization:
- Assist with the design and configuration of internal database to ensure efficient retrieval of information.
- Identify opportunities to improve data workflows and system efficiency.
Staff Support and Training:
- Provide database training for new employees during the onboarding process.
- Serve as a resource for staff to help extrapolate and interpret data.
- Record and catalog staff training videos and create simple, user-friendly training documents
- Identify areas of need in staff knowledge and design training intended to address those needs.
- Maintain continued availability for one-on-one staff training, trouble shooting and questions
Position Qualifications
- Bachelor’s degree in information systems, data analytics or related field or 2-5 years of data analysis/data management work experience.
- Proficient in data analysis and visualization tools like Microsoft Excel, Power BI, or Tableau.
- Strong knowledge of database query languages, such as SQL.
- Experience with non-profit specific CRM’s (Salesforce, Blackbaud, Andar) is preferred.
- Demonstrate excellent verbal and written communications skills as well as the ability to communicate technical information to non-technical audiences.
- Strong problem-solving and analytical abilities.
- The ability to work both independently and collaboratively with diverse teams.
- Ability to prioritize tasks and focus on multiple projects and deadlines simultaneously.
Physical Requirements
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. While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; balance; stoop, kneel, crouch or crawl; talk or hear; The employee must occasionally lift or move up to 25 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus.
Travel
Travel is primarily local during the business day, although some out-of-area and overnight travel may be expected.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
Salary Range
$55,000-$60,000 per year. Position is currently in-person, with remote work possible on Fridays after 90 days of employment.
To Apply
Interested applicants should send their resume and cover letter to [email protected].
