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.
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 Office of Research Information Services (ORIS) has an outstanding entry opportunity for a data analyst. The data analyst will work as a member of our decision support services (DSS) team to further our ongoing initiatives of streamlining and enhancing operational reporting, advanced analysis of research enterprise data to reduce administrative burden on researchers, enabling Business Intelligence (BI) and data-driven decision making for the research community and the UW as a whole. Additionally, the data analyst will provide partner support for operational and ad-hoc efforts, as well as internal partnering with other ORIS teams on strategic projects and system maintenance. Tasks will emphasize data needs assessment, manipulation of quantitative data, report standardization, compilation of meta-data, advanced analytics, and process definition.
Under general direction of the Assistant Director, the data analyst will support units within the Office of Research, data consumers in Dean’s offices and other central administrative units. The data analyst will be expected to be able to synthesize diverse and sometimes competing stakeholder needs in ambiguous environments to provide a quality product. The person in this position must understand organizational business objectives and processes and then conceptualize, document, collaborate on, implement, and communicate the design of solutions for advanced analytical and operational activities.
The data analyst will assess current policies and practices, develop and analyze queries and reports, provide analytical services, and work with interdepartmental and inter-school teams to advance key initiatives and further future data and analytical needs for the University in support of the $1.3B research enterprise. The person in this position will collaborate with the DSS team and external subject matter experts to support the ongoing initiative to create a consolidated view of Research Administration data and make it available to the UW community in the Enterprise Data Warehouse Solution.
Streamline and enhance accountability reporting:
- Develop, maintain, and promote data quality standards
- Isolate data quality and integrity issues. Communicate and contribute to the development of a resolution path in line with standards
- Develop knowledge of academic research data elements to distinguish and characterize critical elements for publication in the Enterprise Data Warehouse
- Understand business needs, ensuring their inclusion into detailed action plans and master project plans
- Evaluate business requirements to model data and/or system requirements
- Anticipate future needs of historical data in-line with current reporting needs
- Proof and validate data and reports for accuracy and quality
- Understand and apply statutory reporting requirements from the federal and state government
Enable Business Intelligence:
- Utilize BI reporting tools, specifically Microsoft SQL Server Reporting and Analysis Services, Tableau, Visual Studio, and PowerBI, among others
- Using Microsoft SQL Reporting Services, design appropriate output solutions based on project requirements
- Work with other Business and Data Analysts to refine requirements, proof solutions, and achieve user acceptance
- Tune application and query performance
- Implement and assist in the development of data-driven business testing strategies
- Work to develop, implement, and uphold change management processes related to daily operations and project work
- Ensure translation of data into consistent, maintainable formats in preparation for the ETL process
- Effectively facilitate the communication and resolution of day to day and project level issues ensuring partner relationships are maintained
- Assist in resolving business issues by analyzing data sets in order to illuminate meaningful relationships
- Respond to data inquiries from various groups within the University, which may include ad hoc statistical and data mining analyses.
- Assist in the management of local user access to multiple data resources throughout the University
- Perform end user training on reports and our reporting environments
- Ensure stable, repeatable operational environment from daily ops to prod migration testing and acceptance
Communication, collaboration, and documentation:
- Bring transparency to day to day activities and project work.
- Present complete and concise recommendations to management when resolving difficult issues
- Work effectively in a consensus driven, collaborative, team environment
- Work with other analysts to develop and provide efficient data solutions, in line with project goals
- Collaborate on designing new analytical reporting, products and features for our clients that enable data-driven decision making
- Apply varied requirements gathering methods to ensure complete requirements elicitation
- Establish and implement standards for appropriate documentation of data and reporting requirements in line with project standards
- Document existing data sources and uses of data
- Document and maintain procedures and processes with intention of supporting a defined, repeatable daily reporting operation
- Facilitate a high standard of documentation that will ensure a successful representation of data knowledge over time
Advanced analysis of research enterprise data:
- Assist and/or lead data analysis initiatives to evaluate data integrity, identify data gaps, and prototype data and analytical solutions.
- Work independently to uncover previously unknown insights in the data
- Research analytical methods and tools
- Source data from disparate data sources in order to assemble complete data solutions
- Bachelor’s degree in quantitative fields such as Statistics, Applied Mathematics, Computer Science, or related field
- Minimum 3 years’ experience
- Strong organizational skills
- Outstanding verbal and written communication skills
- Results driven personality with proven ability to work within a team environment to develop solutions, provide tasks and ensure adherence to project goals and milestones
- Effective analytical, problem solving and research skills
- Proven experience facilitating a working group to gather business requirements and translate into functional requirements
- Ability to research grant-related and higher education policies required, with an emphasis on strong analytical skills
- A flexible analytic approach that allows for results at varying levels of precision
- Demonstrated skill in working independently with databases to generate graphic and tabular reports, including building complex original queries, defining data elements, interpreting results, and documenting standard procedures for report designs
- Curiosity and excitement for empirical research and for answering hard questions with data
- Knowledge of data warehousing concepts
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Knowledge of data design and tools
- Proven ability to learn new applications; proficiency in Microsoft SQL, Reporting Services, Visual Studio, and Visio
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
- Master’s degree in quantitative fields such as Statistics, Applied Mathematics, or Computer Science or a related field
- Experience with development processes like Agile or Lean
- Knowledge of advanced analysis techniques such as machine learning
- Knowledge of a scripting language
- Experience with survey analysis techniques, such as power analysis and determining response bias
- Knowledge of visualization tools such as Tableau
- Knowledge of distributed data storage systems such as Hadoop
Condition of Employment:
Appointment to this position is contingent upon obtaining satisfactory results from a criminal background check.
This position contributes in a collaborative team work environment. Collaboration amongst ORIS teams is supported through a shared space working environment, ad hoc meetings focused on problem-solving, and the use of synchronous and asynchronous communication tools. Inflexible deadlines and non-standard working hours are required at times.
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.