Title and Standard Job Description Library

• Job Summary: The job summary is a brief statement explaining the primary functions of the job, including its main purpose and overall goal.
  Leads the design, development, and troubleshooting of complex core Data Warehouse and Business Intelligence design, build, test, and deployment activities. Conducts non-routine system analysis, contributes to strategy development, and provides training and technical guidance to lower level staff.
• Job Responsibilities: Job responsibilities are the core job duties that people in this job usually perform.
  • Provides strategic guidance on approaches to highly complex enterprise warehouse solutions, data exploration steps, data model options, and data cleansing, integration, and transformation
  • Leverages deep expertise (or certifications) across a variety of functions and tools to guide formal evaluations and recommendations for strategic investments and product roadmaps
  • Develops and documents standards and procedures for data mappings, data quality assessments, model architectures, and data curation
  • Provides strategic guidance on approaches to documentation of the data warehouse inventory of assets
  • Works with data stewards to design and implement data governance tools and methodologies
  • Designs project plan work packages and resource assignments to meet quality, on-time delivery of team work products. Contributes to technical delivery status reporting for multiple in-process projects, and develops and implements complex mitigation strategies/options
• Education: Education describes the minimum level of education that people in this job usually have. Education that is a preferred minimum is recommended for this job but not required. Relevant work experience can satisfy preferred minimum education. A hiring manager may include additional education requirements when recruiting for a position.
  Bachelor's Degree Preferred Minimum
• FLSA Status: Federal regulations determine Fair Labor Standards Act (FLSA) status. Employees who are non-exempt receive overtime pay when they work more than 40 hours in a week. Employees who are exempt do not receive overtime pay when they work more than 40 hours in a week.
  Exempt
• Institution Job: A job that has primary responsibilities that impact the majority or the entirety of the institution, or has significantly larger scope than the school/college/division in which it resides, and typically contains “(Inst)” in the job title or mentions “institution” or “enterprise” in a standard job description.
  No
• Required Supervisory Duty of at Least 2.0 Full-Time Equivalent (FTE) Employees: The supervisor directly oversees the equivalent of at least 2.0 FTE employees or indirectly oversees one or more supervisors. The supervisor has the authority to hire, transfer, suspend, promote, manage conduct and performance, discharge, assign, reward, and discipline employees. The supervisor typically reviews the work of employees and may approve employee timesheets.
  No
• Employee Category: Each employee category is unique in type of work performed, job security, benefits package, and/or ability to organize unions. Assignment to an employee category is based upon job title. Refer to the UW–Madison Employment Categories policy for more information.
  Academic Staff
• Scaled Job: Jobs with the same title may have a different scope of work based on the school, college, or division where the work is performed. Scaling recognizes these differences based on the scope, impact, and complexity of the work performed. A scaled job title has multiple salary grades to align with market data. Learn more about job scaling.
  No
• Salary Range (Annual): Jobs in the same salary grade have similar pay in the market. Each salary grade has a salary range that includes a minimum and a maximum. A job is paid between the minimum and maximum of its salary grade. Learn more about UW's salary structure.
  28: $110,197-204,967
• Job Code: A job code identifies jobs in the university’s human resources system.
  IT118: Data Warehouse Engineer/Developer III

Knowledges and Skills Learning Resources

Each standard job description is linked to a list of knowledges and skills. Knowledges and skills are optional resources to support employee learning and development. Visit the Knowledges and Skills Learning Resources website to learn more.

• Knowledges: Understanding of concepts.
  Learn more about knowledges and skills.
  • Administration and Management
  • Computers and Electronics
  • Design
  • Engineering and Technology
  • Mathematics
• Skills: Capabilities and proficiencies developed through training and experience. Learn more about knowledges and skills.
  • Complex Problem Solving
  • Critical Thinking
  • Judgment and Decision Making
  • Reading Comprehension
  • Systems Analysis