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 six consecutive years. UW Advancement, Information Management has an outstanding opportunity for a Database Analyst.The Database Analyst is responsible for designing and maintaining complex data structures (e.g. warehouses, cubes, data marts) in a Microsoft SQL Server environment with a strong emphasis on T-SQL development. These data structures drive reporting solutions and provide the necessary infrastructure to support data-driven strategic and tactical decisions for University Advancement. Reporting to the Associate Director for Reporting, the Database Analyst works in collaboration with the Advancement Information Management team, central UW Information Technology partners and personnel across campus to develop accurate and efficient data solutions that support University Advancement initiatives.This position plays a key role in providing information not just to UW Advancement, but to academic and administrative clients across campus. The Database Analyst is responsible for assessing the information needs of every unit, translating business language from varied school and college Advancement units into uniform database solutions, and applying business standards beyond what may be articulated in client specifications in order to ensure accuracy and consistency across platforms. Requests come from stakeholders at all levels, from support staff to the Office of the President.DUTIES AND RESPONSIBLITIESProgrammingDesign, develop, test, and optimize database solutions based on client-specifications.oCreate custom database extracts in SQL Server oCreate custom Tableau Data Extract FilesoMonitor and manage replication of data across multiple assetsStrategy DevelopmentAnalyze 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. In partnership with Reporting and Data Management colleagues, identify new sources of data both internal and external to the UW, and develop processes to facilitate efficient data integration. Continuously evaluate data management processes for improvement and efficiencies.DocumentationDocument 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.Relationship ManagementDevelop 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.Other duties oProvide consultation and support for data modeling and analytics.oAdvise and inform user experience development.oSupport ad-hoc reporting as needed.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.Planning & Implementing: Ability to develop strategies, measures for success and feasible timelines for successful project implementation and execution.Managing Conflict: Recognizes and addresses conflicts and disagreements in a safe and respectful environment, manages conflicts collaboratively, and builds consensus with the best interests.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 2 years of progressively responsible 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 creating 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 Server, along with other third-party tools (e.g. Oracle, MS Access, Tableau, Power BI). Ability to troubleshoot and resolve complex database issues.Familiarity with enterprise data warehouse concepts and standards preferred.Familiarity with the C# or other object-oriented programming languages.Familiarity with project management and source control software.Proficiency using PC computers. Demonstrated strong computer skills, including proficiency with the Microsoft Office and Power BI suite.Experience with dashboard visualization design in Tableau or similar business intelligence software.DESIRED QUALIFICATIONSExperience with data modeling and analyticsExperience with taxonomy/ontology structuresExperience with report design visualization and wire framing toolsKnowledge of alumni relations/development/advancement principlesKnowledge of UW Advancement policies and procedures, including use of the development database software ADVANCE Conditions of EmploymentOpen workspace environment which may result in an increased level of noise and visual distracts.Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.BENEFITSAs a UW employee, you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position, click here.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 Workforce 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.