Job ID 12471 Location Case Main Campus Full/Part Time Full-Time Regular/Temporary Regular Job Description POSITION OBJECTIVE Working under general direction, the director of business intelligence and reporting is responsible for strategic data review and analysis through the creation of reports and data extracts using business intelligence tools and translating that analysis to inform business processes, ensuring prospects effectively move through fundraising pools, portfolios, and pipelines for the university relations and development division and executive leadership team. The incumbent will help turn broad data streams into actionable information for Advancement leadership, prospect managers, and front-line development officers in the university relations and development division and schools/colleges across campus. The director will play a critical role in analyzing the university's prospect pipeline, prioritizing data reporting and analytics initiatives that generate actionable insights and maximize fundraising revenue to the university. The incumbent ensures the effective management of the university's prospect pool and pipeline by applying sophisticated knowledge and skills in the use and manipulation of data and reporting to support all areas of prospect and pipeline development. The director is a creative and agile innovator who takes measured risks, runs pilots, evaluates results, adjusts as indicated and enlists others to produce the very best products and information. ESSENTIAL FUNCTIONS Reporting - Dashboard/Prospect Management: Conceptualize, analyze, and contribute to the design and development of sophisticated and complex comprehensive, unit-wide data visualizations and reports that include assessments of portfolios, pipelines, development officer and unit progress to performance and campaign goals. Develop methodologies and programs for analyzing and presenting data. Review, monitor, and contribute to prospect and proposal pipeline data through the design of custom report audits and extracts, data analysis, and ongoing communication with partners in University Advancement. Perform complex data reporting and analysis that provide support in the areas of campaign progress, annual giving, and engagement. (40%) Reporting - General: Direct and oversee the process and execution of donor report requests ensuring collaboration with colleagues in the university relations and development division on individual donor stewardship plans. Conduct research and develop custom donor reports and correspondence. Ensure appropriate and accurate donor lists are prepared as needed. Oversee the process and execution of pulling data for several types of customized lists including mail/email lists, donor lists, prospect lists, etc. Monitors and evaluates quality and timeliness of list development and delivery to partners. Perform complex data analysis in support of ad-hoc data and analytics requests. Work with senior leadership for guidance on information strategy, vision, and priorities. Lead projects and team meetings to produce the very best products and information. (40%) Reporting - Training/Ongoing maintenance: Evaluate reporting products and vendor-provided packages and their effectiveness for the advancement operation to maintain a stable, efficient, and high-performance analytic and reporting platform. Reviews systems and processes to inform leadership of potential improvements and recommendations. Liaise with partners across campus on projects and data practices and procedures. Provide user support for business intelligence and analytic products, including helping users navigate and understand reports. Serve as a technical resource and mentor to colleagues on the prospect management and prospect research team and as a representative of the department through presentations and training of our partners. Remain current on philanthropic trends as they a