Fundraising Analytics Developer

Title: Fundraising Analytics Developer

Location: Dallas United States

Job Description:

JOB SUMMARY

The Analytics Developer at BSW Health Foundations will play a key role in developing, maintaining, and optimizing the information leveraged by BSW Health's fundraising programs. The developer will create and edit reports, data visualizations, and solutions that deliver actionable information to business leaders, colleagues, and community members. This role will support the foundation's finance team with report development and troubleshooting to help build efficiency and minimize redundancy and support the foundation's fundraising teams to understand goals and progress, as well as other constituencies working in conjunction with BSW Health's fundraising efforts.

An ideal candidate will bring experience with Power BI, Raiser's Edge and Financial Edge querying and reporting. Candidates who know only one (or two) of the three programs should still consider applying if there is a proven track record of learning new software quickly. A strong background with Power Query in Excel will be considered in lieu of Power BI experience.

This is an on-site/hybrid role in Dallas, TX near Deep Ellum. Fully/mostly remote will not be considered.

ESSENTIAL FUNCTIONS OF THE ROLE

• Edit and maintain Power BI dashboards: Utilize Power BI to edit and maintain reusable analytical solutions connecting to resources in a variety of locations and access levels. Troubleshoot user issues resulting from the use of reports, data sets, or analytical solutions. Train and guide key sponsors, stakeholders, and team members to help them understand the information most useful to their work. A successful candidate will build trust and rapport through active listening and attention to detail.
• Database reporting: Develop, maintain, and troubleshoot reports and queries generated in Financial Edge and Raiser's Edge. A successful candidate will become proficient in querying and reporting from these platforms.
• Power BI/Fabric capacity: Monitor semantic models for any refresh issues, troubleshooting as necessary. Manage access control for new/departing users. Work with IT partners for larger technical problems with servers, dashboard access, etc.
• Support data integrity: Work with colleagues to ensure data integrity of major donor and prospect information by acting as a resource for database questions, process development, etc.
• Document policies and procedures: Write or revise documentation for current Power BI reports, internal procedures, and future resources as necessary.
• Provide training and ongoing support to end users on software and solutions.
• Other duties as assigned.

REQUIREMENTS

• Bachelor's degree.
• 4 to 6 years of experience in fundraising, finance, business analytics, programming, or some other advanced reporting systems.
• Experience cleaning, prepping, and troubleshooting large data sets for analytical use.
• 3 to 5 years of experience working with Power Query in Excel or Power BI and/or Raiser's Edge/Financial Edge. If experience is stronger in RE/FE reporting, then a candidate must bring a strong desire to learn advanced Power BI/Power Query independently.
• Strong communication skills with the ability to work with end-users across a spectrum of technical skills and responsibilities.
• Self-starter with the ability to work independently (self-directed work) at times as well as on a team (participating in projects to explore data needs, training new users, etc.)
• Flexibility, intellectual curiosity, creativity, and strong attention to detail. Creative problem-solving is a must.

PREFERRED QUALIFICATIONS

• Extensive experience with the fundraising industry and working in support operations.
• Previous experience working with healthcare (operational /financial) data and healthcare EMR systems (Epic)
• Experience with all applications: Power BI, Raiser's Edge and Financial Edge
• Experience with Power Apps or Power Automate

BENEFITS

Our competitive benefits package includes the following:

• Immediate eligibility for health and welfare benefits
• 401(k) savings plan with dollar-for-dollar match up to 5%
• Tuition Reimbursement
• PTO accrual beginning Day 1

Note: Benefits may vary based upon position type and/or level

QUALIFICATIONS

• EDUCATION - Bachelor's
• EXPERIENCE - 6 Years of Experience