University Advancement creates engagement opportunities that foster pride, advocacy and private support for the University of Washington. The Data and Reporting Analyst is the data analyst for College of Arts & Sciences (CAS) Advancement Team and is responsible for the development, management and execution of data practices, reports and systems designed to support CAS Advancement in particular. Working closely with the Director of Advancement Services (CAS), the Data and Reporting Analyst designs and implements data management systems and produces reports to support the business needs of CAS Advancement. Seeking to establish and pursue best practices in data analysis, management and reporting, the Data and Reporting Analyst is considered the expert for all data points relative to College of Arts & Sciences fundraising.
Duties and Responsibilities
REPORTING MANAGEMENT, ANALYSIS AND PROGRAMMING – 60%
Evaluate, consult and execute on client criteria for data requests, ad hoc report requests, data modeling and analytics.
Produce daily, monthly, years and ad hoc reports from the Data Warehouse, Advance (the Alumni-Donor database), and established Access database and future databases as they are implemented.
Advise, inform and design processes and reports towards optimal user experience.
Design, develop and test complex SQL scripts in a MSSQL environment to deliver accurate outputs for ad hoc data requests from the CAS Advancement staff and affiliates.
Troubleshoot, triage and document modifications to current stored procedures and SQL scripts to support internal applications.
Develop and implement tools and strategies for data uploads and downloads between external and internal databases with constituent information.
Ensure CAS data are in compliance with requirements governing privacy, information security, annual and campaign reporting, and other related issues; regularly update and audit CAS data.
RELATIONSHIP MANAGEMENT – 30%
Develop client relationships with CAS Advancement and Central Advancement.
Educate users on reporting tools and data usage best practices.
Advise clients on reporting and data management standards.
Consult with stakeholders to help define functional requirements for major information initiatives.
Analyze and identify opportunities to expand and improve data processes in support of long-range automated and self-service information needs. Identify opportunities to integrate existing suite of tools (Tableau, online self-service reporting, Michelangelo, ADVANCE, Data Warehouse, Access) to better meet information needs.
DOCUMENTATION – 5%
Document database and extract schema, field definitions, and data mappings across systems.
Maintain comprehensive data asset inventory, including source and provenance metadata, security and access restrictions, and maintenance and retention requirements.
OTHER DUTIES – 5%
Effective communications: Expresses oneself clearly and empathetically in interactions with others in all forms of communication, i.e., verbal and written, one-on-one and group, etc.
Interpersonal Awareness: Builds and maintains positive relationships and actively contributes as a member of working teams to achieve results.
Professional Credibility: Takes responsibility for meeting goals, objectives, obligations, and solving problems while representing the mission, vision and values of the organization.
Critical Thinking: Obtains, analyzes and evaluates information effectively in the face of ambiguity. Makes appropriate decisions based on relevant information and experience.
Ethics and Trust: Models and upholds the values of candor, openness, inclusiveness and honesty despite internal and external pressures. Acts consistently with Washington State ethical guidelines and organizational core values and beliefs.
Valuing Diversity & Inclusiveness: Respects, values and contributes to the UW’s commitment to inclusiveness and diversity.
Innovation Management: Able to anticipate market trends and be effective in facilitating and managing creative processes to achieve results in self and others.
Organizational Agility: Knowledgeable of the organization, able to balance reason and the interest of various parties, and act in an appropriate manner that is congruent with the organization’s values, goals and mission to achieve success.
Technical Agility: Ability to quickly learn and apply new technologies, skills and concepts into existing systems and protocols while continuously seeking improvements.
Bachelor’s degree and two years’ of experience in a database reporting environment or related field. Equivalent combination of education and experience from which comparable knowledge and skills have been acquired may substitute for degree.
Strong general RDBMS experience, Advanced SQL Server skills should include: Designing, developing, testing, and supporting mid-to-large scale databases. Expertise in maintaining all key database objects: Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL. In-depth knowledge of development, testing, and optimization of T-SQL code with tools included in SQL
Demonstrated strong computer skills, including proficiency with Microsoft Access, Word, Excel, and PowerPoint for special reports, spreadsheets, databases, forms, procedure manuals, special correspondence, etc.
Demonstrated creativity, organizational ability, and strong attention to detail. Ability to make decisions in ambiguous situations, exercise good judgment based on information and analysis in a fast pace, dynamic, deadline drive environment in an organized and professional manner.
Experience with MS Access.
Experience with dashboard visualization design (Tableau or similar BI software).
Experience with data modeling and analytics.
Experience with taxonomy/ontology structures.
Experience with report design visualization and wire framing tools.
Experience working on multiple projects with competing priorities.
Knowledge of alumni relations/development/advancement principles.