Senior Advancement Business Intelligence Analyst

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

Benefits offered by this job

4 Day Work Week

Employer-paid medical

Dental and vision coverage

Paid time off + holidays

401(k) retirement plan

Long-Term Disability and LifeInsurance

Tuition discount

Job summary

PSU Foundation, based in Portland, Oregon, seeks a senior BI leader to design, build, and maintain reporting and analytics solutions that support fundraising performance, campaign execution, and donor engagement. You will partner with fundraising, finance, and engagement teams to translate questions into usable reporting tools and drive data-driven decision-making.

The role emphasizes governance, data quality, scalable BI practices, and user adoption across the Foundation.

Qualifications

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

Responsibilities

• Develop and maintain reports, dashboards, scorecards, self-service tools, and visualizations.
• Define KPIs and calculations with data governance in mind.
• Produce pipeline analytics, portfolio performance metrics, campaign reporting, and fundraising forecasts.
• Translate business needs into scalable BI solutions that are accurate and user-friendly.
• Guide stakeholders in interpreting reports and train users on tools to improve data literacy.
• Identify trends and opportunities for reporting improvements.

Skills

SQL

Data analysis

Stakeholder communication

Problem solving

Power BI

Education

Bachelor's degree in information systems

Seven years BI experience

Tools

Power BI

Tableau

SSRS

SQL

Blackbaud CRM

RE NXT

Salesforce

Job description

About Us

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 fostera strong senseof belonging—empowering every team member to show up authentically and think boldly.

At PSU, more than half of incoming first-year students identify asBIPOC,nearly aquarter 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

In thisnewrole, you will help PSUF make better decisions by turning data into opportunities and recommendations.Your work will helpidentifyprospective major donors, highlight trends in engagement and giving, and provide the analysis needed to support fundraising strategy. You will partner closely with colleagues across the organization to answer important questions, solve problems, and uncover new opportunities.

Youmayenjoythis role ifyou:

• Love exploring data and uncovering insights that help people make better decisions.

• Enjoy asking questions, solving problems, and connecting dots.

• Arehappypartnering with colleagues and translating complex information into actionable recommendations.

• Take ownership of your work while openly sharing knowledge and learning from others.

• Enjoy continuous learning and exploring new tools, techniques, and approaches.

• Are motivated by seeing your work inform strategy and drive meaningful outcomes.

Position Overview

Business Intelligence(BI)Solution Design & TechnicalImplementation

• Serve as the Foundation’s senior technical expert for business intelligence, reporting, analytics, dashboards, and data visualization.

• Design, build, test, document, andmaintainBI 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 andmaintainreporting datasets, dashboards, reports, scorecards, and analytical tools using approved platforms and standards.

• Provide subject matterexpertiseon BI tools, data structures, reporting logic, and analytics methods.

Reporting Analytics& Dashboard Delivery

• Develop andmaintainreports, dashboards, scorecards, self-servicetools, andvisualizationsand analytical modelsthat support fundraisingstrategyand engagement outcomes.

• Build and maintain KPIs, business definitions, and calculation logic in alignment with standardsestablishedby the AVP and data governance processes.

• Produce pipeline analytics, portfolio performance metrics, campaign reporting, fundraising forecasts,predictivemodelsand other analyses needed for planning and decision-making.

• Translate business needs into scalable reporting and BI solutions that areaccurate, user-friendly, and sustainable.

• Analyze data toidentifytrends, patterns, opportunities, and recommendations that inform fundraisingstrategy.

• Validate reporting outputs, troubleshoot discrepancies, and partner with data management staff to resolve data quality or logic issues.

• Guidestakeholders 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.

• Identifytrends, insights, and opportunities for reporting improvement.

Governance, Process Improvement & User Adoption

• Implement andmaintainreporting standards, business definitions, documentation, and quality-control practicesestablishedthrough 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.

• Identifyinefficiencies 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.

• Supportthe adoptionof 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.

MinimumQualifications

• 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 ina 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 withSQL,SDK, VisualStudio,datastructures, and BI tools (e.g., Power BI, Tableau, SSRS).

• Experience working withfundraisingCRM platforms (e.g., Blackbaud CRM, RE NXT, Salesforce).

• Experience working withcomplex fundraisingdataenvironments including data warehouses, data modeling, and ETL processes.

• Proven ability to translatefundraising and engagementbusiness requirements into technical solutions.

• Experience implementing reporting standards, documentation practices, quality-control processes, and self-service analytics solutions.

• Strong communicationand 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 matterexpertise, clear communication, and practical problem-solving.

• Proficiencywith commonly used workplace technologies, including Microsoft Office, SharePoint, CRM platforms, and other cloud-based collaboration and document management tools;demonstratedability toleverageemerging 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 ofhigher education foundationfundraising data, KPIs, and advancement reporting practices.

Compensation & Benefits

Our compensation philosophy reflects our commitment topay 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’vetransitioned 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-timeemployeebenefitsinclude:

• 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 to27 daysof paid time offplus10 paid holidays, including one floating holiday

• Up to12% employer contributionto eligible 401(k) plans after applicable waiting periods

• Employer-paidLong-Term DisabilityandLife Insurance

• Portland State University affiliated employee benefits, including tuition discount

PSU Foundation is proud to be an equal opportunity employer.