Skip to main content

This job has expired

WORKDAY REPORTING AND PRISM DEVELOPER

Salary:

Minimum $77,100 Maximum $143,300 ANNUAL (12 months)
Depending on Qualifications

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

Education:

Preferred
Bachelor's Degree

Qualifications:

Required
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

Preferred
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

Work Type:

Full Time: 100%

This position may require some work to be performed in-person, onsite, at a designated campus work location. Some work may be performed remotely, at an offsite, non-campus work location.

Appointment Type, Duration:

Ongoing/Renewable


Additional Information:

Anticipated duration of this position is 24-30 months. 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: https://atp.wisconsin.edu/join-the-team/ .

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 "" 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

Contact:

Daniel Mccusky
daniel.mccusky@wisc.edu
608-262-2034
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Official Title:

DW Eng/Developer II(IT117)

Department(s):

A02-GENERAL SERVICES/A0201/G SERV/ATP

Employment Class:

Academic Staff-Renewable

Job Number:

276963-AS



The University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, 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 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: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/

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: Mar 29 2023 Central Daylight Time
Applications Close: Apr 12 2023 11:55 PM Central Daylight Time

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert