Senior Advancement BI & Analytics Lead

Portland State University Foundation; Portland (OR); On-site; USD 120,000 - 145,000; Full time

Benefits offered by this job

4 Day Work Week

100% employer-paid medical coverage

Dental and vision coverage

Paid time off & holidays

Job summary

Portland State University Foundation seeks a Senior Advancement Business Intelligence Analyst to advance reporting, analytics, and data visualization for fundraising performance, donor engagement, and campaign progress.

The role partners with multiple teams to translate needs into scalable BI solutions, validate data, and support decision-making with predictive insights. Strong SQL, Power BI, and CRM experience are essential for success.

Qualifications

• Bachelor's degree in information systems, computer science, data analytics, business analytics, statistics, business administration, or related field; or equivalent.
• Seven (7) years of progressively responsible experience in BI, data analytics, reporting, or data strategy with enterprise reporting experience.
• Two (2) years in a fundraising/advancement environment.
• Experience developing reports, dashboards, KPIs, and analytics tools for fundraising and engagement.
• Experience with SQL, SDK, Visual Studio, data structures, and BI tools (Power BI, Tableau, SSRS).
• Experience with fundraising CRM platforms (e.g., Blackbaud CRM, RE NXT, Salesforce).
• Experience with data warehouses, data modeling, and ETL processes.

Responsibilities

• Design, build, test, document, and maintain BI solutions supporting fundraising performance and engagement.
• Translate business needs into scalable reporting and analytics solutions; gather requirements and validate data.
• Develop reporting datasets, dashboards, reports, scorecards, and analytical tools using approved platforms.
• Create KPIs and calculation logic aligned with governance standards; produce pipeline and forecasting analyses.
• Guide stakeholders in interpreting reports and train users for self-service analytics.

Skills

SQL

Power BI

Tableau

Data Visualization

Data Analytics

Stakeholder Engagement

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field

Tools

Visual Studio

SSRS

Blackbaud SDK

Python

Job description

Portland State University Foundation seeks a Senior Advancement Business Intelligence Analyst to advance reporting, analytics, and data visualization for fundraising performance, donor engagement, and campaign progress.

The role partners with multiple teams to translate needs into scalable BI solutions, validate data, and support decision-making with predictive insights. Strong SQL, Power BI, and CRM experience are essential for success.