Senior Advancement BI Analyst — Fundraising Insights Leader

Aprahome; Albuquerque, Northern (NM, KY); Hybrid; USD 120,000 - 145,000; Full time

Benefits offered by this job

4 Day Work Week

100% employer-paid medical

Dental & Vision coverage

Paid time off & holidays

Tuition discount

Job summary

Portland State University Foundation seeks a Senior Advancement BI Analyst to design and support BI solutions that illuminate fundraising performance, donor engagement, and campaign progress. You will translate business questions into scalable reporting and dashboards while partnering with colleagues across the Foundation.

The role requires turning complex data into actionable insights, building repeatable reporting processes, training users in self-service analytics, and guiding data

Qualifications

• Bachelor's degree in information systems, Computer Science, Data Analytics, Business Analytics, Statistics, Business Administration, or related field.
• Seven (7) years of progressively responsible experience in business intelligence, data analytics, reporting, or data strategy, including experience developing enterprise reporting solutions.
• Two (2) years in a fundraising and/or advancement environment.
• Demonstrated experience developing reports, dashboards, KPIs, and analytical tools that support frontline fundraising, constituent engagement, annual giving, and advancement leadership needs.
• Demonstrated experience working with SQL, SDK, Visual Studio, data structures, and BI tools (e.g., Power BI, Tableau, SSRS).
• Experience working with fundraising CRM platforms (e.g., Blackbaud CRM, RE NXT, Salesforce).
• Experience working with data warehouses, data modeling, and ETL processes.
• Proven ability to translate fundraising and engagement business requirements into technical solutions.
• Experience implementing reporting standards, documentation practices, quality-control processes, and self-service analytics solutions.
• Demonstrate reliable, regular, and predictable work attendance.

Responsibilities

• Serve as the Foundation’s senior technical expert for BI, reporting, analytics, dashboards, and data visualization.
• Design, build, test, document, and maintain BI solutions that support fundraising performance, campaign execution, pipeline management, donor engagement, and operational effectiveness.
• Translate business questions into usable reporting and analytics tools with stakeholders.
• Develop and maintain reports, dashboards, scorecards, self-service tools, and visualizations and analytical models that support fundraising strategy and engagement outcomes.
• Build and maintain KPIs, business definitions, and calculation logic in alignment with standards established by the AVP and data governance processes.
• Produce pipeline analytics, portfolio performance metrics, campaign reporting, fundraising forecasts, predictive models and other analyses needed for planning and decision-making.
• Translate business needs into scalable reporting and BI solutions that are accurate, user-friendly, and sustainable.
• Analyze data to identify trends, patterns, opportunities, and recommendations that inform fundraising strategy.
• Validate reporting outputs, troubleshoot discrepancies, and partner with data management staff to resolve data quality or logic issues.
• Guide stakeholders in interpreting reports, dashboards, KPIs, and performance metrics.
• Train users on reporting tools, dashboards, and data interpretation to support greater self-service and data literacy.
• Identify trends, insights, and opportunities for reporting improvement.

Skills

SQL

SDK

Visual Studio

Data structures

BI tools

Power BI

Tableau

SSRS

Blackbaud CRM

RE NXT

Salesforce

Data warehouses

ETL processes

Cross-functional collaboration

Education

Bachelor's degree in information systems, Computer Science, Data Analytics, Business Analytics, Statistics, Business Administration, or related field

Job description

Portland State University Foundation seeks a Senior Advancement BI Analyst to design and support BI solutions that illuminate fundraising performance, donor engagement, and campaign progress. You will translate business questions into scalable reporting and dashboards while partnering with colleagues across the Foundation.

The role requires turning complex data into actionable insights, building repeatable reporting processes, training users in self-service analytics, and guiding data