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!

Overview

Reporting to the Associate Director, Business Intelligence, the Associate Analyst, Business Intelligence supports the business intelligence efforts of Alumni Affairs and Development through data visualization, reporting, analysis, and project support. The position focuses on developing meaningful and effective dashboards and reporting solutions that support understanding of fundraising results and alumni activities, while ensuring the accuracy, consistency, and usability of business intelligence resources.

Key areas of responsibility include:

• Business Intelligence, Reporting, and Data Visualization: Understand and utilize relevant Alumni Affairs and Development systems, internal reporting structures, and applicable guidelines, serving as a subject matter expert for these functions. Ability to design effective data visualizations and dashboards, including determining appropriate chart options, filter options, calculations, and consistent metrics using data visualization tools and data warehouse tables.
• Data Analysis and Optimization: Optimize existing coding structures, standard metrics, and data to support business intelligence efforts, and conduct research and analysis of data elements. Perform testing of dashboard functionality, calculations, and visualizations using internal database systems and other tools.
• Project Management and Business Requirements: Support project management efforts for business intelligence projects, from inception through completion, including developing and maintaining the workplan, timeline, and status for all relevant tasks. Work effectively and efficiently with Alumni Affairs and Development staff to gather business requirements and ensure the creation of accurate and meaningful dashboards.
• Documentation and User Support: Create and maintain appropriate end-user documentation for dashboard content.
• Data Warehouse and Systems Collaboration: Collaborate with ITS to coordinate new data fields and calculations in the data warehouse, quality assurance testing, dashboard publishing, access, security, and data refreshes.
• Change Management and Training: Support in developing change management plans and communications. Collaborate with Advancement Systems to develop and incorporate training materials into the standard training curriculum.
• Cross-Functional Collaboration: Collaborate with Analytics and Data Services team members on 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.

The following principal responsibilities are generic in nature. Applicants will find the information in this position focus to be most relevant to the needs of the position.

Required Skills and Abilities
1. Experience with supporting business intelligence efforts through creating effective data visualizations/dashboards, including charts, filters and calculations utilizing Power BI and Microsoft SQL Server data warehouse tables. Exceptional reporting and analytical skills, including experience with interpreting data, coding structures, business requirements and Microsoft T-SQL programming language.

2. Advanced proficiency with Excel, and strong knowledge of other Microsoft Office products, such as Word, PowerPoint and Outlook.

3. 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.

4. Ability to maintain strict confidentiality of information.

5. Commitment to an inclusive workplace.

Preferred Skills and Abilities

1.Familiarity with university and/or development programs, processes, and practices.

2.Knowledge of external higher education database tools.

3.Experience in higher education advancement services.

4.Experience with Blackbaud CRM or other fundraising and relationship management systems.

Principal Responsibilities

1. Work with business partners and process owners to document data, reporting and BI requirements and performance targets. 2. Develops and maintains a standard methodology for documenting and codifying requirements and specifications using standard templates that meet the needs of both business partners and ITS. 3. Develop prototypes and mock-ups to help elicit and define requirements. 4. Partner with ITS to identify reporting & BI solutions, including evaluation of commercial off-the-shelf software and other solutions. 5. Develop prototypes using reporting software & BI tools to model and iterate requirements, and ensure the appropriateness of chosen solutions. 6. Provide analytical support for the development and deployment of solutions, and collaborates with developers and end-users to insure that application functionality meets business needs. 7. Develops test cases and scenarios, and actively participates in the testing and quality assurance process. 8. Contributes to the deployment planning, including training, communications and user readiness planning. 9. Facilitate and support data stewardship and governance processes. 10. Develop metrics to monitor data quality. 11. Analyze and resolve data quality and reporting issues. 12. May perform other duties as assigned. 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.

Job Posting Date

10/12/2026

Job Category

Professional

Bargaining Unit

NON

Compensation Grade

Administration & Operations

Compensation Grade Profile

Manager; Program Leader (P5)

Salary Range

$68,000.00 - $120,500.00

Benefits

A general description of the benefits to be offered with this Managerial & Professional position is available at:

Yale Benefits

Time Type

Full time

Duration Type

Staff

Work Model

Hybrid

Background Check Requirements

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks basedon the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

Health Requirements

Certain positions have associated health requirements based on specific job responsibilities. These may include vaccinations, tests, or examinations, as required by law, regulation, or university policy.

Posting Disclaimer

Salary offers are determined by a candidate’s qualifications, experience, skills, and education in relation to the position requirements, along with the role’s grade profile and current internal and external market conditions.

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the position. Employees will be assigned specific job-related duties throughtheir hiring department.

The University is committed to basing judgments concerning the admission, education, and employment of individuals upon their qualifications and abilities and seeks to attract to its faculty, staff, and student body qualified persons from a broad range of backgrounds and perspectives. In accordance with this policy and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.

Inquiries concerning Yale's Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).

Note

Yale University is a tobacco-free campus.