As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem solving skills and dedication to build stronger minds and a healthier world. UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty. All of which has allowed the UW to be nationally recognized as a "Great College to Work For" for five consecutive years.UW Advancement has an outstanding opportunity for a Data Analyst (9 month Project Appointment).The Data Analyst is responsible for supporting efforts to represent and structure constituent data available to users in order to ensure that it is actionable, accurate, comprehensive, and up-to-date. Virtually every facet of UW Advancement operations depends on access to quality data. It allows each business group to be more effective, return a higher success rate, more precisely target messaging, and develop more accurate models. It drives quality decision-making processes at all levels and is a requirement for continued success of the institution. A lack of quality data will leave units blind--making decisions based on partial data and struggling to effect change.The key to the success of this position is understanding the nuance of data flowing among the various Advancement database systems including the CRM software and other UW systems as well as the management of complex metadata schemas.The Data Analyst works with the Prospect Development (PD) and Donor Relations (DR) teams and partners closely with the Information Management (IM) team to:- Understand and support the data structures used for Donor Relations (e.g. endowments and endowment donor data) and Prospect Development (e.g. major gift prospect and fundraiser data).- Query data and create extracts involving PD and DR data sources.- Organize and structure data sets on a SQL server related to data extracted from multiple sources.- Produce visualizations and reports based on PD and DR data.- Support data governance policies and practices for DR and PD within the guidelines established by Advancement's Data Governance team.- Support data structure policies and practices within the guidelines established by Advancement's Reporting Services team.- Promote a common understanding of data elements and definitions.- Facilitate the clear definitions within the data sets and document.- Plan and execute efforts for best use of data inside and outside of our CRM.DUTIES AND RESPONSIBILITIESModernize Data and Reporting ToolsUpdate legacy tools used for auditing and analysis by the PD and DR teams.Create reports to make prospect and stewardship data actionable to internal clients.Organize and structure data from a variety of sources, developing process automation wherever possible.Ensure coherent and reliable data standards, isolate and eliminate data inconsistencies, and monitor the quality and accuracy of data.Develop data standards that best support predictive modeling and other standardized reporting needs.Prepare Data for CRM ConversionComplete projects pertaining to UW Advancement's upcoming CRM transition from Ellucian Advance to an alternative software platform (e.g., Microsoft Dynamics 365), with particular focus on data management, including:Create and update SQL extracts.Evaluate data processes for improvement and efficiencies.Assist in documenting and mapping data for conversion.Analyze business needs and processes to develop and support best practices in data management.Relationship ManagementAct as liaison to IM from DR and PD, tracking progress of projects and leveraging support from IM where appropriate.Advise DR and PD on data collection methodology and ETL (extract/transform/load) best practices.Develop or advise on the development and implementation of data collection and input into CRM and other Advancement data stores.Other duties as assigned.KEY COMPETENCIESCoreEffective 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.Functional ExpertiseOrganizational Acumen: Able to size up a situation, balance reason and the interest of others, and act in a decisive, timely and appropriate manner that is congruent with the organization's values, goals and mission to achieve success.Innovation Management: Able to anticipate market trends and be effective in facilitating and managing creative processes to achieve results in self and others.Technical Agility: Ability to quickly learn and apply new technologies, skills, and concepts into existing systems and protocols while continuously seeking improvements.REQUIREMENTSBachelor's degree and two years of experience in data management and analysis, taxonomy/ontology, or related field.Strong proficiency in Microsoft SQL Server (MSSQL), development of scripted solutions, and stored procedures.Proficiency with data visualization software.Proficiency using PC computers. Demonstrated strong computer skills, including proficiency with Microsoft Word, Excel, and PowerPoint for correspondence, special reports, spreadsheets, databases, forms, etc.Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.DESIRED QUALIFICATIONSKnowledge of nonprofit fundraising practices.Knowledge of UW Advancement policies and procedures, including use of the alumni/donor CRM database software, Ellucian Advance.Proficiency in Tableau.Familiarity with troubleshooting Access databases.CONDITIONS OF EMPLOYMENTCubicle/Open workspace environment which may result in additional or higher levels of noise and visual distractions.Application Process:The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select "Apply to this position". Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your "My Jobs" page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.