Inst Policy Analyst II (Inst)

UWMSN University of Wisconsin Madison; Saint Petersburg (FL); On-site; USD 68,000 - 83,000; Full time

Job summary

The University of Wisconsin-Madison's Office of Research and Sponsored Programs (RSP) seeks an Institutional Policy Analyst to lead data and reporting efforts, develop ad hoc and recurring reports, and create dashboards and visualizations to inform policy and operations.

You will design and optimize SQL queries, build database views, partner with stakeholders across units, monitor trends, and support data-driven decisions across the organization through clear, actionable insights.

Qualifications

• 2+ years of professional experience in data analysis, reporting, or related field.
• Ability to analyze complex data and provide actionable recommendations.
• Experience communicating findings to diverse audiences.

Responsibilities

• Designs, collects, analyzes, and researches institutional data according to established procedures.
• Prepares and disseminates institutional statistical reports to leadership and programs.
• Serves as liaison to internal and external stakeholders for reporting and compliance.
• Working on guidelines to ensure data quality and reliability across information systems.
• Provides analysis and consultation to support institutional decisions.

Skills

Data analysis

Reporting

Communication

Education

Bachelor's Degree

Tools

SQL

Tableau

Power BI

Job description

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.

Contact Information

Kelly Marks, [e-mail]

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. Work with purpose, make an impact, and grow your career. The University of Wisconsin–Madison is committed to equity, inclusion and employee well-being as we proudly work to improve the lives of people in Wisconsin and beyond. UW–Madison offers a wide range of professions that cover various interests and skill levels. We employ everything from accountants to arborists, chefs to custodians, editors to electricians, graphic designers to groundskeepers, HR associates to HVAC technicians, librarians to locksmiths, mechanics to medical assistants, painters to police officers, web designers to welders, and absolutely everything in between! No matter what you are looking for professionally, chances are you will not only find it but will thrive at it while working at the University of Wisconsin–Madison.