1-3 years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Job Category:
Information Services
Database reporting Analyst
(This job is no longer available)
University of Washington | Seattle, WA
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

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.

Relationship Management

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.

Other duties

Provide consultation and support for data modeling and analytics.

Advise and inform user experience development.

Key Competencies


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.

Functional Expertise

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.

Desired Qualifications

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.

About University of Washington

Founded in 1861, the University of Washington is one of the oldest state-supported institutions of higher education on the Pacific coast. The Seattle-based university has earned an international reputation for research, and its graduate programs are some of the most highly rated in the nation. It is a leader in such fields as drama, dentistry, medicine, nursing, health services, astronomy, computer science, molecular biotechnology, oceanography, biostatistics, physics, physiology, pharmacology, geography, sociology, and social work. The university currently enrolls 35,000 students.