Institutional Policy Analyst II

University of Wisconsin-Madison

. Design, collect, analyze, and research institutional data according to established procedures and regulations .

Posted 10/16/2026full-timeMadison • Wisconsin • United StatesJuniorMid-Level💰 $75,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, reporting, and compliance, with a strong ability to communicate findings effectively to diverse stakeholders. Proficient in SQL, data visualization, and advanced Excel functionalities to support data-informed decision-making.

Highest-signal resume keywords

Data AnalysisSQL Query WritingDashboard DevelopmentMicrosoft Excel ProficiencySponsored Programs Administration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisReportingBusiness Process AnalysisResearch AdministrationSQLData VisualizationDashboard DevelopmentStatistical ReportingData ManagementData Retrieval

Soft Skills

CommunicationConsultationCollaborationProblem-SolvingStakeholder Engagement

Tools & Technologies

TableauPower BIReporting DatabasesInformation SystemsData Management Systems

Industry Keywords

Grants ManagementResearch Financial ManagementComplianceInstitutional ReportingStatistical Analysis

Tech Stack

Tools & technologies

SQLTableau

About the role

Key responsibilities & impact

Design, collect, analyze, and research institutional data according to established procedures and regulations
Prepare and disseminate institutional statistical reports to institutional programs, working units, and leadership
Serve as liaison and primary contact for internal and external stakeholders regarding institutional reporting and compliance, external surveys, institutional statistics, and data
Establish guidelines and procedures to ensure the adequacy, quality, and reliability of information sources
Ensure information systems and databases manage, store, and retrieve institutional data according to established policies, procedures, and reporting regulations
Work on increasingly complex topics and matters with significant impact on institutional operations
Provide analysis and consultation on administrative-related matters
Apply subject matter knowledge to support institutional decisions and policymaking through research, fact-finding, and understanding of applicable business systems
Develop ad hoc and recurring reports, data visualizations, and dashboards
Write and optimize SQL queries and develop database views and stored procedures
Partner with staff and leadership to identify reporting needs, improve access to information, monitor trends, and support data-informed decision-making

Requirements

What you’ll need

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
Experience with SQL, reporting databases, dashboard development, or business intelligence tools such as Tableau and Power BI (preferred)
Advanced proficiency with Microsoft Excel, including formulas, pivot tables, data analysis, and reporting features (preferred)
Experience with sponsored programs administration, grants management, or research financial management (preferred)
Bachelor's Degree is required
Bachelor’s Degree in IT, IT Systems Analysis, Accounting, or Business is strongly preferred
Cover letter and resume required
Must ensure eligibility for employment in the United States on or before the effective date of appointment
University sponsorship is not available
Employment may require a criminal background check
References may be required to answer questions regarding misconduct, including sexual violence and sexual harassment

Benefits

Comp & perks

Generous paid time off
Competitively priced health, dental, vision, and life insurance
Tax-advantaged retirement savings accounts
Participation in the Wisconsin Retirement System (WRS) pension fund