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.
Preferred Education: 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.
Preferred Education, Experience and Skills: 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.
Required Skill/ability 5: Ability to maintain confidentiality of information.
Posting Position Title: Database Warehouse Analyst
Required Skill/ability 3: Advanced proficiency with Excel, and strong knowledge of other Microsoft Office products, such as Word, PowerPoint and Outlook.
Work Week: Standard (M-F equal number of hours per day)
University Job Title: Associate Analyst, Business Intelligence
Required Skill/ability 1: Demonstrated ability with supporting business intelligence efforts through creating effective data visualizations/dashboards, including charts, filters and calculations utilizing Tableau and data warehouse tables.
Required Skill/ability 4: 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.
Required Skill/ability 2: Exceptional reporting and analytical skills, including ability with interpreting data, coding structures and business requirements.
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.
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.