Priority Application Deadline FLSA Status June 14, 2024 Exempt
Salary Work Location $76,751 - $95,939 (Step I) Hybrid or Remote 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 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 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 Reportsand 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.
You should have
- 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
- 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.
Working Conditions