Business Analyst II
Under supervision of the Senior Director, Advancement Services, the Business Analyst II uses the alumni and donor database, correlated systems and reports to support University Relations (UR) and campus-wide staff’s informational and data needs. This person elicits and synthesizes reporting and business process requirements, works with peers within Advancement Services and/or IT to implement practical solutions to identified and prioritized business needs.
The Business Analyst II is responsible for building and maintaining the data reporting and analysis infrastructure, including the creation and/or maintenance of system documentation such as a report catalogue, data dictionary, business processes and business rule repositories, end-user training guides, and report requests. With this as a foundation, they design dashboards and reports, promote tools to support ad-hoc analysis, conduct data mining and auditing, and interpret data to provide insights and business guidance to end users. They are responsible for maintaining existing and new reports/dashboards within the current and future CRM database in University Relations. The Business Analyst II is responsible for reviewing existing reports/dashboards and proposing database changes to ensure data is accurately presented based on standardized programming logic and business rules, policies, and procedures. Additionally, they develop training materials for new and established reports and business process-related database features and may help deliver training to peers and end users. They collaborate with users to deliver reports and key business information in new and innovative ways, using Power BI, SSRS, Salesforce and Tableau.
The Business Analyst II plays a key role in coordinating Advancement Services team projects, including ongoing configuration of the alumni and donor database and maintaining excellent customer relations between UR, IT, and other university departments. They possess a strong skillset: knowledge of agile methodologies, project management in a database and technology environment, requirement gathering, various reporting technologies, and PL/SQL and T-SQL coding experience.
