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.
UW Continuum College (UWC²) expands the reach of the University of Washington with programs like UW Professional & Continuing Education, International & English Language Programs, Summer Youth and the Osher Lifelong Learning Institute at the UW that meet the needs of various learners at all phases of their lives. We’re focused on removing obstacles to relevant educational opportunities by addressing geographic, financial, length of commitment and time constraints, increasing access to knowledge for more people. As a diverse community that values inclusivity and collaboration, we foster a respectful, supportive workplace where innovation comes to life. By looking ahead and experimenting with new approaches, we’re creating new educational opportunities to help people thrive in a world of change.
Diversity and respect for all, is a core value of UW Continuum College. We are committed to improving access to education, removing barriers to entry, and viewing our work through an equity lens. We believe our organization is better when diversity of thought, practice, and experiences are not only welcomed but celebrated. We are passionate about creating, and supporting an inclusive working and learning environment for all students, staff, and faculty.
UW Continuum College is excited to announce a job opening for a Program Operations Analyst position. This is a full-time professional staff position.
The UW Continuum College Reporting Services unit is the Continuum College’s only centralized reporting functionality. It provides student and faculty data and decision support for the University effort to develop professional training and learning programs such as professional degree programs, UW Summer Session, certificate programs, UW Online Learning, UW International & English Language Program, and standalone UW classes serving 55,000 students in a single year.
JOB SUMMARY The Program Operations Analyst fulfills central student data reporting requests, directly from the UWC² Vice Provost Office, Executive Council leadership, and campus administrators, concerning fee-based program activities where automated reporting systems are not available to address these requests. This position also supports reporting needs from Washington state as well as federally mandated student reporting needs.
Gathering accurate, reliable and complete student data of fee-based activities are complex and challenging, due to the lack of reporting tools in existing information management systems. This position will continue fulfilling the gap.
This job role supports both recurring/standard and ad hoc/non-standard complex requests for student academic data and business data requests. The requested information is not typically available from either automated reporting systems or other in-house staff. Those reports are produced using the highest reporting standards and methods as well as most up-to-date business rules known to UW reporting community.
Respond to student-related data requests from Marketing, Market Research, Academic Programs, Vice Provost Office, campus partners, Campus OPB office, the Graduate School, the Provost Office, and the general public
Work with director of reporting services to gather critical business intelligence needs for Marketing leadership, Partner Success Leads, AP non-credit directors, Finance, and other units. Most business needs are related to student academic information unavailable through existing university reporting tools. The program operations analyst will work with director of research and Reporting Services to connect Tableau reporting tool with Enterprise Tableau Server and enterprise data warehouse to schedule and publish recurring reports. Provide business intelligence analytics and reporting services tools to end users, address follow-up data inquires, liaison and coordinate meetings between internal groups and business managers to mitigate risks due to lack of decision-support information, and improve efficiency
Collaborate with the UW Office of Institutional Research, Public Records and Open Meetings offices to respond to external general public information requests. Ensure data are accurate and consistent for University-wide reporting standards. Provide information for standard, published reports when available.
Provide support and expertise consulting for other units creation, development, modification and testing of reporting across UWC². Provide support for EO user datamart application training as needed. Serve as in-house expert to respond to ALL external requests involving fee-based or self-sustaining academic student data records, and perform longitudinal trend analysis when applicable. Be the go to person at UWC² to liaison data extrapolation needs from other units and coordinate training needs, identify resources to respond to data questions, identify timely solutions for data challenges that affect reporting integrity
Work with director of reporting services to develop data visualization and business intelligence tool for end users to consume. Meet with end users for feedback, plays liaison role to coordinate update to internal reporting tool and manage technical updates to key data warehouse and BI tool modules
Maintain self-sustaining program reporting external database updates to support reporting needs. Work with the UW Registrar's Office, EDW team, OPB, EOS developers, UWC² business managers and other end users to incorporate known business rules and processes into reporting, gather and document reporting requirements and query steps before data extrapolation and reporting. Meet with key stakeholders and users of student data within UWC² and external partner data team to keep track of program code changes, updates, upgrades, to ensure data integrity and accuracy
Work with Research & Reporting Services Director to develop and implement data validation or QA procedures, and develop data models that best meet the decision support needs. Develop and maintain reporting procedures for planning, data analysis and modeling, and data element standardization to ensure accurate, timely and readily accessible reports and information.
Bachelor’s degree in data science, information management, mathematics, business, psychology, sociology or other related background. Job related working experience may substitute educational requirements with exceptional qualifications otherwise.
2 years of experience to include an understanding of University of Washington data systems, institutional reporting, business analysis, or statistical research experience.
Working knowledge of University of Washington Enterprise Data Warehouse (EDW), including financial, budget, student, and human resources data sources;
Expert knowledge of MS SQL, data structures and stored procedures including triggers, DDL (Data Definition Language), and DML (Data Manipulation Language). Expert knowledge of MS Access and database design;
Database Administrator skills with Microsoft SQL Servers preferred;
Demonstrated ability to research and query multiple data sources to address business questions and develop solutions, e.g., gather meaningful information across SDBDatastore, EOS and ODS;
Working knowledge of unit and enterprise computer information system design and user application;
Ability to communicate technical requirements to non-technical business users to define and formulate precise data questions for business use;
Ability to communicate with a diverse group of colleagues with technical and non-technical backgrounds;
Demonstrated ability to document recurring and new query procedures.
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.