Business Intelligence Director jobs in Oregon

About the Position

The OHSU Foundation is heavily dependent on the information systems which support the fundraising priorities of the institution. The Assistant Director of Business Intelligence serves as one of a team of experts in the methods used to define, report on and otherwise develop new structures and processes for business intelligence. The position works closely with all departments to turn data into critical information and knowledge that can be used to make strategic business decisions, plays an essential role in the growth and continuous improvement of the reporting environment, and supports key process change and/or system related projects.

What You’ll Be Doing

• 
  Create Detailed Extractions: Develop new reports for data modeling, analysis, communication, cultivation, research, and solicitation purposes
• Maintain Self-Service Report Environment: Develop, validate, test and maintain stored procedures, dashboards, and reports for a self-service reporting environment for functional users; serve as analyst and developer of report and dashboard design, utilizing SQL, Microsoft SQL Reporting Services, Visual Studio, Tableau and the Foundation’s Data Warehouse environment
• Maintain Affinaquest Reporting Environment: Develop reports, visualizations and dashboards in the Affinaquest/Salesforce environment, extract, analyze and report data using Affinaquest's reporting tools, and troubleshoot errors or inconsistencies in Affinaquest reports
• Special Projects: Undertake special projects related to ongoing campaign initiatives and Foundation operations as assigned
• Customer Service: Respond to time-sensitive requests and build and and ensure high customer service levels with both internal and external partners

Who You Are

• 
  Technical Skills. Advanced knowledge of donor CRM systems and business intelligence tools such as SQL, SSRS and Tableau. Experience with report and dashboard development utilizing Salesforce/Affinaquest Reports and Apsona. Ability to read, write and maintain SQL code T-SQL coding and tuning. Knowledge of data warehousing architecture and dimensional modeling concepts
• Project Management Skills. Ability to meet deadlines, prioritize projects, and demonstrate excellent attention to detail
• Communication Skills. Ability to communicate effectively with both technical and non-technical personnel. Compassionate and culturally responsive; skilled at engaging with a wide range of individuals in various settings.

Required Experience:

• 5 years’ experience in database management, data analysis, and report and dashboard development
• 5 years’ experience developing visualizations, dashboards, stories and reports using Tableau and SSRS
• Experience using Transact SQL to develop stored procedures
• Experience gathering and documenting business requirements
• Experience creating technical documentation of reports and data/report models
• Familiarity with report execution and database interaction

Preferred Experience:

• Prior programming experience

Working Conditions:

• Prolonged use of computer

We want to emphasize that there is no such thing as the perfect candidate; candidates who do not have all of the required experience are encouraged to apply.

Benefits

The OHSU Foundation also offers an exceptional benefits package including:

• Comprehensive medical and dental insurance;
• Pension program (The Foundation contributes 12% of your annual salary to a pension);
• 22 days of paid vacation, 12 paid holidays, 1 float holiday and 2 days of volunteer time off;
• Professional development dollars for each employee;
• Hybrid work allowance

Want to read about our other amazing benefits? Check out our benefits page to learn more

About the OHSU Foundation

The OHSU Foundation is one of the largest public university foundations in the Northwest and exists to advance OHSU’s vital mission of creating a healthier world by igniting the power of philanthropy. We are a mission-driven organization, unrelentingly committed to both our donors and our employees. Our fundraising fuels research in cancer, heart disease, and Alzheimer’s (amongst other things), and helps support Doernbecher Children’s Hospital, one of the nation’s top children’s hospitals.

Here are just a few of the things that make the OHSU Foundation an exceptional place to work:

Our work has impact - Our fundraising fuels research in cancer, heart disease, and Alzheimer’s (amongst other things), and helps support one of the nation’s top children’s hospitals.

We have amazing benefits – Beyond excellent medical, dental, vision, and paid family leave benefits, we also have a generous pension plan. Yes, we said pension plan.

We believe in work/life balance – We offer substantial PTO and paid family leave, as well as 11 paid holidays, 1 floating holiday, and volunteer time off. Plus, we have a flexible hybrid work environment, and we close early on Fridays during the summer.

We support employee growth – Each employee has an annual allotment of professional development and tuition reimbursement dollars, as well as full access to LinkedIn Learning.

We have fun – Think ice cream socials, ugly sweater competitions, First Thursday Socials, and Trivia Nights.

If this sounds like your kind of place, apply today!

Our Values

We believe that our core values of alignment, compassion, equity, collaboration, integrity and impact are imperative to our success. We are committed to sustaining a culture where our values inform the ways in which we engage with one another and with our work. Read more about our Core Values.

Pay

Salary is dependent on experience. Each salary band is broken into three "steps," which correspond with an employee’s experience/tenure, proficiency and performance in that specific role. New employees will typically start at step I of our pay band to allow for later growth, although more experienced candidates may be eligible to start at step II or III. The OHSU Foundation has a structured process for determining starting compensation, taking into account years of related experience, applicable skills, knowledge and abilities, market parity, and internal equity.

Equal Opportunity Employer