Job Library

Standard Job Description

A standard job description describes work at a high level and connects UW job titles to similar job titles in the market. It is a general set of responsibilities, without regard to any specific employee, that describes the work an employee performs and their role and impact to the organization.

Salary information for jobs outside of salary ranges 15-35 is located on the UW System Compensation Appendices webpage.

Click here for the TTC Salary Ranges

Title Details
Job TitleData Warehouse Engineer/Developer II
Job CodeIT117
Scaled JobNo
Salary Grade26
Family NameInformation Technology
Sub Family NameIT Data Administration
Job Overview
Job SummaryDesigns, 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.
Job Responsibilities
  • 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
  • Conducts complex data exploration steps, such as profiling, understanding data quality, binning, pivoting, summarizing, and finding correlations on multiple data types and sources
  • 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
  • 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
  • Develops and documents the inventory of complex data warehouse assets including adding descriptions and making them discoverable for business use
  • 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
  • May provide code review, coaching, and oversight of the activities of lower level data modelers and data curation developers
  • 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
Additional Information
Employee CategoryAcademic Staff (AS)
Supervision RequiredNo
FLSA ExemptExempt
Education*Bachelor's Degree - Preferred Minimum

*All preferred education can be fulfilled with comparable experience, unless education is listed as required for the job.

Scaled Jobs in the Library

The title and salary structure continues the idea of creating additional job titles for some jobs found systemwide or university-wide based on a small, medium, and large designation. We call this scaling. If there is a scaled job available, universities should choose that job for their employees.

  • Scaling is not title progression.
  • Scaling is a type of further refining the market pricing for a job.
  • For example,

    Title

    TTC Title

    ASSOC DIR, ATHL/L

    Athletics Assoc Dir

    ASSOC DIR, ATHL/M

    Athletics Assoc Dir (B)

    ASSOC DIR, ATHL/S

    Athletics Assoc Dir (C)

Key

Institution Scale
System A – no ( )
Milwaukee A – no ( )
Eau Claire (B)
La Crosse (B)
Oshkosh (B)
Platteville (B)
Stevens Point (B)
Stout (B)
Whitewater (B)
Green Bay (C)
River Falls (C)
Parkside (C)
Superior (C)

Scale is based on the size and budget of a university.

(Inst)

(Inst) typically designates institution-wide or systemwide scope and a non-institution version of the same job title typically indicates use at a School/College/Division/Department-level.

Minimum Education Requirements

The minimum preferred education represent the systemwide shared minimum elements of each job description. When posting for an open position, universities can add additional requirements or preferences to their specific recruitment.

[updateD September 12, 2022]