Salary and benefits are competitive. Salary is commensurate with qualifications and experience.
First consideration will be given to those who apply by November 14, 2017
As a UW employee, you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position, click here.
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 four consecutive years.
University Advancement creates engagement opportunities that foster pride, advocacy and private support for the University of Washington.
Our College of Arts & Sciences has an outstanding opportunity for a Data Reporting Analyst. The Data 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
Design, develop and test complex SQL scripts in a MSSQL environment to deliver accurate outputs for adhoc data requests from the CAS Advancement staff and affiliates.
Troubleshoot, triage and document modifications to current stored procedures and SQL scripts to support Information Management applications.
Evaluate and consult on client criteria for data requests and adhoc report requests.
Produce daily, monthly, yearly and ad hoc reports from the Data Warehouse, Advance (the Alumni-Donor database), an established Access database and future databases as they are implemented.
Develop and implement tools and strategies for data uploads and downloads between external and internal databases with constituent information.
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.
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.
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.
Provide consultation and support for data modeling and analytics.
Advise and inform user experience development.
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 Word, Excel, and PowerPoint for correspondence, special reports, spreadsheets, databases, forms, 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.
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
Experience with dashboard visualization design in Tableau or similar business intelligence software.
Experience with data modeling and analytics.
Experience with taxonomy/ontology structures.
Experience with MS Access.
Experience with report design visualization and wire framing tools.
Experience working on multiple projects with competing priorities.
Knowledge of alumni relations/development/advancement principles.
Conditions of Employment:
Appointment to this position is contingent upon obtaining satisfactory results from a criminal background check
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, Criminal Conviction History, 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 undergra...duate 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.