Inst Policy Analyst II (Inst)

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: Kelly Marks, kelly.marks@wisc.edu 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 from every background - people who as students, faculty, and staff serve Wisconsin and the world. The University of Wisconsin-Madison is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence by acknowledging skills and expertise from all backgrounds and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, visit the Human Resources Workplace Poster website . To request a disability or pregnancy-related accommodation for any step in the hiring process (e.g., application, interview, pre-employment testing, etc.), please contact the Divisional Disability Representative (DDR) in the division you are applying to. Please make your request as soon as possible to help the university respond most effectively to you. Employment may require a criminal background check. It may also require your references to answer questions regarding misconduct, including sexual violence and sexual harassment. The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7). The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department .