Inst Policy Analyst II (Inst)

University of Wisconsin Madison•Madison, WI

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 and providing accurate, timely, actionable information to stakeholders throughout the organization. The role develops ad hoc and recurring reports, data visualizations and dashboards; writes and optimizes SQL queries; develops database views and stored procedures; conducts data analysis; and provides technical guidance on effective use of institutional data. The analyst partners with staff and leadership to identify reporting needs, improve access to information, monitor trends, and support data-informed decision-making. The position also supports institutional reporting, compliance, and policymaking through research, analysis, and consultation.

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.

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.

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, and institutional statistics and data.
Participate in establishing guidelines and procedures to ensure the adequacy, quality, and reliability of information sources, and that 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 on institutional operations.
Provide analysis and consultation on administrative matters, applying subject matter knowledge to support institutional decisions and policymaking through research and fact-finding combined with an understanding of applicable business systems.
Develop ad hoc and recurring reports, data visualizations, and dashboards; write and optimize SQL queries; and develop database views and stored procedures.
Partner with staff and leadership to identify reporting needs, improve access to information, monitor trends, and support data-informed decision-making.