Inst Policy Analyst II (Inst)

Universities of Wisconsin•Madison, WI

1d•$75,000

About The Position

The University of Wisconsin-Madison's Office of Research and Sponsored Programs (RSP) administers extramural research grants and contracts, managing an open portfolio of over $4 billion and annual awards exceeding $1 billion. The Institutional Policy Analyst serves as RSP's lead data and reporting analyst, maintaining expert knowledge of research administration data, reporting tools, and database structures. The position delivers accurate, timely, actionable information to stakeholders across the organization. The analyst develops ad hoc and recurring reports, data visualizations, and dashboards; writes and optimizes SQL queries; develops database views and stored procedures; performs data analysis; and provides technical guidance on effective use of institutional data. The position partners with staff and leadership to identify reporting needs, improve access to information, monitor trends, and support data-informed decision-making. It works on increasingly complex topics with significant operational impact and provides analysis and consultation supporting institutional decisions and policymaking. The role is in the Electronic Research Administration (eRA) team within the Office of Vice Chancellor for Research (OVCR), Research and Sponsored Programs (RSP). The minimum salary is $75,000 and is negotiable based on experience and qualifications. A bachelor's degree is required. The position includes a comprehensive benefits package.

Requirements

At least 2 years of professional experience in data analysis, reporting, business process analysis, research administration, sponsored programs administration, or a related field.
Demonstrated ability to analyze complex data or business processes and make recommendations.
Experience communicating findings and recommendations to diverse audiences.
Bachelor's degree required.

Nice To Haves

Experience with SQL, reporting databases, dashboard development, or business intelligence tools such as Tableau or Power BI.
Advanced proficiency with Microsoft Excel, including formulas, pivot tables, data analysis, and reporting features.
Experience with sponsored programs administration, grants management, or research financial management.
Bachelor's degree in IT, IT Systems Analysis, Accounting, or Business is strongly preferred.

Responsibilities

Design, collect, analyze, and research institutional data according to established procedures and regulations.
Prepare and disseminate institutional statistical reports to institutional programs, working units, and leadership.
Serve as liaison and primary contact to internal and external stakeholders for institutional reporting and compliance, external surveys, institutional statistics, and data.
Participate in establishing guidelines and procedures to ensure the adequacy, quality, and reliability of information sources, and ensure information systems and databases manage, store, and retrieve institutional data according to established policies, procedures, and reporting regulations.
Work on increasingly complex topics and matters with significant impact to institutional operations.
Provide analysis and consultation on administrative matters, applying subject matter knowledge to support institutional decisions and policymaking through research, fact-finding, and understanding of applicable business systems.
Develop ad hoc and recurring reports, data visualizations, and dashboards; write and optimize SQL queries; develop database views and stored procedures; and provide technical guidance on institutional data use.
Partner with staff and leadership to identify reporting needs, improve information access, monitor trends, and support data-informed decision-making.