Skip to main content Skip to navigation

The jobs website is experiencing technical issues and you may not be able to complete an application. We are working on this issue and hope to have it resolved shortly. Please check back later.

University of Wisconsin–Madison

Jobs at UW

University of Wisconsin–Madison



Apply now(opens in a new window) Job no: 259491-AS
Work type: Remote, Staff-Full Time
Department:G SERV/ATP
Location: Madison
Categories: IT Data Administration

Job Summary:

ATP is transforming the finance, human resources, and research administration support environment across the UW-System, while focusing on people, processes, and technology. This includes the selection and implementation of a new Enterprise Resources Planning (ERP) system (Workday) to support the changes. The activities will include the review and redesign of business processes (including use of shadow and bolt-on IT systems), redesign of the chart of accounts, and integration of efforts with several ongoing University and UW System projects. The Workday Reporting and Prism Developer will serve a vital role within the Administrative Transformation Program (ATP). The University of Wisconsin is embarking on the ATP to redesign its Human Resources and Financial systems and services, while focusing on people, processes, and technology.

The Workday Reporting and Prism Developer will be responsible for development of Prism use cases and pipelines, developing complex Workday reports and dashboards, and leveraging deep Workday skillsets to find solutions to complex business problems. The Prism Developer will primarily focus on using Prism to ingest external data into Workday using industry best practices and creating intuitive reports and dashboards to reflect the combined datasets. While Prism is not a data warehouse itself, it shares many of the same attributes of data warehousing (extracting and transforming data, documenting data models, securing data, data cleansing, etc.) The Workday Reporting and Prism Developer may also act as a Workday data Subject Matter Expert when pushing Workday data into larger Enterprise Data Warehouse solutions outside of ATP.

Responsibilities: Designs, develops, and troubleshoots complex core Data Warehouse and Business Intelligence build, test, and deployment activities. May oversee and evaluate the work of lower-level data warehouse developers.
  • 10% Conducts assessments and/or provides recommendations of source connections options for access and optimal data pipelines for development. Develops and unit tests high-complexity load and/or mappings across a suite of tools and deploys to production
  • 10% Conducts complex data exploration steps, such as profiling, understanding data quality, binning, pivoting, summarizing, and finding correlations on multiple data types and sources

  • 25% Designs and/or builds, tests, and deploys conceptual, logical, and physical data models according to specifications and standards for document naming, security, lifecycle, and retention architectures. May provide architecture options analysis

  • 10% Designs, and/or builds, tests, and deploys the data cleansing, integration, and transformation of more complex data in accordance with the defined target data model, based on enterprise data definitions and quality measures provided by data stewards
  • 20% Develops and documents the inventory of complex data warehouse assets including adding descriptions and making them discoverable for business use
  • 10% Presents the results of highly complex recommendations to address data quality issues, and coaches lower-level staff in performing data quality clean-up initiatives with metrics and reports
  • 5% May provide code review, coaching, and oversight of the activities of lower level data modelers and data curation developers
  • 10% May consult with data subject matter experts to document and address data quality issues and ensure data is assured. May support data quality clean-up initiatives with metrics and reports
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.

For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion


Bachelor's Degree


1. Experience developing Workday Prism Analytics pipelines or developing reports in Workday
2. Experience in analysis, design, and/or implementation of reporting solutions
3. Experience on cross-functional teams of diverse individuals

1. Experience with data governance
2. Experience with cloud data warehousing and ETL development
3. Experience working in a higher education setting
4. Experience working on an ERP implementation
5. Experience in Finance, Human Resources, or Research Administration

COVID-19 Considerations:

UW-Madison continues to follow necessary health and safety protocols to protect our campus from COVID-19. All employees remain subject to the COVID-19 Workplace Safety Policy: Please visit for the most up-to-date information.

Work Type:

Full Time: 100%

It is anticipated this position will be remote and requires work be performed at an offsite, non-campus work location.

Appointment Type, Duration:



Minimum $77,100 Maximum $143,300 ANNUAL (12 months)
Depending on Qualifications
Starting salary is negotiable based on experience and qualifications.

Additional Information:

Anticipated duration of this position is 3-4 years. End date is dependent upon project completion.

The Administrative Transformation Program (ATP) is hiring for multiple vacancies across transformation areas (Finance, Human Resources, Research Administration, and Information Technology). By applying to this position, applicants may be considered for vacancies in all transformation areas. Current job opportunities with ATP can be found here:

This position will operate in a hybrid format where some work will be performed in-person, onsite, in Madison, WI, and some work will be performed remotely, at an offsite, non-campus location. Ability for full-time remote work may be possible.

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.

How to Apply:

To begin the application process, click the "apply now" button. Please submit a resume and cover letter detailing your related work experience and professional background to the qualifications and duties in this job description, in particular:
1. Experience developing Workday Prism Analytics pipelines and Workday Reporting
2. Experience on cross-functional teams of diverse individuals
3. In depth knowledge of industry best practices in data management and analysis
4. Experience in analysis, design, and/or implementation of reporting solutions


Daniel Mccusky
Relay Access (WTRS): 7-1-1 (out-of-state: TTY: 800.947.3529, STS: 800.833.7637) and above Phone number (See RELAY_SERVICE for further information. )

Official Title:

DW Eng/Developer II(IT117)



Employment Class:

Academic Staff-Renewable

Job Number:


  The University of Wisconsin is an Equal Opportunity and Affirmative Action Employer. We promote excellence through diversity and encourage all qualified individuals to apply.

If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website:

Employment will require a criminal background check. It will also require you and your references to answer questions regarding 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.

Applications Open: Central Daylight Time
Applications Close: Central Daylight Time

Back to search results Apply now Refer a friend

Share this:

| More