Associate Analyst, Business Intelligence

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community‑eligible for opportunities through the New Haven Hiring Initiative or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

Reporting to the Associate Director, Business Intelligence, support the business intelligence efforts of Alumni Affairs and Development, using data visualization tools to develop reporting and analysis of fundraising results and alumni activities. Understand and utilize relevant Alumni Affairs and Development systems, and applicable internal reporting structures and guidelines, and serve as a subject matter expert for these functions. Under the direction of the Associate Director, Business Intelligence, design effective data visualizations/dashboards, including chart options, filter options, calculations and consistent metrics using data visualization tools and data warehouse tables.

Optimize existing coding structures, standard metrics and data to support business intelligence efforts, and perform research and analysis of data elements. Perform testing of dashboard functionality, calculations and visualizations utilizing internal database systems and other tools. Support the Associate Director, Business Intelligence, with project management efforts for business intelligence projects, from inception to completion, including the workplan, timeline and status for all relevant tasks.

Work effectively and efficiently with the Alumni Affairs and Development staff to gather business requirements to ensure accurate and meaningful dashboard creation. Create and maintain appropriate end user documentation for dashboard content. Collaborate with ITS to coordinate new data fields and calculations in the data warehouse, quality assurance testing, publishing of dashboards, access, security and data refreshes. Support the Associate Director, Business Intelligence, to develop change management plans and communications.

Collaborate with Advancement Systems to develop and incorporate training materials into the standard training curriculum. Collaborate with Analytics and Data Services team members for business intelligence projects, and as part of the larger Information Management and Donor Services team, collaborate with staff from Advancement Systems, and Gift & Records Services, as well as other fundraising units across the University.

Familiarity with university and/or development programs, processes, and practices. Knowledge of external higher education database tools. Experience in higher education advancement services. Experience with Blackbaud CRM or other fundraising and relationship management systems. Experience utilizing Tableau to create interactive data visualizations.