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.
Key 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 policymaking through research and fact-finding combined with an understanding of applicable business systems (10%)
Department: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.
How to Apply:To apply for this position, please click on the "I am a current employee" button or "I am not a current employee" button under Apply Now.
You will be prompted to upload the following documents (required):
• Cover Letter
• Resume
Please note, there is only one attachment field, and you are able to upload multiple documents in the attachment field.
Cover letters will be used as a writing sample and to determine the best-qualified applicants. Your cover letter should address your education and/or qualifications as they pertain to this position, in particular your experience with data reporting, analytics, business process analysis, research administration, sponsored programs administration, or related activities.
A successful applicant will be responsible for ensuring eligibility for employment in the United States on or before the effective date of the appointment. University sponsorship is not available for this position.
Contact Information: 
