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.
Founded in 1899, the University of Washington School of Law is one of the nation’s top public law schools; it also enjoys strong private support for leading programs in Asian Law, Global Health, Law & Technology, Tax, and Environmental Law. Located in William H. Gates Hall, a new state-of-the-art facility in vibrant Seattle, the School of Law is also home to the Gates Public Service Scholars program and the Barer Institute for Law and Global Human Services.
The University of Washington School of Law is seeking a part time, 50% FTE Data Analyst.
The Data Analyst, reporting to the Director of Finance, is responsible for performing financial analysis and reporting in support of wide-ranging projects and policy initiatives for the School of Law. The Data Analyst performs analysis of the key performance metrics and other drivers of the school and produces data reports and visualization used to make strategic and operational recommendations and decisions. The scope of analysis encompasses financial data, budget information and business processes. This position will also be expected to take on a pivotal role in the implementation of school-wide financial initiatives, including design, communication, and management of various financial systems and methodologies.
Financial Data Management
Utilizing institutional data resources, navigate access to centralized fiscal, grants, space, payroll, employment, research, and student enrollment data resources.
Provide analysis and assessment in support of leadership planning, processes and new initiatives.
Design and build complex queries, data flows, and data visualization, design reports, design charts and graphs, write summaries of results and proactively write and maintain documentation of protocols for data access reporting analysis.
Use the UW Enterprise Data Warehouse (EDW) and its supporting systems (BI Portal, web services, etc.), as well as School of Law’s data sources, to design, create, and continuously manage the School’s Key Performance Indicator (KPI) dashboards.
Clean and normalize data required for all internal and external reporting requirements using new and existing data tools.
Design and create complex SQL queries, data flows and data visualizations.
Presenting findings to senior and executive leadership.
In collaboration with IT team members and School of Law leadership, locate and define new process improvement opportunities.
Assist and provide training to colleagues in developing, maintaining and promoting data quality standards.
Organize and maintain historic reports and analysis.
Dean’s Office Budgeting Infrastructure
Working with the Assistant Dean for Finance and Operations, and the Director of Finance help provide infrastructure to support financial and budgeting goals for the unit and the Schools.
Specific scope to include support for standardized and customizable financial reports, BGT revisions, commitment tracking, self-sustaining budget reviews, distributions of funds, and fee/revenue.
Bachelor’s in business management, accounting, or related field and 2 years’ experience in financial analysis
2+ years of data mining experience
2+ years in data analyst role
Proficiency with SQL for writing efficient queries on large datasets
Ability to work with one or more tools that can access the UW EDW, such as web service APIs, Excel, Access, Tableau, Power BI, etc.
Strong attention to detail
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
Familiarity with SQL Server Management Studio and/or Microsoft Visual Studio
Proficiency in a scripting language such as Microsoft PowerShell
Ability to troubleshoot data connectivity issues
CONDITIONS OF EMPLOYMENT:
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.