Penn State Job Catalog

Additional levels that exist for this job profile can be seen below.

The defined natural career progression within or between job profiles.

Data Warehouse Programming

Data Warehouse Programming Specialists perform duties related to data warehouse design and configuration. Provide support for data warehouse and responsible for coding and documenting procedures, and programming, testing and debugging data warehouses.

• Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements
• Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies
• Develop data models for data warehouse, data dictionaries to provide thorough and clear definitions of data.
• Verify the structure, accuracy, or quality of warehouse data
• Provide or coordinate troubleshooting support for data warehouses
• May supervise staff members, including hiring, development, and performance management

Level:

– Intermediate Professional

Base Description:

– Completes activities, tasks, and/or projects of a functional nature.

Level Summary:

– Demonstrates ability to perform intermediate tasks in defined skill areas. Demonstrates intermediate knowledge of internal procedures. Works under general supervision, performing assignments that may be varied and sometimes difficult. Supports team decisions and follows through with team responsibilities. Interprets and communicates information clearly and accurately. Demonstrates intermediate problem–solving skills.

Supervisory Responsibilities:

– May serve as direct supervisor for part–time, student, and/or temporary workers or volunteers

Fiscal Responsibilities:

– May validate and pay invoices

Problem Solving:

– Encounters generally routine problems; occasionally faces more complex and/or varied problems
– Typically follows recommended course of action and procedures to resolve problems
– Applies knowledge of larger unit goals, priorities, and related procedures in determining course of action

Independence of Action:

– Work is generally monitored by supervisor
– Detailed instructions and procedures are generally provided
– Uses available guidelines to make appropriate adaptations to routine situations and refers other situations to supervisor

Communication and Collaboration:

– Communicates internally within working unit and/or the University
– May communicate with external audiences
– Collaborates closely with team members
– Interprets and communicates information, ideas and instructions clearly and accurately both verbally and in written materials intended for distribution

• Comp Grade – 10
• Minimum – $61,800.00
• MidPoint – $75,700.00
• Maximum – $89,600.00