Data Analyst

UWMSN University of Wisconsin Madison; United States; Hybrid; USD 80,000 - 95,000; Full time

Job summary

University of Wisconsin–Madison is seeking a Data Analyst (Institutional Policy Analyst II/III) to support reporting across OVCR, with a focus on HERD surveys and research activity data. You will coordinate data collection, ensure quality, create regular and ad hoc reports, and support cross-unit collaboration on campus-wide research administration data.

The role requires 3+ years of relevant experience and a Bachelor's degree; a Master's is preferred.

Qualifications

• 3+ years of professional experience in research, analytics, or administration.
• Bachelor's degree required; Master's degree preferred.
• Experience in data management, data visualization, and reporting is expected.

Responsibilities

• Prepares and disseminates institutional statistical reports to leadership.
• Designs, collects, analyzes, and researches institutional data per procedures.
• Coordinate data collection and ensure data quality and timely reporting.
• Provide analysis and consultation on administrative matters and policymaking.
• Collaborate with campus units on enterprise data and reporting.

Skills

Strong analytical skills

Data management

Data visualization

Query writing (SQL)

Communication to diverse audiences

Education

Bachelor's degree

Master's degree preferred

Tools

Excel

Tableau

Workday

Denodo

Job description

Job Facts

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)

Department

Department: Office of the Vice Chancellor for Research, Business ServicesThe Office of the Vice Chancellor for Research (OVCR) serves as the central coordinating unit for UW-Madison's research enterprise, which spans all schools, colleges, centers, and institutes and supports over $1.9 billion in annual research activity. OVCR partners with faculty, academic leaders, and administrative units to support the full lifecycle of research -- from proposal development and sponsored project administration to research compliance, infrastructure stewardship, strategic investment, and external engagement. Through its mission-shaping and operational functions, OVCR advances UW-Madison's research excellence, fosters interdisciplinary collaboration, strengthens the institution's national and international research profile, and supports growth and diversification of the university's research portfolio in alignment with institutional priorities and the Wisconsin Idea.

Job Summary

The Data Analyst will support institutional reporting, analysis, and data-informed decision-making across OVCR, with primary responsibility for work associated with the Higher Education Research and Development (HERD) Survey, other institutional and external reporting requirements, and data related to OVCR centers and research activities. The position will provide dedicated capacity to coordinate data collection, ensure data quality and consistency, analyze and interpret information, and support timely and accurate reporting. The incumbent will utilize campus and other data sources to create regular reporting tools and ad hoc reports for analysis of grant activities, create and maintain an annual report on OVCR centers and units, and coordinate collaboration with other campus units on campus-wide research administration data. Applicants for this position will be considered for the following titles: Institutional Policy Analyst II (Inst) and Institutional Policy Analyst III (Inst). The title will be determined by the experience and qualifications of the finalist. This position requires work to be performed onsite in Madison, WI. Partial remote work, up to 40% (2 days/week), may be available for this position.

Key Job Responsibilities

• Prepares and disseminates institutional statistical reports to institutional programs, working units, and leadership
• Designs, collects, analyzes, and researches institutional data according to established procedures and regulations
• Works on topics that are increasingly complex and on matters that have significant impact to institutional operations
• 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
• 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
• Serves as liaison and primary contact to internal and external stakeholders for institutional reporting and compliance, external surveys, and institutional statistics and data

Compensation

The minimum starting salary for this position is: Institutional Policy Analyst II (Inst): $80,000 Institutional Policy Analyst III (Inst): $95,000 Starting salary is negotiable based on experience and qualifications. Employees in this position can expect to receive benefits such as generous vacation, holidays, and sick leave; competitive insurances and savings accounts; and retirement benefits. Please review the summary of benefits for more information.

Required Qualifications

• 3 or more years of professional experience in research, analytical, or general administration, preferably within a higher education environment.

Preferred Qualifications

• Strong analytical and organizational skills
• Strong problem-solving skills
• Ability to synthesize and communicate complex data and analyses clearly to a variety of audiences
• Evidence of ability to exercise good judgment and discretion{"Must be detail-oriented"}
• A transparent and collaborative work style
• Relevant work experience in data management, data analysis, data visualization, and reporting
• Ability to draw on the university's enterprise systems and write queries to extract data from large data sets
• Ability to obtain and analyze data with automated tools (Excel, Tableau, Workday, Denodo, etc)
• Knowledge of forecasting and modeling tools, ability to perform complex analyses of financial data and to present information effectively in written and graphic reports
• General understanding of university research administration

Education

Bachelor's degree required Master's degree preferred

Eligibility and Authorization

Please note that successful applicants are responsible for ensuring their eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without need of employer sponsorship) on or before the effective date of appointment.

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.

Background Checks and Safety

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.

Workplace Culture and Community

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.

Contact Information

Hannah Rickey, [e-mail]