This library has titles, salaries, and information for all jobs at UW–Madison.
Academic Staff, University Staff, and Limited Appointee Titles
Standard job descriptions are only available for academic staff, university staff, and limited appointee titles. These titles and salaries are matched to the market.
A standard job description describes work at a high level and connects university jobs to similar jobs in the market. It reflects a general set of job responsibilities without regard to any specific employee. It describes the work, role, and organizational impact. A position description is unique to an individual employee.
If you need a copy of your position description, contact your local human resources professional.
Resources
- Salary Structure
- Job Groups & Subgroups
- Benefits Estimator
- Compensation Philosophy
- What Is a Salary Structure?
- How UW Compares Pay to the Market
- Pay Increases
- How To Progress in Pay
- Career Progression and Promotion Video
- Standard Job Description and Position Description
- Manager/Supervisor Compensation Resources
Questions?
If you have additional questions, please contact the local human resources contact where you work.
Search the Library
Data Warehouse Engineer/Developer II
Job Group: Information Technology
Job Subgroup: IT Data Administration
Salary Range (Annual):
26: $77,100-157,630 Employee Category: Academic Staff
Job Code: IT117
-
Job Summary:
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.
-
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
-
Education:
Bachelor's Degree Preferred Minimum
-
FLSA Status:
Exempt
-
Institution Job:
No
-
Required Supervisory Duty of at Least 2.0 Full-Time Equivalent (FTE) Employees:
No
- Employee Category:
Academic Staff
- Scaled Job:
No
- Salary Range (Annual):
26: $77,100-157,630
- Job Code:
IT117: Data Warehouse Engineer/Developer II
- Link directly to this job title: https://hr.wisc.edu/standard-job-descriptions/?q=IT117