Job Description

Database Analyst

Department:

Finance & Support Services

Reports To:

Information Systems and Technology Manager

Exempt Status

: Non-Exempt

Work Schedule:

Full-Time. Core hours are Monday-Friday, 8:00-4:30 p.m.

Salary Range:

$55,000-60,000/year. Position is currently in-person, with remote work possible on Fridays after 90 days of employment.

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 & 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 & 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 & Integrity:

Ensure data integrity for reporting purposes and monitor compliance with regulations.

Staff Training & 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 & Oversight:

o Maintain and update donor records and ensure data accuracy, consistency, confidentiality and security.

o 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.

o Create and maintain database authorities and user accounts, including staff and non-staff users.

o Maintain data standards and best practices within the database.

o Co-lead the database staff user group to enhance the utilization of the database and relay developed solutions to finance team.

Reporting & Analysis:

o 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.

o Generate regular and ad-hoc reports to support fundraising efforts, donor breakdown and board reporting.

o Analyze giving trends, donor retention and campaign performance to inform strategy.

o Update and maintain ease-of-use elements such as custom dashboards and bio tabs.

Data Integration & Optimization:

o Assist with the design and configuration of internal database to ensure efficient retrieval of information.

o Identify opportunities to improve data workflows and system efficiency.

Staff Support &Training:

o Provide database training for new employees during the onboarding process.

o Serve as a resource for staff to help extrapolate and interpret data.

o Record and catalog staff training videos and create simple, user-friendly training documents

o Identify areas of need in staff knowledge and design training intended to address those needs.

o Maintain continued availability for one-on-one staff training, trouble shooting and questions

Position Qualifications:

Education:

Bachelor's degree in information systems, data analytics or related field

or

2-5 years of data analysis/data management work experience.

Technical Skills:

o Proficient in data analysis and visualization tools like Microsoft Excel, Power BI, or Tableau.

o Strong knowledge of database query languages, such as SQL.

o Experience with non-profit specific CRM's (Salesforce, Blackbaud, Andar) is preferred.

Interpersonal Skills:

o Demonstrate excellent verbal and written communications skills as well as the ability to communicate technical information to non-technical audiences.

o Strong problem-solving and analytical abilities.

o The ability to work both independently and collaboratively with diverse teams.

o 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.

UNITED WAY CORE COMPETENCIES FOR ALL STAFF

? Mission-Focused: Catalyze others' commitment to mission to create real social change that leads to better lives and healthier communities. This drives their performance and professional motivations.
? Relationship-Oriented: Understands that people come before process and is astute in cultivating and managing relationships toward a common goal.
? Collaborator: understands the roles and contributions of all sectors of the community and can mobilize resources (financial and human) through meaningful engagement.
? Results-Driven: Dedicated to shared and measurable goals for the common good; creating, resourcing, scaling, and leveraging strategies and innovations for broad investment and impact.
? Brand Steward: Steward of the brand and understands his/her role in growing and protecting the reputation and results of the greater network.

Job Type: Full-time

Pay: $55,000.00 - $60,000.00 per year

Benefits:

401(k) 401(k) matching Dental insurance Employee assistance program Flexible spending account Health insurance Life insurance Paid time off Vision insurance
Work Location: In person