Data Analyst

Job Description POSITION PURPOSE The Data Analyst position provides a variety of operational reports for the School of Medicine. This role will be tasked with understanding and completing reporting requests based on provided requirements for stakeholders including medical students, faculty leaders (block/thread/theme/clerkship directors, College heads, etc.), Washington, Wyoming, Alaska, Montana and Idaho (WWAMI) regional deans and staff, and Academic Affairs deans and staff. Partners in this work include the Division of Medical Education and Evaluation in the Department of Biomedical Informatics and Medical Education, Dean of Medicine Information Technology, as well as the Educational Quality Improvement unit in Academic Affairs. POSITION COMPLEXITIES This position requires a functional understanding of best practices in data querying, documentation, and security is required to ensure quality and security of reports. Ability to effectively communicate among with direct leadership, other team members, partner departments, and UW School of Medicine staff and students. POSITION IMPACT TO UNIVERSITY The Date Analyst directly contributes to the ability of medical students, faculty, and administrators to apply educational data to the improvement of student and institutional outcomes. The data analyst meets operations needs for improved integration and presentation of educational data. DUTIES AND RESPONSIBILITIES Reporting request and data services (60%) Work under the direction of Data Services and Medical Education leadership to develop reporting outputs and visualizations that support organizational goals and objectives. Utilize SQL and data visualization tools (e.g. Power BI, Excel, SSRS Report Builder) to produce accurate and timely reports. Respond to ongoing ad hoc reporting requests, including summary documentation on sources used and definitions applied to included fields. Strategically own and manage smaller reporting projects from beginning to end in consultation with internal and external customers. Work closely with Data Services team to understand information needs and objectives, provide solutions, and suggest alternatives for the provision of useful and actionable data in a resource-efficient manner. Data services unit support (20%) Track, assign and escalate support tickets to the appropriate team member. Track data issues in auditing tools, resolve or escalate to appropriate team member. Perform other duties as assigned or requested. Data quality testing and cleaning (20%) Review data sets for accuracy, completeness, uniqueness, and quality. Transform source data into relational format for load into Academic Affairs Data Mart. Integrate data sets from multiple sources into single data table for analysis by Medical Education or other affiliated units. Test data for discrepancies between Development and Test Environments. MINIMUM REQUIREMENTS Bachelor's degree in any field. Minimum 3 years of accumulated professional experience as a business analyst, reporting analyst, or other data analysis-related role. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration. Additional Requirements. Proficiency in SQL, Microsoft Power BI, and Excel Experience with data querying, extraction, and cleaning to support reporting, analysis, and ad hoc requests. Experience in the development of streamlined or automated reporting solutions. Knowledge of data structures and ability to efficiently manipulate/query data. Excellent listening and interpersonal skills; ability to communicate ideas in both technical and user-friendly language. Highly self-motivated and self-directed, with an ability to bring enthusiasm and energy to a collaborative team environment. Demonstrated experience working under pressure with frequent changes to reporting output and priorities in response to changes in reporting needs. DESIRED QUALIFICATIONS Bachelor's degree in the social sciences, math, statistics, or other information technology related field. Experience with higher education data Project Management experience or abilities Experience working in higher education administration WORK ENVIRONMENT The position may require the employee to work beyond a normal work week (e.g. more than 40 hours a week) and intermittently requires evening and weekend time to host medical student events, participate in medical student programs, meet project deadlines, and/or attend meetings. Compensation, Benefits and Position Details Pay Range Minimum: $70,308.00 annual Pay Range Maximum: $81,948.00 annual Other Compensation: - Benefits: For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/ Shift: First Shift (United States of America) Temporary or Regular? This is a regular position FTE (Full-Time Equivalent): 100.00% Union/Bargaining Unit: Not Applicable About the UW Working at the University of Washington provides a unique opportunity to change lives on our campuses, in our state and around the world. UW employees bring their boundless energy, creative problem-solving skills and dedication to building stronger minds and a healthier world. In return, they enjoy outstanding benefits, opportunities for professional growth and the chance to work in an environment known for its diversity, intellectual excitement, artistic pursuits and natural beauty. Our Commitment The University of Washington is committed to fostering an inclusive, respectful and welcoming community for all. As an equal opportunity employer, the University considers applicants for employment without regard to race, color, creed, religion, national origin, citizenship, sex, pregnancy, age, marital status, sexual orientation, gender identity or expression, genetic information, disability, or veteran status consistent with UW Executive Order No. 81. To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 or dso@uw.edu. Applicants considered for this position will be required to disclose if they are the subject of any substantiated findings or current investigations related to sexual misconduct at their current employment and past employment. Disclosure is required under Washington state law. Use the filters or enter keywords in the search box (such as custodian, nursing or manager) to explore available opportunities. To find temporary opportunities, enter temporary in the search box. If you are a current UW employee: You must log into Workday and apply internally through the UW Jobs Hub. Looking for faculty, librarian or academic staff positions? Please visit our Academic Jobs site. Looking for student employment? Learn more on our Student Employment site. There are many perks to working for the University of Washington. Learn more about the benefits that could be available to you as a UW employee. Sign up for Job Alerts to be notified about job opportunities at the UW that interest you; youll be one of the first to learn when openings become available. You will be asked to create an account if you do not already have one.