Senior Advancement Business Intelligence Analyst

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 (PSU) Foundation fuels the mission and priorities of Oregon’s most diverse, innovative, and affordable research university by raising and stewarding philanthropic gifts that transform lives and communities.

Recognized as one of Oregon’s best non-profits to work for five years in a row, we are a community of purpose-driven professionals who lead with heart, act with trust, and keep our mission forward in everything we do. Guided by creativity and collaboration, we foster a strong sense of belonging—empowering every team member to show up authentically and think boldly.

At PSU, more than half of incoming first-year students identify as BIPOC, nearly a quarter are parents, and half are the first in their families to attend college. When PSU graduates thrive, families transform, communities prosper, and innovation expands. The PSU Foundation plays a vital role in advancing this impact by inspiring donors, engaging alumni and community partners, and stewarding resources to Portland State University with integrity and purpose.

About The Role

The Senior Advancement Business Intelligence Analyst serves as the Foundation’s senior technical expert for business intelligence, reporting, analytics, and data visualization. This role designs, builds, and supports business intelligence solutions that help leaders and frontline teams understand fundraising performance, pipeline activity, donor engagement, campaign progress, operational trends and future opportunities through advanced analytics and predictive insights.

This position translates business needs into scalable reporting, dashboard, and analytics solutions. The role partners closely with stakeholders to gather requirements, develop technical solutions, validate data, improve reporting processes, and strengthen the organization’s ability to use data in decision making.

Position Overview

Business Intelligence (BI) Solution Design & Technical Implementation

• Serve as the Foundation’s senior technical expert for business intelligence, 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.
• Execute the BI priorities, translating strategic direction into practical reporting and analytics solutions.
• Partner with fundraising, annual giving, alumni engagement, donor services, finance, and other stakeholders to gather requirements and translate business questions into usable reporting and analytics tools.
• Recommend technical approaches, reporting structures, data models, and visualization methods that improve accuracy, usability, scalability, and sustainability.
• Build and maintain reporting datasets, dashboards, reports, scorecards, and analytical tools using approved platforms and standards.
• Provide subject matter expertise on BI tools, data structures, reporting logic, and analytics methods.
• 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.

Governance, Process Improvement & User Adoption

• Implement and maintain reporting standards, business definitions, documentation, and quality-control practices established through the Foundation’s data and reporting governance framework.
• Maintain documentation for reporting logic, data sources, dashboards, and standard reports to support transparency and continuity.
• Manage reporting intake, requirements clarification, development timelines, testing, and lifecycle maintenance for assigned BI solutions.
• Identify inefficiencies in reporting workflows and recommend improvements to strengthen accuracy, usability, and sustainability.
• Support the transition to a more proactive, standardized BI function by improving report consistency, documentation, and self-service access.
• Support the adoption of self-service reporting tools and data literacy practices across fundraising and engagement teams.
• Evaluate emerging technologies, including AI-enabled analytics and automation tools, and recommend practical applications to improve reporting efficiency and insight generation.
• Perform other duties as assigned.

Minimum Qualifications

• Bachelor's degree in information systems, Computer Science, Data Analytics, Business Analytics, Statistics, Business Administration, or a related field; or an equivalent combination of education and progressively responsible experience.
• 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 complex fundraising data environments including 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.
• Strong communication and stakeholder engagement skills, including the ability to translate business needs into technical requirements and explain reporting outputs to both technical and non-technical audiences.
• Ability to contribute technical leadership to cross-functional projects and influence stakeholders through subject matter expertise, clear communication, and practical problem-solving.
• Proficiency with commonly used workplace technologies, including Microsoft Office, SharePoint, CRM platforms, and other cloud-based collaboration and document management tools; demonstrated ability to leverage emerging technologies to enhance productivity, accuracy, and overall work quality.
• Demonstrated ability to work effectively in an inclusive, equitable, and respectful environment, collaborating with individuals from diverse backgrounds, identities, and experiences.
• Commitment to fostering a positive and collaborative workplace culture through active engagement with colleagues, open communication, and alignment with organizational values and culture initiatives.
• Demonstrate reliable, regular, and predictable work attendance.

Preferred Qualifications

• Experience with Blackbaud CRM.
• Experience with Microsoft Power BI, Microsoft Fabric, Microsoft SQL Server 2019/2022, and Blackbaud SDK, and Python.
• Strong understanding of higher education foundation fundraising data, KPIs, and advancement reporting practices.

Our compensation philosophy reflects our commitment to pay equity, transparency, and valuing the contributions of every team member.

Hiring Range

$120,000 - $145,000 / year

• Offers are determined based on a candidate’s skills, experience, and qualifications, while ensuring internal pay equity.

4-Day Workweek:

As part of our commitment to wellness and workplace culture, we’ve transitioned to a 4-day workweek—an innovative shift that reflects our values and promotes balance across our team. Business operations are closed on Fridays, supporting work-life balance and recognizing the value of your time.

Top-Tier Benefits

We offer one of Oregon’s leading nonprofit benefits packages, designed to support the well‑being of employees and their families. Full-time employee benefits include:

• 4 Day Work Week, with business operations closed on Fridays
• 100% employer-paid medical coverage on our base plan
• 95% employer-paid dental and vision coverage
• Up to 27 days of paid time off plus 10 paid holidays, including one floating holiday
• Up to 12% employer contribution to eligible 401(k) plans after applicable waiting periods
• Employer-paid Long-Term Disability and Life Insurance
• Portland State University affiliated employee benefits, including tuition discount

Don’t meet every requirement? We’d still like to hear from you!

PSU Foundation is proud to be an equal opportunity employer.