Yale University · 1 month ago
Associate Analyst, Business Intelligence
New Haven, CT
Full-time
Onsite
Mid Level
$68K/yr - $120K/yr
3+ years expYale University is dedicated to contributing to a better tomorrow and is seeking an Associate Analyst for Business Intelligence. This role focuses on supporting business intelligence efforts through data visualization and reporting, collaborating with various teams to enhance fundraising analysis and alumni activities.
AssociationBusiness DevelopmentEducationMedicalSocial Entrepreneurship
Responsibilities
Work with business partners and process owners to document data, reporting and BI requirements and performance targets
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
Develop prototypes and mock-ups to help elicit and define requirements
Partner with ITS to identify reporting & BI solutions, including evaluation of commercial off-the-shelf software and other solutions
Develop prototypes using reporting software & BI tools to model and iterate requirements, and ensure the appropriateness of chosen solutions
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
Develops test cases and scenarios, and actively participates in the testing and quality assurance process
Contributes to the deployment planning, including training, communications and user readiness planning
Facilitate and support data stewardship and governance processes
Develop metrics to monitor data quality
Analyze and resolve data quality and reporting issues
May perform other duties as assigned
Qualification
Required
Demonstrated 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
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 strict confidentiality of information
Commitment to an inclusive workplace
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
Preferred
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
Company
Yale University
Yale University is a research and education institution that prioritizes its students.
10001+ employees
H1B Sponsorship
Yale University has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (355)
2024 (449)
2023 (214)
2022 (208)
2021 (190)
2020 (155)
Funding
Current Stage
Late StageTotal Funding
$42.86MKey Investors
Bezos Earth FundAlfred P. Sloan FoundationHyundai Hope On Wheels
2025-10-23Grant
2025-05-21Grant· $0.05M
2023-01-01Grant· $1.27M
Leadership Team
Geoffrey Chatas
Senior Vice President for Operations
Jack Callahan
Senior Vice President for Operations
Recent News
2025-12-10
Company data provided by crunchbase