DATABASE ANALYST
Req #: | 173647 |
Department: | UW ADVANCEMENT, INFORMATION MANAGEMENT |
Job Location: | Seattle Campus |
Posting Date: | 10/28/2019 |
Closing Info: | Open Until Filled |
Salary: | Salary is commensurate with experience and education |
Shift: | First Shift |
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 RESPONSIBLITIES
Programming
Design, develop, test, and optimize database solutions based on client-specifications.
o Create custom database extracts in SQL Server
o Create custom Tableau Data Extract Files
o Monitor and manage replication of data across multiple assets
Strategy Development
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. 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.
Documentation
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.
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.
Other duties
o Provide consultation and support for data modeling and analytics.
o Advise and inform user experience development.
o Support ad-hoc reporting as needed.
Key Competencies
Core
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
Organizational 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.
REQUIREMENTS
Bachelor'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 QUALIFICATIONS
Experience with data modeling and analytics
Experience with taxonomy/ontology structures
Experience with report design visualization and wire framing tools
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
Open 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.
BENEFITS
As 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
Committed to attracting and retaining a diverse staff, the University of Washington will honor your experiences, perspectives and unique identity. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable and welcoming.
The University of Washington is a leader in environmental stewardship & sustainability, and committed to becoming climate neutral.
The University of Washington is an equal opportunity, affirmative action employer. To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 / 206-543-6452 (tty) or dso@uw.edu.