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 five consecutive years. Office of Research Information Services (ORIS), a division of the Office of Research, coordinates, develops, and supports electronic research administration for faculty and staff at the University of Washington. Goals include: Improve service to Principal Investigators (PIs) and research and administrative staff, enhance their ability to obtain funding, reduce their workload, and streamline the processing of their proposals. Provide authorized individuals with convenient access to timely information on the status of proposals and awards. Increase the efficiency of the research community to meet growing workload and compliance demands with limited resources. Maintain the University of Washington's position as a leading public research University.The University of Washington's Office of Research Information Services has an outstanding opportunity for a full time Data Analyst.The Office of Research serves researchers and research organizations within the University of Washington by providing services, information, and tools to improve the ease of securing and maintaining award-based funding for research.Within the Office of Research, the Decision Support Services (DSS) team develops and supports reports, visualizations, and data analysis tools (e.g. reporting cubes) for the UW research community. These tools help the UW research community (1) understand the changing dynamics of research funding and expenditures, (2) measure compliance with government and sponsor policies, and (3) build a picture to help improve operational effectiveness.As the prospective data analyst with the DSS Team, you understand and are sincerely interested in ways to use data for improving organizational transparency and effectiveness. You also understand the challenges and pitfalls associated with data tools and data-driven approaches. Above all, you are a natural evangelist for improving data quality, usability, and availability as a means to support data-driven approaches and improve organizational efficiency and effectiveness.RESPONSIBILITIES:Technical Implementation and MaintenanceDeliver on needs and opportunities by writing or updating code and/or configurations to provide new reports or enhance or fix existing reporting toolsUtilize Business Intelligence reporting tools, specifically Microsoft SQL Server and Reporting Services, Tableau, SSAS Cubes, and Visual Studio, among othersValidate resulting datasets and reports for accuracyProof sourced data to ensure that it meets requirements and quality standardsDesign and implement fixes to address quality or accuracy issuesData AnalysisDevelop knowledge of academic research funding data elements to distinguish and characterize critical elements for use in in integrated data modelAnalyze potential external data sources to understand if and how they should be integrated into our modelRefine requirements, proof solutions and achieve user acceptance through partnership with other analystsContribute to development of data standards, communicating quality and integrity issues when such issues are discoveredPresent complete concise recommendations to management concerning designs and improvements to our data model and analytics productsSupportRespond and troubleshoot customer issues with reports, visualizations, and other data products we supportEffectively facilitate the communication and resolution of day to day and project level issues ensuring partner relationships are maintained and continue to improvePerform end user training on reports, visualizations and other data analysis products we supportSupport and recommend improvements to our authorization model for providing users with appropriate and necessary access privileges to Research domain data elementsRequirements DiscoveryWork with ORIS internal partners and other UW organizations to understand needs and opportunities and to translate these into functional requirementsChampion and contribute to the improvement of standards for appropriate documentation of data and reporting requirements REQUIREMENTS: BA degree in a science, engineering, or other analytic disciplineMinimum 4 years of experience working on data analysis, report development, or other data or database-related projects in an IT settingGood knowledge of SQLExcellent written and oral communication skills, with ability to communicate ideas and results to stakeholdersExperience using Microsoft SQL Server and related tools, including Management Studio, Reporting Services (SSRS), Integration Services (SSIS)Experience designing and implementing data visualizations using Tableau or similar productExperience working on teams that use professional software development processes and tools, including Agile/Scrum process, Source Control systems such as Microsoft VS/TFS, Development, test, and release process using dedicated Dev,Test, Prod environments, Task management tools such as Jira or TFSEquivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.DESIRED:Experience with modern big-data tools such as Hadoop, MongoDB or other NoSQL database platforms, Python or R programming languages and related toolsExperience programming with an object-oriented language like C++, C#, or JavaCONDITIONS OF EMPLOYMENT:This position contributes in a collaborative team work environment. Collaboration among co-workers is supported through a shared space working environment, ad hoc meetings focused on problem-solving, and the use of synchronous and asynchronous communication tools. Occasional non standard work areas or inflexible deadlines may occur.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, 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.