Inst Policy Analyst II; Inst
Listed on 2026-10-19
-
Business
Data Analyst, Business Intelligence -
IT/Tech
Data Analyst, Business Intelligence
Current Employees:
If you are currently employed at any of the Universities of Wisconsin, log in to Workday to apply through the internal application process.
Job Category:
Academic Staff
Employment Type:Regular
Job Profile:Institutional Policy Analyst II (Inst)
Job Summary:The University of Wisconsin-Madison's Office of Research and Sponsored Programs (RSP) is responsible for administration of the extramural research grants and contracts. RSP currently manages an open portfolio of over $4 Billion with annual awards over $1 Billion.
The Institutional Policy Analyst (Inst) position serves as the lead data and reporting analyst for the RSP. The role maintains expert knowledge of research administration data, reporting tools, and database structures and is responsible for delivering accurate, timely, and actionable information to stakeholders throughout the organization. Core responsibilities include developing ad hoc and recurring reports, creating data visualizations and dashboards, writing and optimizing SQL queries, developing database views and stored procedures, conducting data analysis, and providing technical guidance on the 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.
Job Responsibilities:
- Designs, collects, analyzes, and researches institutional data according to established procedures and regulations (25%)
- Prepares and disseminates institutional statistical reports to institutional programs, working units, and leadership (20%)
- Serves as liaison and primary contact to internal and external stakeholders for institutional reporting and compliance, external surveys, and institutional statistics and data (5%)
- Participates in establishing guidelines and procedures to ensure adequacy, quality, and reliability of information sources to ensure information systems and databases manage, store, and retrieve institutional data according to established policies, procedures, and reporting regulations (25%)
- Works on topics that are increasingly complex and on matters that have significant impact to institutional operations (15%)
- Provides analysis and consultation on a variety of administrative-related matters. Applies subject matter knowledge to support institutional decisions and policy making through research and fact-finding combined with an understanding of applicable business systems (10%)
Office of Vice Chancellor for Research (OVCR), Research and Sponsored Programs (RSP), Electronic Research Administration (eRA) team
Compensation:The minimum salary for this position is $75,000 but is negotiable based on experience and qualifications.
This position will receive a comprehensive benefits package, including generous paid time off, competitively priced health/dental/vision/life insurance, tax-advantaged retirement savings accounts, and participation in the Wisconsin Retirement System (WRS) pension fund.
Required Qualifications:- 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
Preferred Qualifications:-Experience with SQL, reporting databases, dashboard development, or business intelligence tools (Tableau, Power BI, etc.)
-Advanced proficiency with Microsoft Excel, including the use of formulas, pivot tables, data analysis, and reporting features
-Experience with sponsored programs administration, grants management, or research financial management
Education:Bachelor's Degree is required.
Bachelor's Degree in one of the following areas: IT, IT Systems Analysis, Accounting, or Business is strongly preferred.
Contact Information:Kelly Marks, kelly.marks
Institutional Statement on Diversity:Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.
The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).