Inst Policy Analyst II (Inst)

University of Wisconsin; Madison (WI); On-site; USD 68,000 - 83,000; Full time

Job summary

The University of Wisconsin-Madison's Office of Research and Sponsored Programs (RSP) is seeking an Institutional Policy Analyst II to serve as lead data and reporting analyst, delivering timely information to stakeholders and supporting data-informed decision-making.

Responsibilities include developing ad hoc and recurring reports, creating dashboards, writing SQL queries, and guiding users on institutional data.

Qualifications

• 2+ years of professional experience in data analysis, reporting, business process analysis, research administration, or related field
• Ability to analyze complex data and make recommendations
• Experience communicating findings to diverse audiences

Responsibilities

• Designs, collects, analyzes institutional data according to established procedures and regulations
• Prepares and disseminates institutional statistical reports to programs, units, and leadership
• Liaises with internal and external stakeholders for reporting, surveys, and data
• Establishes guidelines to ensure data quality and reliability of information systems and databases
• Works on complex topics with significant impact to institutional operations
• Provides analysis to support decisions and policymaking through research and data access guidance

Skills

Data analysis

Reporting

Communication

Problem solving

SQL

Tableau/Power BI

Education

Bachelor's Degree

IT / IT Systems Analysis / Accounting / Business

Tools

Tableau

Power BI

SQL Server

Job description

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.

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 OpportunityEmployer.

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 backgroundsand 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.