Yale University offers exciting opportunities for achievement and growth in New Haven, Connecticut. Conveniently located between Boston and New York, New Haven is the creative capital of Connecticut with cultural resources that include three major museums, a critically-acclaimed repertory theater, state-of-the-art concert hall, and world-renowned schools of Architecture, Art, Drama, and Music.
General Purpose: 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 work plan, 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 Information Management and Donor Services team, collaborate with staff from Advancement Systems, and Gift and Records Services, as well as other fundraising units across the University.
Required Education and Experience: Bachelor’s degree in business, technology or related field and three years of experience in analysis of reporting needs and development of related business intelligence solutions or an equivalent combination of education and experience.
Demonstrated ability with supporting business intelligence efforts through creating effective data visualizations/dashboards, including charts, filters and calculations utilizing Tableau and data warehouse tables.
Exceptional reporting and analytical skills, including ability with interpreting data, coding structures and business requirements.
Advanced proficiency with Excel, and strong knowledge of other Microsoft Office products, such as Word, PowerPoint and Outlook.
Excellent project management and organizational abilities with strong attention to detail, strong interpersonal skills, and well-developed written and verbal communication skills. Ability to work either independently or as part of a team, and to handle multiple projects simultaneously.
Ability to maintain confidentiality of information.
Preferred Education and Experience: 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.
Application: For more information and immediate consideration, please apply online at https://bit.ly/2ORf7gI. Please be sure to reference this website when applying for this position.
We invite you to discover the excitement, diversity, rewards and excellence of a career at Yale University. One of the country's great workplaces, Yale University offers exciting opportunities for meaningful accomplishment and true growth. Our benefits package is among the best anywhere, with a wide variety of insurance choices, liberal paid time off, fantastic family and educational benefits, a variety of retirement benefits, extensive recreational facilities, and much more.
Yale University considers applicants for employment without regard to, and does not discriminate on the basis of an individual’s sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Yale discriminate on the basis of sexual orientation or gender identity or expression.
Internal Number: 52101BR
About Yale University
Yale University is an American private Ivy League research university located in New Haven, Connecticut. Founded in 1701 in the Colony of Connecticut, the university is the third-oldest institution of higher education in the United States.