Salary and benefits are competitive. Salary is commensurate with qualifications and experience.
As a UW employee, you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position please visit our website Benefits page.
Please note that this position has been re-posted. If you have already submitted your application, you need not submit it again, as it has already been received.
The University of Washington (UW) is proud to be one of the nation's premier educational and research institutions. Our people are the most important asset in our pursuit of achieving excellence in education, research, and community service. Our staff not only enjoys outstanding benefits and professional growth opportunities, but also an environment noted for diversity, community involvement, intellectual excitement, artistic pursuits, and natural beauty.
University Advancement is committed to creating an environment of inclusiveness where every person feels welcomed and valued. We believe that attracting and retaining diverse staff is crucial to serving the communities where our employees and students work and live.
University Advancement has an outstanding opportunity for a Database Reporting Analyst.
University Advancement creates engagement opportunities that foster pride, advocacy and private support for the University of Washington. The Advancement Information Management department provides the technical infrastructure that supports this mission. The Database Reporting Analyst develops custom and ad hoc database reporting solutions. This position receives, evaluates, and prioritizes report and list segmentation requests from a wide variety of internal clients, but also distributes and tracks work for other Reporting Team colleagues as appropriate.
Duties and Responsibilities
Design, develop and test complex SQL scripts in a MSSQL environment to deliver accurate outputs for adhoc data requests from the UW Advancement staff and affiliates.
Evaluate and consult on client criteria for data requests and adhoc report requests
Troubleshoot, triage and document modifications to current stored procedures and SQL scripts to support Information Management applications.
Develop client relationships across campus. Educate users on reporting tools and data usage best practices. Advise clients on reporting 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) 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.
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.
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 report design visualization and wire framing tools
Experience working on multiple projects with competing priorities
Knowledge of alumni relations/development/advancement principles
Knowledge of alumni relations/development/advancement principles.
Knowledge of UW Advancement policies and procedures, including use of the development database software ADVANCE.
Conditions of Employment
Cubicle/Open workspace environment which may result in additional or higher levels of noise and visual distractions.
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.